IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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:
    X.X.X.X.47484.200129155118
    AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
    EDUID   : 13248                EDUNAME: db2agnts (XXXX) 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

    2022-03-29

  • 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

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

Document Information

Modified date:
03 May 2022