DB2 - Problem description
Problem IT26559 | Status: Closed |
WHEN DB2_ONLINERECOVERY FEATURE IS ENABLED, ENCOUNTER DATABASE OUTAGE AFTER CRASH RECOVERY. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The following messages can be used to identify this problem: 2018-10-05-13.21.36.660260-240 I93539A535 LEVEL: Info PID : 5570650 TID : 2572 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-7 APPID: *LOCAL.db2inst1.181005171914 AUTHID : db2inst1 HOSTNAME: host_a EDUID : 2572 EDUNAME: db2agent (TESTDB) FUNCTION: DB2 UDB, recovery manager, sqlprudm, probe:60120 DATA #1 : Asynchronous backward phase of database recovery is required, numDeferredTran 2 2018-10-05-13.21.39.422465-240 I116031A491 LEVEL: Info PID : 5570650 TID : 2572 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-21 APPID: *LOCAL.DB2.181005172151 HOSTNAME: host_a EDUID : 2572 EDUNAME: db2agent (TESTDB) FUNCTION: DB2 UDB, recovery manager, sqlprAsyncUndo, probe:101 DATA #1 : Asynchronous backward phase of database recovery has been started 2018-10-05-13.21.49.583863-240 I137680A840 LEVEL: Severe (Origin) PID : 5570650 TID : 2572 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-21 APPID: *LOCAL.DB2.181005172151 HOSTNAME: host_a EDUID : 2572 EDUNAME: db2agent (TESTDB) FUNCTION: DB2 UDB, data management, sqldFixExistingTCB, probe:13572 MESSAGE : ZRC=0x8604000B=-2046558197=SQLD_NOENT "OBJECT DOES NOT EXIST" DIA8412C A table "" could not be found. DATA #1 : poolID, PD_TYPE_SQLD_POOL_ID, 4 bytes 0x0000000A DATA #2 : objectID, PD_TYPE_SQLD_OBJECT_ID, 4 bytes 0x0000000B DATA #3 : objectClass, PD_TYPE_SQLD_OBJECT_CLASS, 4 bytes SQLB_PERMANENT DATA #4 : tcbFixFlags, PD_TYPE_SQLD_TCB_FIXFLAGS, 4 bytes 0x00000006 - TCB_NOLOAD - TCB_EXPECT_BADIX | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * **************************************************************** | |
Local Fix: | |
Disable DB2_ONLINERECOVERY feature. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.10.2018 27.11.2018 27.11.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |