IBM Support

IT24734: INSTANCE MAY PANIC DURING A DROP SEQUENCE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you are in a SMP or DPF environment, your Db2 instance may
    crash if a DROP SEQUENCE is issued from the same connection that
    has an open cursor that is referencing the sequence
    
    The following can be seen in the db2diag.log file :
    
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXX         LEVEL: Severe
    PID     : 4064004              TID : 185107         PROC :
    db2sysc 0
    INSTANCE: xxxxx              NODE : 000           DB   : xxxxxxx
    APPHDL  : 0-21884              APPID: xxx.xx.xx.xx.xxxxx.xxxxxxx
    AUTHID  : xxxxxx               HOSTNAME: xxxx
    EDUID   : 185107               EDUNAME: db2agnts (xxxxxxx) 0
    FUNCTION: DB2 UDB, data management, sqldSeqFetch, probe:2043
    MESSAGE : ZRC=0x8704007A=-2029780870=SQLD_REC_DELETED "DELETED
    RECORD ID"
    DATA #1 : String, 25 bytes
    seqCache - sequence cache
    DATA #2 : Hexdump, 280 bytes
    0x0A000376A8FF3820 : 0000 0261 0000 0000 0000 0000 0000 0125
    ...a...........%
    0x0A000376A8FF3830 : 0000 0001 0000 0000 0000 0014 0000 0000
    ................
    0x0A000376A8FF3840 : 0000 0000 0000 0026 0000 0000 0011 54B1
    .......&......T.
    0x0A000376A8FF3850 : 2018 0221 0937 4626 2161 0000 0000 0000
    ..!.7F&!a......
    0x0A000376A8FF3860 : 0002 1F00 0002 0000 0A00 0376 A8FF 38C0
    ...........v..8.
    0x0A000376A8FF3870 : 0000 0000 0000 0000 0002 1F00 0002 0000
    ................
    0x0A000376A8FF3880 : 0A00 0376 A8FF 38D0 0000 0000 0000 0000
    ...v..8.........
    0x0A000376A8FF3890 : 0002 1F00 0002 0000 0A00 0376 A8FF 38E0
    ...........v..8.
    0x0A000376A8FF38A0 : 0000 0000 0000 0000 0002 1F00 0002 0000
    ................
    0x0A000376A8FF38B0 : 0A00 0376 A8FF 38F0 0000 0000 0000 0000
    ...v..8.........
    0x0A000376A8FF38C0 : 0000 0000 0000 0000 0000 0000 0000 001C
    ................
    0x0A000376A8FF38D0 : 0000 0000 0000 0000 0000 0214 7483 647C
    ............t.d|
    0x0A000376A8FF38E0 : 0000 0000 0000 0000 0000 0000 0000 001C
    ................
    0x0A000376A8FF38F0 : 0000 0000 0000 0000 0000 0000 0128 060C
    .............(..
    0x0A000376A8FF3900 : 0000 0000 0000 0000 0000 0000 0000 001C
    ................
    0x0A000376A8FF3910 : 00BF 2000 0001 0000 002E FF4D 0000 0000
    .. ........M....
    0x0A000376A8FF3920 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0A000376A8FF3930 : 0000 0000 0000 0000
    ........
    
    
    
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXX         LEVEL: Info
    PID     : 4064004              TID : 185107         PROC :
    db2sysc 0
    INSTANCE: xxxxx              NODE : 000           DB   : xxxxxxx
    APPHDL  : 0-21884              APPID: xxx.xx.xx.xx.xxxxx.xxxxxxx
    AUTHID  : xxxxxx               HOSTNAME: xxxxxx
    EDUID   : 185107               EDUNAME: db2agnts (xxxxxx) 0
    FUNCTION: DB2 UDB, base sys utilities,
    sqeLocalDatabase::ForceDBShutdown, probe:16870
    MESSAGE : Regular agent EDU doing ForceDBShutdown.  Force DB
    shutdown agent ID
              is:
    DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes
    0-21884
    DATA #2 : sqeApplication_acbInfo,
    PD_TYPE_sqeApplication_acbInfo, 4 bytes
    x0
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000000818BAAC ForceDBShutdown__16sqeLocalDatabaseFi +
    0xC0C
      [1] 0x0900000008781978
    sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x1978
      [2] 0x09000000087846A8
    sqldEndDumpBadPage__FP8sqeAgentP11SQLB_FIX_CBUliN34 + 0x168
      [3] 0x0900000008784990
    sqldDumpBadPage__FP8sqeAgentP8SQLD_TCBP13SQLD_PAGESLOTP11SQLB_FI
    X_CBUliT6 + 0xF0
      [4] 0x090000000CC980A0
    IPRA.$sqldSeqFetch__FP8sqeAgentP8SQLD_SEQP13SQLD_DFM_WORKPiP14SQ
    LP_LOCK_INFO + 0xAC0
      [5] 0x090000000CC96AEC
    IPRA.$sqldSeqFetchUpdateGen__FP8sqeAgentPP8SQLD_SEQP8SQLD_SEQ +
    0x8C
      [6] 0x090000000CC95670
    IPRA.$sqldSeqLoadGen__FP8sqeAgentPP8SQLD_SEQP8SQLD_SEQ + 0x290
      [7] 0x090000000CC95248 sqldSeqGenerate__FP8sqeAgentP8SQLD_SEQ
    + 0x568
      [8] 0x090000000E1263C4 sqlriSeqNextval__FP8sqlrr_cb + 0x1C4
      [9] 0x0900000009A669F8
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5F8
      [10] 0x09000000093B9E28 sqlrr_smp_router__FP8sqlrr_cb + 0x188
      [11] 0x09000000093B62D0
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xFD0
      [12] 0x090000000939B39C
    IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x7FC
      [13] 0x09000000093953B4 sqleProcessSubRequest__FP8sqeAgent +
    0x2C74
      [14] 0x0900000007C83C2C RunEDU__8sqeAgentFv + 0x9EC
      [15] 0x0900000007C668A0 EDUDriver__9sqzEDUObjFv + 0x2E0
      [16] 0x0900000007B56814 sqloEDUEntry + 0x374
      [17] 0x0900000000528E10 _pthread_body + 0xF0
      [18] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    

Local fix

  • N/A
    

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

    IT24734

  • 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-04-16

  • Closed date

    2018-11-28

  • Last modified date

    2018-11-28

  • 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":"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:
28 November 2018