|
Problem IC93097
|
Status: Closed |
ADM1823E MESSAGES TRUNCATE THE APPLICATION HANDLE HOLDING THE TRANSACTION LOGS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
ADM1823E messages in the db2diag.log truncate the application
handle which holds the transaction logs.
Example message :
2013-06-03-00.01.00.992248-240 E1595A587 LEVEL: Error
PID : 315458 TID : 49165 PROC : db2sysc
0
INSTANCE: <inst-name> NODE : 000 DB :
<db-name>
APPHDL : 0-50721 APPID: <application-id>
AUTHID : ITMUSER
...skipping...
EDUID : 49165 EDUNAME: db2agent (TDWDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace,
probe:2860
MESSAGE : ADM1823E The active log is full and is held by
application handle
"10..". Terminate this application by COMMIT,
ROLLBACK or FORCE
APPLICATION.
The application is shown as "10.." instead of the real
application handle |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Users can upgrade to DB2 Version 9.7 fix pack 9 or higher to *
* avoid this defect *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.7 fix pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2013
16.12.2013
16.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.,
9.7.,
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
