IBM Support

LI74513: LOAD FAILS WITH SQL3005N INSTEAD OF SQL1218N,WHEN BUFFERPOOL IS FULL ON ONE OF THE NODE IN A DPF ENVIRONMENT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • User received SQL3005N Processing was interrupted, when the
    bufferpool on one of the node was full. The LOAD should have
    failed with SQL1218N. This happens only on a DPF env.
    
    2009-04-19-14.49.42.719381-240 E370436E553         LEVEL: Error
    PID     : 13833                TID  : 186298394976 PROC :
    db2sysc 5
    INSTANCE: xx             NODE : 005          DB   : sample
    APPHDL  : 1-31721              APPID:
    10.4.43.110.6534.090419184925
    AUTHID  : xx
    EDUID   : 70143                EDUNAME: db2agntp (WISEQA) 5
    FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
    MESSAGE : ADM6019E All pages in buffer pool "IBMDEFAULTBP" (ID
    "4098")
    are
              in use.  Refer to the documentation for SQLCODE -1218.
    
    2009-04-19-14.49.42.723316-240 I370990E532         LEVEL: Severe
    PID     : 13833                TID  : 186298394976 PROC :
    db2sysc 5
    INSTANCE: xx            NODE : 005          DB   : sample
    APPHDL  : 1-31721              APPID:
    10.4.43.110.6534.090419184925
    AUTHID  : xx
    EDUID   : 70143                EDUNAME: db2agntp (WISEQA) 5
    FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:0
    DATA #1 : String, 97 bytes
    Could not fix page for objID=20444, tbspaceID=8, objType=0,
    parentObjID=20444 parentTbspaceID=8.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Customer running load in DPF (multi- partition)              *
    * environmentis effected.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Load failing with SQL3005N user interrupt  instead           *
    * ofSQL1218N, when there are no pages in the bufferpool.       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to V9.5 Fixpack 6.                                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74513

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-21

  • Closed date

    2010-09-09

  • Last modified date

    2010-09-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC63647

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSN

       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:
09 September 2010