IBM Support

IT26380: DEBUG CODE ADDED WITH IT22695 MAY CAUSE FALSE APPEND CACHE ERRORS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • There was debug code added as part of the fix for IT22695.
    This can cause false detection of errors in the append cache.
    
    Errors in db2diag.log file show similar to the following:
    2018-08-13-06.33.22.515595-240 I144726A3393 LEVEL: Severe
    PID : 6815792 TID : 38607 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-242 APPID: 10.12.151.118.33033.180812174458
    AUTHID : DB2INST1 HOSTNAME: hostname
    EDUID : 38607 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, data management,
    sqldFindRidFromPageCacheComplex, probe:4623
    MESSAGE : Error searching page cache.
    DATA #1 : signed integer, 8 bytes
    0
    DATA #2 : unsigned integer, 8 bytes
    2
    DATA #3 : Hex integer, 8 bytes
    0x0000000000000004
    DATA #4 : unsigned integer, 8 bytes
    2
    DATA #5 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    163998
    DATA #6 : Page ID, PD_TYPE_SQLB_PAGE_ID, 8 bytes
    0
    DATA #7 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    163999
    DATA #8 : SQLD_PAGE_CACHE, PD_TYPE_SQLD_PAGE_CACHE, 96 bytes
    
    SQLD_PAGE_CACHE: Address:a000203ebb65ec0, Size:x60, Size:96
    x0000 pcFlags x4
    - SQLD_PGCACHE_TEMPAPPEND
    x0008 pcFirstObjPage 163998
    x000C pcFirstPoolPage 746302
    x0010 pcLocksPrefetchedPerPage 0
    x0018 pcNumPages 2
    x0028 pcLastPageWithSpace 0
    x0030 pcPgInfoHeader a000203f19a0060
    x0038 pcPgInfo a000203f19a0070
    x0040 pcMaxPages 2
    x0048 pcPgInfoToFree a000203f19b5ca0
    x0050 pcEduIDofLastXLatch 0
    x0058 pageCacheLatch a000203ebb65f80
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    [0] 0x090000000DC2C2D4
    sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
    TABLE_CACHET3 + 0x19BC
    [1] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    [2] 0x090000000DC20A18
    sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
    TABLE_CACHET3 + 0x32D8
    [3] 0x090000000DC041D4 sqldInsertRow__FP13SQLD_DFM_WORKi + 0x1E0
    [4] 0x090000000DC05900
    sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
    0x22C
    [5] 0x090000000DC0D4E8
    sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
    oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xBC
    [6] 0x090000000DC0D790 sqlriisr__FP8sqlrr_cb + 0x1CC
    [7] 0x090000000DDE849C
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x94
    [8] 0x090000000DA95CA8
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x1E98
    [9] 0x090000000DA95218
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x1408
    [10] 0x090000000DA949A0
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0xB90
    [11] 0x090000000DA9A9F4
    @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1168
    [12] 0x090000000DA9A9F4
    @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1168
    [13] 0x090000000DA9A5E8
    @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xD5C
    [14] 0x090000000F5D9174
    @72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
    [15] 0x090000000F5D9C84
    @72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8
    [16] 0x090000000D284674 RunEDU__8sqeAgentFv + 0x4D060
    [17] 0x090000000D213DA0 RunEDU__8sqeAgentFv + 0x124
    [18] 0x090000000E42140C EDUDriver__9sqzEDUObjFv + 0x130
    [19] 0x090000000D1F5AF8 sqloEDUEntry + 0x390
    [20] 0x0900000000567E10 _pthread_body + 0xF0
    [21] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    
    2018-08-13-06.33.22.523263-240 I148120A570 LEVEL: Severe
    PID : 6815792 TID : 38607 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-242 APPID: 10.12.151.118.33033.180812174458
    AUTHID : DB2INST1 HOSTNAME: hostname
    EDUID : 38607 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
    logging function), probe:30
    MESSAGE : SQLD_TCB:
    DATA #1 : String, 42 bytes
    Perm Table(x:x)=SCHEMA.TABLE
    
    If the errors occur whilst an insert is being performed then the
    insert may hang.
    

Local fix

  • Perform an offline reorg or set APPEND ON for the table which is
    having data inserted.
    

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26380

  • 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

    2018-09-21

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

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

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

    IT26383

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 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":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 November 2018