IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 October 2021