Help!! The transaction log for the database is full. SQLSTATE=57011

[attick111]

I have a set of scripts which I am executing on a Windows 2000 Server with UDB 7.2 and they all run fine provided I have a smaller set of records. However, when I attempt to processed a larger set I get an error as follows....

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0964C The transaction log for the database is full. SQLSTATE=57011


Example of one of the scripts. I get the same error when I execute an INSERT followed by a SELECT.

The relevant database config parameters for this database is as shown


Database heap (4KB) (DBHEAP) = 1000
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 32
Log buffer size (4KB) (LOGBUFSZ) = 200 (was 8)
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
Buffer pool size (pages) (BUFFPAGE) = 250
Log file size (4KB) (LOGFILSIZ) = 20000 (was 250)
Number of primary log files (LOGPRIMARY) = 50 (was 250)
Number of secondary log files (LOGSECOND) = 20 (was 2)
Changed path to log files (NEWLOGPATH) =
Path to log files = E:\DB2\NODE0000\SQL0003\SQLOGDIRFirst active log file = S0000168.LOG

As you can see from the above, I changed a couple of times the values for the LOGFILSIZ, LOGPRIMARY, LOGSECOND and finally LOGBUFSZ, when I saw the error message hoping this will help. It hasn't helped much. I am attempting to update about 52000 records.

Any assistance you can give me will be very appreciated.

Attick111

 

[grofaty]

Hi,

Did you disconect all application that are connected to database? Disconecting all application and connecting one application makes db2 to accept new settings.

You can disconect apps this with "force application" command.

Hope this helps,
Grofaty

 

[scottrisi]

See thread

Thread178-641780