|
Problem IC78490
|
Status: Closed |
WHEN THERE ARE APPLICATIONS IN ROLLBACK OR COMMIT STATE, DB2 SNAPSHOT MONITOR MAY RETURN SQL1042C ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
when there are applications in rollback or commit state, db2 get
snapshot for locks on <db2_name> may receive sql1042c error.
E.g.
$ db2 get snapshot for locks on sample
SQL1042C An unexpected system error occurred. SQLSTATE=58004
Some other utility which relies on the service of monitor
component could also be affected, e.g db2top. In db2top, using
'U' option to collect lock information may also cause db2top
exited with sql1042c error.
The following records could be found in db2diag.log if turning
on the database manager configuration parameter DIAGLEVEL to 4:
2013-03-12-03.43.12.074851-240 I243248E595 LEVEL: Info
PID : 19365 TID : 46913030187328 KTID :
xxxxxx
PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-21 APPID:
*LOCAL.db2inst1.130312073953
AUTHID : DB2INST1 HOSTNAME: host123
EDUID : 41 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, database monitor, sqm_snap_appl_locks,
probe:10
DATA #1 : <preformatted>
Snapshot cannot obtain lock information for application with app
handle 13. Application in commit/rollback.
The following records could be found in db2 trace:
| | | | sqm___sqm_write_lock_waits entry [eduid 224497 eduname
db2agent]
| | | | sqm___sqm_write_lock_waits exit
| | | sqm_snap_appl_locks data [probe 10]
| | | sqm_snap_appl_locks exit [rc = 0x000004D2 = 1234]
| | sqm___sqm_snap_db_locks exit [rc = 0x000004D2 = 1234]
| | sqm___sqm_free_dbcb_list entry [eduid 224497 eduname
db2agent]
| | sqm___sqm_free_dbcb_list exit
| sqm___sqlmonssagnt exit [rc = 0x000004D2 = 1234]
| sqlm_buffer_postprocess entry [eduid 224497 eduname db2agent]
| sqlm_buffer_postprocess data [probe 1]
| sqlm_buffer_postprocess data [probe 2]
| sqlm_buffer_postprocess exit
| sqm___sqlmfree entry [eduid 224497 eduname db2agent]
| sqm___sqlmfree exit [rc = 0xFFFFFFFF = -1]
sqm___sqlmonssbackend exit [rc = 0xFFFFFFFF = -1] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* when there are applications in rollback or commit state, db2 *
* get *
* snapshot for locks on <db2_name> may receive sql1042c error. *
* *
* *
* *
* E.g. *
* *
* *
* *
* $ db2 get snapshot for locks on sample *
* *
* SQL1042C An unexpected system error occurred. *
* SQLSTATE=58004 *
* *
* *
* Some other utility which relies on the service of monitor *
* *
* component could also be affected, e.g db2top. In db2top, *
* using *
* 'U' option to collect lock information may also cause db2top *
* *
* exited with sql1042c error. *
* *
* *
* *
* The following records could be found in db2 trace: *
* *
* *
* *
* | | | | sqm___sqm_write_lock_waits entry [eduid 224497 *
* eduname *
* db2agent] *
* *
* | | | | sqm___sqm_write_lock_waits exit *
* *
* | | | sqm_snap_appl_locks data [probe 10] *
* *
* | | | sqm_snap_appl_locks exit [rc = 0x000004D2 = 1234] *
* *
* | | sqm___sqm_snap_db_locks exit [rc = 0x000004D2 = 1234] *
* *
* | | sqm___sqm_free_dbcb_list entry [eduid 224497 eduname *
* *
* db2agent] *
* *
* | | sqm___sqm_free_dbcb_list exit *
* *
* | sqm___sqlmonssagnt exit [rc = 0x000004D2 = 1234] *
* *
* | sqlm_buffer_postprocess entry [eduid 224497 eduname *
* db2agent] *
* | sqlm_buffer_postprocess data [probe 1] *
* *
* | sqlm_buffer_postprocess data [probe 2] *
* *
* | sqlm_buffer_postprocess exit *
* *
* | sqm___sqlmfree entry [eduid 224497 eduname db2agent] *
* *
* | sqm___sqlmfree exit [rc = 0xFFFFFFFF = -1] *
* *
* sqm___sqlmonssbackend exit [rc = 0xFFFFFFFF = -1] *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 db2_v97fp6 *
**************************************************************** |
| Local Fix: |
using db2pd -locks -db <db_name> to collect lock information |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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 |
The fix will be included in DB2 db2_v97fp6 |
| Workaround |
using db2pd -locks -db <db_name> to collect lock information |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.09.2011
06.06.2012
13.03.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
