IBM Support

IT38383: DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A page cleaner EDU will print a message similar to the following
    message in db2diag.log:
    
    2021-06-28-16.17.02.827743+000 E11207E1830          LEVEL:
    Severe (OS)
    PID     : 5298                 TID : 70364323311968 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    HOSTNAME:
    EDUID   : 439                  EDUNAME: db2pclnr () 0
    FUNCTION: DB2 UDB, SQO Latch Tracing,
    SQLO_SLATCH_CAS64::getConflictComplex, probe:210
    MESSAGE :
    ZRC=0x870F00FE=-2029059842=SQLO_SLATCH_ERROR_HELDS_WITH_SHARED_W
    AITER_NO_XWAITER
              "latch with no X starvation policy: when held shared
    and a shared water, there should always be an X waiter."
    CALLED  : OS, -, unspecified_system_function
    
    The trap file for this page cleaner will have a stack trace
    similar to the following:
    sqle_panic
    SQLO_SLATCH_CAS64::dumpDiagInfoAndPanic
    SQLO_SLATCH_CAS64::getConflictComplex
    SQLO_SLATCH_CAS64::getConflict
    sqlbClnrGatherForHateThresh
    sqlbClnrGatherPages
    sqlbClnrEntryPoint
    
    If a core file is present the address of the
    SQLB_HASH_BUCKET_GROUP structure in the db2diag.log message can
    be compared with the starting address of the bucketGroupArray in
    the core file. This is a match for this APAR if the address of
    the SQLB_HASH_BUCKET_GROUP structure in the db2diag.log message
    is before the starting address of the bucketGroupArray. Note
    that the address in the db2diag.log must be 1 to 3
    SQLB_HASH_BUCKET_GROUP sized structures prior to the start of
    the bucketGroupArray indicating a bucketGroupArray index of
    -1,-2, or -3 has been used.
    

Local fix

  • Set DB2_USE_ALTERNATE_PAGE_CLEANING=FALSE or install the latest
    fix pack.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT38383

  • 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

    2021-09-15

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT38384

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
03 May 2022