IBM Support

IT30526: ADDING DEBUG CODE FOR SQLBFIX - BFIX DETECTED AN ERROR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • This APAR adds additional debug code for the issue indicated by
    the following db2diag.log message:
    
    2017-06-28-00.18.24.790509+120 I6008E6255            LEVEL:
    Severe
    PID     : 14780                TID : 139659493500672 PROC :
    db2sysc 0
    INSTANCE: db2jkl               NODE : 000            DB   : JKL
    APPHDL  : 0-1691               APPID:
    10.0.0.1.63365.170627191124
    AUTHID  : SAPJKL                HOSTNAME: hostserver
    EDUID   : 1182                 EDUNAME: db2agent (JKL) 0
    FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:104
    DATA #1 : String, 25 bytes
    bfix detected an error -
    DATA #2 : Boolean, 1 bytes
    false
    DATA #3 : Boolean, 1 bytes
    true
    DATA #4 : String, 20 bytes
    Current Descriptor =
    ...
    PageHead from FixCB =
    DATA #11: Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
    pageHead: {tbspSeed:12;obj:15840;type:0} bphPPNum:2079399
    bphOPNum:2079399
      begoff:                      48
      datlen:                   16336
      revnum:                    1280
      pagelsn:     000001E34160DE40
      flag:                        2a
      future32:                    0
      cbits1to31:            da921e16
      cbits32to63:            ccd3472
    ...
    Cached Page Header
    DATA #21: Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
    pageHead: {tbspSeed:12;obj:15840;type:0} bphPPNum:30287225
    bphOPNum:2079399
      begoff:                      48
      datlen:                   16336
      revnum:                    1280
      pagelsn:     000001E34160DE40
      flag:                        2a
      future32:                    0
      cbits1to31:            da921e16
      cbits32to63:            ccd3472
    
    The cached page header and the header in the internal structures
    of Db2 differ. The instance is trapping.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30526

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-08

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

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

    IT30528

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020