LI72951: BAD DATA PAGE BELONGING TO ANOTHER TABLE ENCOUNTERED DURING BUILD PHASE OF A LOAD OPERATION AGAINST AN MDC TABLE

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 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