Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 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 you LOAD INSERT into an MDC table which resides in a DMS tablespace, the LOAD operation may fail in the BUILD phase because a stale data page belonging to another table in the same tablespace is extracted from bufferpool. In the db2diag.log, the message "sqlpbrdpg, probe:1146" is dumped. This probe point is the eye-catcher for this APAR. For example, you may get the following db2diag.log messages during LOAD. 2007-03-12-17.45.26.005920+540 I6418849G459 LEVEL: Warning PID : 628 TID : 3005417984 PROC : db2lfrm0 3 INSTANCE: bilinst1 NODE : 003 DB : BILLDB APPHDL : 0-1330 APPID: *N0.bilinst1.070312084519 FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0 DATA #1 : String, 103 bytes LOADID: 27989.2007-03-12-17.45.20.543328.0 (8;58) Starting BUILD phase at 03/12/2007 17:45:26.004041. 2007-03-12-17.45.26.100160+540 I6419309G452 LEVEL: Error PID : 628 TID : 3005417984 PROC : db2lfrm0 3 INSTANCE: bilinst1 NODE : 003 DB : BILLDB APPHDL : 0-1330 APPID: *N0.bilinst1.070312084519 FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:1146 RETCODE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header" DIA8547C An error occurred in a database page header. 2007-03-12-17.45.26.145122+540 I6419762G470 LEVEL: Error PID : 628 TID : 3005417984 PROC : db2lfrm0 3 INSTANCE: bilinst1 NODE : 003 DB : BILLDB APPHDL : 0-1330 APPID: *N0.bilinst1.070312084519 FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:1146 DATA #1 : String, 120 bytes Obj={pool:8;obj:58;type:0} State=x27 Parent={8;58}, EM=3726, PP0=3744 Page=89568 Cont=0 Offset=89586 BlkSize=15 BadPage In the call stack, you will see the function sqluMDCSetFullBit sqlbLogErr sqlbrdpg sqlbReadPage sqlbfix sqluMDCSetFullBit squBuildIndexes sqluldat sqloSpawnEDU
Local fix
Add the "modified by pagefreespace=10" to the LOAD command.
Problem summary
Bad data page belonging to another table encountered during build phase of a load operation against an MDC table which resides in a DMS tablespace
Problem conclusion
Problem was first fixed in Version 9.1 FixPak 5
Temporary fix
Comments
APAR Information
APAR number
LI72951
Reported component name
DB2 UDE ESE LIN
Reported component ID
5765F4104
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-12-17
Closed date
2008-06-27
Last modified date
2008-06-27
APAR is sysrouted FROM one or more of the following:
LI72212
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDE ESE LIN
Fixed component ID
5765F4104
Applicable component levels
R910 PSN
UP
Document Information
Modified date:
14 October 2021