Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
When a restore is abnormally terminated (db2agent or client process killed, db2_kill or some other abnormal termination due to an error), a subsequent restore into the same database directory may result in a dbseed mismatch error upon rollforward. The abnormal termination of the restore causes a subsequent restore to use a default database configuration file instead of the backup image database configuration file, resulting in the dbseed mismatch errors. Example db2diag.log messages: 2008-03-27-08.22.26.526022-300 I240218E516 LEVEL: Severe PID : 30324 TID : 47559930276160PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-670 APPID: *LOCAL.db2inst1.080327132226 AUTHID : DB2INST1 EDUID : 113 EDUNAME: db2agent (SAMPLE) FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100 DATA #1 : Hexdump, 4 bytes 0x00000002010E8D5C : A3FB FFFF .... Another behavior has been observed for databases without automatic storage enabled The default database configuration file is created with the automatic storage flag enabled and under the same abnormal termination conditions the use of this default configuration file with a database image that does NOT have automatic storage results in the following error in the db2diag.log at rollforward: 2008-05-10-18.01.45.374895-240 I3967A657 LEVEL: Severe PID : 27629 TID : 1 PROC : db2agent (SAMPLE) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-34 APPID: *LOCAL.db2idea1.080510220145 AUTHID : DB2IDEA1 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, 49 bytes /opt/db2inst1/db2inst1/NODE0000/SQL00006/SQLSGF.1 DATA #2 : Boolean, 1 bytes false DATA #3 : Boolean, 1 bytes true DATA #4 : Boolean, 1 bytes false The underlying issue is the same as the use of the default configuration file instead of the backup image configuration file in this instance is at the root of the problem.
Local fix
Manual cleanup of the database files located in the database path after abnormal termination of restore will allow subsequent restore and rollforward to complete successfully.
Problem summary
Users Affected: Any doing a restore Problem Description: if a restore terminates abnormally, it can cause the subsequent restore to fail. Problem Summary: see above
Problem conclusion
Problem was first fixed in Version 9.1 FixPak 6.
Temporary fix
Manual cleanup of the database files located in the database path after abnormal termination of restore will allow subsequent restore and rollforward to complete successfully.
Comments
APAR Information
APAR number
LI73498
Reported component name
DB2 UDB WSE LIN
Reported component ID
5765F3504
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-06-07
Closed date
2008-10-31
Last modified date
2008-10-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB WSE LIN
Fixed component ID
5765F3504
Applicable component levels
R810 PSN
UP
R820 PSN
UP
R910 PSN
UP
R950 PSN
UP
Document Information
Modified date:
15 October 2021