DB2 - Problembeschreibung
Problem IT28195 | Status: Geschlossen |
UNEXPECTED SQLP_LTIMEOUT ERROR CAN CAUSE ABNORMAL DATABASE SHUTDOWN. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
Error Description Abnormal database shutdown is seen after the following message in db2diag.log: 2019-02-06-11.54.17.652495+060 I43829055E798 LEVEL: Severe PID : 68357 TID : 17723710959968 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 004 DB : SAMPLE APPHDL : 0-6383 APPID: xxxxxxxxxxxxxxx AUTHID : xxxxxxxxxxxx HOSTNAME: node0102-fab EDUID : 53117 EDUNAME: db2agnta (SAMPLE) 0 FUNCTION: DB2 UDB, data management, sqldCriticalSectionEnd, probe:128 CALLED : DB2 UDB, data management, sqldProtectPendAct RETCODE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT "LockTimeOut - tran rollback Reason code 68" CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x0000000000000000 ?unknown + 0x0 [1] 0x0000000000000000 ?unknown + 0x0 This issue only occurs when a lock wait event monitor is being used. Another symptom is panic causing abnormal shutdown of DB2 during online REORG 2019-01-01-22.13.29.584101-240 I520089A1024 LEVEL: Severe PID : 31064496 TID : 9200 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-26770 APPID: xxxxxx AUTHID : DB2UDB HOSTNAME: test EDUID : 990 EDUNAME: db2reorg (SAMPLE) 0 FUNCTION: DB2 UDB, data management, sqldChangeToCleanupPhase, probe:10 MESSAGE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT "LockTimeOut - tran rollback Reason code 68" DATA #1 : String, 18 bytes upgrade cleanLock: DATA #2 : SQLP_LOCK_INFO, PD_TYPE_SQLP_LOCK_INFO, 144 bytes lockname 00021A0100000001000000006A SQLP_ONLINEREORG (obj={2;6657;1}) pLRB a000300198e9980 prevIntent .IN curIntent .IN intent .IX duration 1 rlInFlags 0x00001100 rlOutFlags 0x00000000 rlTimeout NO_TIMEOUT cursorBitmap 0x40000000 rrIIDin 0 rrIIDout 0 priority 2 pEHLState 0000000000000000 rlUserData.UNKNOWN 0000 0000 0000 0000 ........ dataPtr 0 With function stack: pthread_kill sqloDumpEDU sqle_panic IPRA.$sqldChangeToCleanupPhase sqldDoCleanupLogEndMovePhase sqldPerformOlrRowMovement sqldOnlineTableReorg sqldOLRInvoke sqleIndCoordProcessRequest RunEDU | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
Disable the use of lock wait event monitor. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.02.2019 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |