Toad World® Forums

Error while running the create objects on DB2


#1

Hi,

I have a db2 database on a linux host.

I am running the TPC-E benchmark from a windows host which connects to the db2 database on linux host.

The create objects for TPC-E is failing with the below error;

ODBC Error (57011,FFFFFC3C) - [IBM][CLI Driver][DB2/LINUXX8664] SQL0964C The transaction log for the database is full. SQLSTATE=57011
Error loading E_CASH_TRANSACTION
ODBC Error (57011,FFFFFC3C) - [IBM][CLI Driver][DB2/LINUXX8664] SQL0964C The transaction log for the database is full. SQLSTATE=57011
Error loading E_SETTLEMENT
ODBC Error (57011,FFFFFC3C) - [IBM][CLI Driver][DB2/LINUXX8664] SQL0964C The transaction log for the database is full. SQLSTATE=57011
Error loading E_NEWS_ITEM
ODBC Error (57011,FFFFFC3C) - [IBM][CLI Driver][DB2/LINUXX8664] SQL0964C The transaction log for the database is full. SQLSTATE=57011

I tried increasing the logfile size as mentioned in few google searches.

Can you please help me out in understanding whether I am missing anything ?

Thanks,

Nikhil.


#2

Hate to be the bearer of bad news - this is a DB2 config issue and not a problem with BMF. Best advice is to get help from a knowledgeable DB2 DBA type person. All BMF does is create some tables, load some data, create some indexes and then run standard SQL as per the TPC spec. Errors like this are 98% of the time database config/optimization items.