IBM Support

LI74521: SEVERE ERROR AT SQLDB_UPDATEBLKONPAGE, PROBE:353

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Load Failure SQL0902N, RC=204..
    Insert to MDC range partitioned table generates error
    SQLDB_PRGERR (0x870400CC).
    This problem won't get detected so easily unless we happen to
    append a block that was a dictionary or system block.
    
    Here's the example stack of an application in this state.
    2009-05-15-12.31.41.350374+120 I2108511E564        LEVEL:
    Warning
    PID     : 26328                TID  : 47730210629952PROC :
    db2sysc 1
    INSTANCE: bcuinst1             NODE : 001          DB   : DWH
    APPHDL  : 0-934                APPID: *N0.bcuinst1.090515103135
    AUTHID  : BCUINST1
    EDUID   : 26957                EDUNAME: db2lfrm0 1
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg,
    probe:311
    DATA #1 : String, 136 bytes
    LOADID: 300.2009-05-15-12.31.36.199880.0 (65530;32851)
    Starting LOAD phase at 05/15/2009 12:31:41.350203. Table FRDW
    .F_TCK_EAN_CAB
    ...
    2009-05-15-12.40.51.402020+120 I2109076E1802       LEVEL: Error
    PID     : 26328                TID  : 47730210629952PROC :
    db2sysc 1
    INSTANCE: bcuinst1             NODE : 001          DB   : DWH
    APPHDL  : 0-934                APPID: *N0.bcuinst1.090515103135
    AUTHID  : BCUINST1
    EDUID   : 26957                EDUNAME: db2lfrm0 1
    FUNCTION: DB2 UDB, sqldb, sqldb_updateBlkOnPage, probe:353
    MESSAGE : ZRC=0x870400CC=-2029780788=SQLDB_PRGERR
              "Block Management Services program error"
              DIA8737C A block management services programming error
    occurred.
    DATA #1 : String, 36 bytes
    Illegal blockmap entry, after update
    DATA #2 : Hex integer, 4 bytes
    0x0000000B        <--- blockNumOnPage
    DATA #3 : Hex integer, 1 bytes
    0x82                    <--- oldBlockBits (SQLDB_INUSE +
    SQLDB_SYSTEM)
    DATA #4 : Hex integer, 1 bytes
    0x92                    <--- newBlockBits
    DATA #5 : Hex integer, 1 bytes
    0x90                    <--- posMask
    DATA #6 : Hex integer, 1 bytes
    0x00                    <--- negMask
    DATA #7 : unsigned integer, 4 bytes
    3                            <--- rc -  Rule 3. If SYSTEM is
    set, then nothing else may be set (other than INUSE)
    CALLSTCK:
      [0] 0x00002B66C2834F9F
    _Z21sqldb_updateBlkOnPageP13SQLD_DFM_WORKjhhmm + 0x461
      [1] 0x00002B66C283020D
    _Z18sqldb_blkMapAppendP13SQLD_DFM_WORKhji + 0x133
      [2] 0x00002B66C3BE43E6
    _Z21sqluMDCUpdateBlockMapP13SQLUCACB_TYPEP8sqeAgentP17SQLU_TRANS
    _BUFFERtjj + 0x2A2
      [3] 0x00002B66C3B7ED98
    /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CC0D98
      [4] 0x00002B66C3B7DFED
    _Z21sqluCreateAndInitPageP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE_D
    ESCS4_S4_tbh + 0x133
      [5] 0x00002B66C239CFE0
    _Z11sqlulGetRIDP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE_DESCS4_S4_P
    13SQLD_DPG_DATAlP18SQLU_DMRECORD_LISTPbPt + 0x1F6
      [6] 0x00002B66C3BB0DCD
    /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CF2DCD
      [7] 0x00002B66C3BB4918
    /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CF6918
      [8] 0x00002B66C3BB4163
    /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CF6163
      [9] 0x00002B66C3BAFDDF
    _Z18sqluRiddifyRecordsP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBP18SQL
    U_DMRECORD_LISTi + 0x291
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Load Failure SQL0902N, RC=204..                              *
    * Insert to MDC range partitioned table generates error        *
    * SQLDB_PRGERR (0x870400CC).                                   *
    * This problem won't get detected so easily unless we happen   *
    * to append a block that was a dictionary or system block.     *
    *                                                              *
    * Here's the example stack of an application in this state.    *
    * 2009-05-15-12.31.41.350374+120 I2108511E564 LEVEL: Warning   *
    * PID : 26328 TID : 47730210629952PROC : db2sysc 1             *
    * INSTANCE: instname NODE : 001 DB : DBNAME                    *
    * APPHDL : 0-934 APPID: *N0.instname.090515103135              *
    * AUTHID : instname                                            *
    * EDUID : 26957 EDUNAME: db2lfrm0 1                            *
    * FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg,   *
    * probe:311                                                    *
    * DATA #1 : String, 136 bytes                                  *
    * LOADID: 300.2009-05-15-12.31.36.199880.0 (65530;32851)       *
    * Starting LOAD phase at 05/15/2009 12:31:41.350203. Table     *
    * SCHEMA.TABLENAME                                             *
    * ...                                                          *
    * 2009-05-15-12.40.51.402020+120 I2109076E1802 LEVEL: Error    *
    * PID : 26328 TID : 47730210629952PROC : db2sysc 1             *
    * INSTANCE: instname NODE : 001 DB : DBNAME                    *
    * APPHDL : 0-934 APPID: *N0.instname.090515103135              *
    * AUTHID : instname                                            *
    * EDUID : 26957 EDUNAME: db2lfrm0 1                            *
    * FUNCTION: DB2 UDB, sqldb, sqldb_updateBlkOnPage, probe:353   *
    * MESSAGE : ZRC=0x870400CC=-2029780788=SQLDB_PRGERR            *
    * "Block Management Services program error"                    *
    * DIA8737C A block management services programming error       *
    * occurred.                                                    *
    * DATA #1 : String, 36 bytes                                   *
    * Illegal blockmap entry, after update                         *
    * DATA #2 : Hex integer, 4 bytes                               *
    * 0x0000000B                                                   *
    * DATA #3 : Hex integer, 1 bytes                               *
    * 0x82                                                         *
    * SQLDB_SYSTEM)                                                *
    * DATA #4 : Hex integer, 1 bytes                               *
    * 0x92                                                         *
    * DATA #5 : Hex integer, 1 bytes                               *
    * 0x90                                                         *
    * DATA #6 : Hex integer, 1 bytes                               *
    * 0x00                                                         *
    * DATA #7 : unsigned integer, 4 bytes                          *
    * 3                                                            *
    * CALLSTCK:                                                    *
    *   [0] 0x00002B66C2834F9F                                     *
    * _Z21sqldb_updateBlkOnPageP13SQLD_DFM_WORKjhhmm + 0x461       *
    *   [1] 0x00002B66C283020D                                     *
    * _Z18sqldb_blkMapAppendP13SQLD_DFM_WORKhji + 0x133            *
    *   [2] 0x00002B66C3BE43E6                                     *
    * _Z21sqluMDCUpdateBlockMapP13SQLUCACB_TYPEP8sqeAgentP17SQLU_TRA
    * + 0x2A2                                                      *
    *   [3] 0x00002B66C3B7ED98                                     *
    * /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CC0D98         *
    *   [4] 0x00002B66C3B7DFED                                     *
    * _Z21sqluCreateAndInitPageP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE
    * + 0x133                                                      *
    *   [5] 0x00002B66C239CFE0                                     *
    * _Z11sqlulGetRIDP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE_DESCS4_S4
    * + 0x1F6                                                      *
    *   [6] 0x00002B66C3BB0DCD                                     *
    * /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CF2DCD         *
    *   [7] 0x00002B66C3BB4918                                     *
    * /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CF6918         *
    *   [8] 0x00002B66C3BB4163                                     *
    * /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x2CF6163         *
    *   [9] 0x00002B66C3BAFDDF                                     *
    * _Z18sqluRiddifyRecordsP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBP18S
    * + 0x291                                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2 v9.5 FP5                                      *
    ****************************************************************
    

Problem conclusion

  • First Fixed in db2 v9.5 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74521

  • Reported component name

    BW D-CLASS LINU

  • Reported component ID

    5724U5500

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-26

  • Closed date

    2010-03-05

  • Last modified date

    2010-03-05

  • 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 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 March 2010