Why do I get ADM1823E and DIA8309C via DB2 9.5 db2diag.log file?

Technote (troubleshooting)


Problem(Abstract)

DB2 9.5 shows the following error messages at the db2diag.log file:
-ADM1823E: The active log is full and is held by application handle
"<appl_handle>". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
-DIA8309C: Log file was full

Diagnosing the problem


The db2diag.log is displaying 2 error messages stating that the active
log is full. For instance:


2009-12-01-03.46.51.774000-360 E33840833H507 LEVEL: Error
PID : 3972 TID : 6112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SUDB
APPHDL : 0-923 APPID: *LOCAL.DB2.091201094635
FUNCTION: DB2 UDB, data protection, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application
handle
"923". Terminate this application by COMMIT, ROLLBACK or
FORCE
APPLICATION.

2009-12-01-03.46.51.774000-360 I33841342H471 LEVEL: Error
PID : 3972 TID : 6112 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SUDB
APPHDL : 0-923 APPID: *LOCAL.DB2.091201094635
FUNCTION: DB2 UDB, data protection, sqlpWriteLR, probe:6680
RETCODE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.


Resolving the problem

  • This scenario indicates that application handle (in this case 923) is holding the active
    log space. So you could find out what the application handle is doing and why
    it's not issuing frequent commits. You can use the following command to
    get information about the application while the condition is present:

      db2 get snapshot for application agentid <appl handle> (where
      <applhandle> is the application handle reported in the db2diag.log)
  • Another option is just force the application. This will release the log space and the
    logging will continue.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.5

Operating system(s):

AIX, HP-UX, Linux, Solaris

Reference #:

1418115

Modified date:

2011-06-19

Translate my page

Machine Translation

Content navigation