suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)