The problem occurs when all of the following are true:
- The database was created with the automatic storage feature
disabled. Automatic storage has been on by default since DB2
version 9.1, so to get a database with this feature disabled,
you must either use the AUTOMATIC STORAGE NO option of the
CREATE DATABASE command, or upgrade a database created on an
older version of DB2.
- While automatic storage is disabled, a backup is taken using
the BACKUP DATABASE command.
- Automatic storage is enabled using the ADD STORAGE ON option
of the ALTER DATABASE command.
- The RESTORE DATABASE command is executed with both the
REDIRECT and GENERATE SCRIPT options to restore the backup that
was taken before automatic storage was enabled.
At this point, any attempt to execute ROLLFORWARD DATABASE or
CONNECT will fail with SQL code SQL0902C and messages similar to
the following will be written to the db2diag.log:
2014-10-30-11.06.22.095046-240 I1706E790 LEVEL: Severe
PID : 3711 TID : 469128246664 PROC : db2sysc
INSTANCE: dbusr1 NODE : 000 DB : SAMPLEDB
APPHDL : 0-42 APPID: *LOCAL.dbusr1.141030150621
AUTHID : DBUSR1
EDUID : 129 EDUNAME: db2agent (SAMPLEDB)
FUNCTION: DB2 UDB, buffer pool services,
sqlbInitStorageGroupTable, probe:25
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
DATA #1 : String, 52 bytes
/home/dbusr1/dbusr1/NODE0000/SQL00001/SQLSGF.2
DATA #2 : Boolean, 1 bytes
false
DATA #3 : Boolean, 1 bytes
true
DATA #4 : Boolean, 1 bytes
false
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Boolean, 1 bytes
false
2014-10-30-11.06.22.101233-240 I2497E756 LEVEL: Severe
PID : 3711 TID : 469128246664 PROC : db2sysc
INSTANCE: dbusr1 NODE : 000 DB : SAMPLEDB
APPHDL : 0-42 APPID: *LOCAL.dbusr1.141030150621
AUTHID : DBUSR1
EDUID : 129 EDUNAME: db2agent (SAMPLEDB)
FUNCTION: DB2 UDB, buffer pool services,
sqlbInitStorageGroupTable, probe:25
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic
error detected"
DIA8501C A buffer pool logic error has occurred.
DATA #1 : String, 44 bytes
Failed to initialize the storage group table
DATA #2 : Pointer, 8 bytes
0x0000000200d387b1
DATA #3 : Pointer, 8 bytes
0x0000000200d3d0f0
DATA #4 : Pointer, 8 bytes
0x0000000200d461c0 |
