Document Actions

SQL1224N - DB2 has terminated your connection

The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated your particular request due to an error or a force interrupt. SQLSTATE=55032

A - Errors

diag.log error

2009-02-10-12.05.08.468869-120 E5608480G771       LEVEL: Error
PID     : 7528                 TID : 2946493328 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE
APPHDL : 0-100                APPID: *LOCAL.db2inst1.090210140319
AUTHID : DB2INST1
EDUID   : 64                   EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:560
MESSAGE : ADM1542W Application "db2bp" with application handle "0-100" and
          application id "*LOCAL.db2inst1.090210140319" executing under
          authentication id "DB2INST1" will be forced off of the database for
          violating database configuration parameter MAX_LOG (current value
          "10"). The unit of work will be rolled back.

command line error

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1224N The database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated your particular request
due to an error or a force interrupt. SQLSTATE=55032

B - CAUSES

An application is using more than MAX_LOG percentage of logs to execute an UOW, so, you have to increase the dbcfg MAX_LOG parameter.

DATABASE NAME=sample

db2 get db cfg for sample | grep -i MAX_LOG

Output:

Percent max primary log space by transaction (MAX_LOG) = 10

C - RESOLVING

Set the the MAX_LOG to be infinity, the value 0 is infinity.

db2 update db cfg for sample using MAX_LOG 0

DBA to DBA

Personal tools