IBM Support

IT32155: DB2 INSTANCE MIGHT PANIC WHILE RUNNING QUERIES INVOLVING A SORT OPERATOR

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

  • When running a query involving one or more SORT operators, the
    instance may trap with the following entry and stack in
    db2diag.log:
    
    2020-01-29-11.12.03.452674-300 E522463E3232          LEVEL:
    Severe (OS)
    PID     : 4129                 TID : 47244791244544  PROC :
    db2sysc 0
    INSTANCE: XXXXXXXX             NODE : 000            DB   : XXXX
    APPHDL  : 0-37515              APPID:
    10.98.83.199.47484.200129155118
    AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
    EDUID   : 13248                EDUNAME: db2agnts (PMMPW) 0
    FUNCTION: DB2 UDB, SQO Latch Tracing,
    SQLO_SLATCH_CAS64::getConflictComplex, probe:210
    MESSAGE :
    ZRC=0x870F00FB=-2029059845=SQLO_SLATCH_ERROR_HELDX_WITH_SHARED_H
    OLDERS
              "shared latch found with both exclusive and shared
    holders.  Latch likely corrupt."
    CALLED  : OS, -, unspecified_system_function
    DATA #1 : String, 13 bytes
    invalid latch
    DATA #2 : File name, 16 bytes
    sqloLatchCAS64.C
    DATA #3 : Source file line number, 8 bytes
    592
    DATA #4 : Codepath, 8 bytes
    0
    DATA #5 : String, 131 bytes
    0x00002AD2F8A90030: {
       held X: 1
       reserved for X: 0
       shared holders: 48
       firstSharIndex: 0xD2F8A
       firstExclIndex: 0x15
    }
    DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes
    0x10000 (SQLO_LATCH_MODE_EXCLUSIVE)
    DATA #7 : String, 395 bytes
    {
       state         = 0x00002AD2F8A90030
                     = {
                           held X: 1
                           reserved for X: 0
                           shared holders: 48
                           firstSharIndex: 0xD2F8A
                           firstExclIndex: 0x15
                       }
       starve X mode = true
       xWaitCount    = 52928
       requestCount  = 0
       identity      = unknown (3506)
    }
    DATA #8 : Pointer, 8 bytes
    0x00002ae17c740000
    DATA #9 : Hexdump, 16 bytes
    0x00002AE17C740000 : 3000 A9F8 D22A 0000 B20D C0CE 0000 0000
    0....*..........
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00002AAAB127954D
    _ZNK17SQLO_SLATCH_CAS6420dumpDiagInfoAndPanicEPKcjmmlmiS1_mi +
    0x2AD
      [1] 0x00002AAAB22EB65D
    _ZN17SQLO_SLATCH_CAS6418getConflictComplexEm + 0x8ED
      [2] 0x00002AAAAC37C31B
    /var/ibmdb2/nypit348/sqllib/lib64/libdb2e.so.1 + 0x129031B
      [3] 0x00002AAAAC37CC26 _Z13sqlbUnfixPageP11SQLB_FIX_CB + 0x636
      [4] 0x00002AAAAF839A32
    _Z13sqlsUnfixPageP10SQLS_SLDESP14SQLD_FILE_INFOm + 0xB2
      [5] 0x00002AAAAF83D994 _Z8sqlsfshpP8sqeAgentP10SQLS_SLDES +
    0xF44
      [6] 0x00002AAAAF829D53 _Z7sqlsendP8sqeAgentP10SQLS_SLDESi +
    0x53
      [7] 0x00002AAAAF82450C _Z8sqlsclosP8sqeAgentPP8SQLD_CCBPc +
    0x11C
      [8] 0x00002AAAAF668206 _Z9sqlrsclosP8sqlrr_cbP9sqlri_tao +
    0x386
      [9] 0x00002AAAB2341274 _Z8sqlricloP8sqlrr_cbP9sqlri_taoi +
    0x554
      [10] 0x00002AAAB234930A _Z7sqlritaP8sqlrr_cb + 0x28A
      [11] 0x00002AAAB2342246
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x196
      [12] 0x00002AAAAF479AC3 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x173
      [13] 0x00002AAAAF478B41
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x591
      [14] 0x00002AAAAE26E77D
    /var/ibmdb2/nypit348/sqllib/lib64/libdb2e.so.1 + 0x318277D
      [15] 0x00002AAAAE26D22C _Z21sqleProcessSubRequestP8sqeAgent +
    0x2EC
      [16] 0x00002AAAAE288B72 _ZN8sqeAgent6RunEDUEv + 0x4C2
      [17] 0x00002AAAAFAC3A47 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
      [18] 0x00002AAAAF26F4E3 sqloEDUEntry + 0x303
      [19] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1
      [20] 0x00002AAAB8183C4D clone + 0x6D
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp6 or later                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to db2_v111m4fp6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32155

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-11

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
20 March 2021