IBM Support

IT37095: DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • It is possible for db2stop processing to fail with the following
    SQLCODE:
    
    SQL1042C  An unexpected system error occurred.  SQLSTATE=58004
    
    
    The db2diag.log contains probes such as the following:
    
    2021-03-14-01.03.42.581861-480 I173302271E330        LEVEL:
    Event
    PID     : 15757                TID : 140323966326656 PROC :
    db2stop2
    INSTANCE: db2inst1               NODE : 000
    HOSTNAME: MYHOST1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
    DATA #1 : String, 41 bytes
    Requesting system controller termination.
    
    :
    
    2021-03-14-01.03.47.533305-480 I173304887E476        LEVEL:
    Severe
    PID     : 17834                TID : 139627176388352 PROC :
    db2sysc 0
    INSTANCE: db2inst1               NODE : 000
    HOSTNAME: MYHOST1
    EDUID   : 21                   EDUNAME: db2tcpcm 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdResilienceIsSafeToSustain, probe:800
    DATA #1 : String, 37 bytes
    Trap Sustainability Criteria Checking
    DATA #2 : Hex integer, 8 bytes
    0x200000000000800C
    DATA #3 : Boolean, 1 bytes
    false
    
    2021-03-14-01.03.47.535084-480 E173305364E1411       LEVEL:
    Severe
    PID     : 17834                TID : 139627176388352 PROC :
    db2sysc 0
    INSTANCE: db2inst1               NODE : 000
    HOSTNAME: MYHOST1
    EDUID   : 21                   EDUNAME: db2tcpcm 0
    FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
    probe:90
    MESSAGE : ADM14011C  A critical failure has caused the following
    type of error:
              "Trap". The DB2 database manager cannot recover from
    the failure.
              First Occurrence Data Capture (FODC) was invoked in
    the following
              mode: "Automatic". FODC diagnostic information is
    located in the
              following directory: "/db2/DPE/db2dump/".
    DATA #1 : Signal Number Recieved, 4 bytes
    11
    DATA #2 : Siginfo, 128 bytes
    0x00007EFD7C00FBF0 : 0B00 0000 0000 0000 0100 0000 0000 0000
    ................
    0x00007EFD7C00FC00 : 5000 0000 0000 0000 0000 0000 0000 0000
    P...............
    0x00007EFD7C00FC10 : 0000 0000 0000 0000 8061 2CC7 F69C FFFF
    .........a,.....
    0x00007EFD7C00FC20 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007EFD7C00FC30 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007EFD7C00FC40 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007EFD7C00FC50 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x00007EFD7C00FC60 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    
    2021-03-14-01.03.47.548752-480 I173306776E1216       LEVEL:
    Event
    PID     : 17834                TID : 139627176388352 PROC :
    db2sysc 0
    INSTANCE: db2inst1               NODE : 000
    HOSTNAME: MYHOST1
    EDUID   : 21                   EDUNAME: db2tcpcm 0
    FUNCTION: DB2 UDB, oper system services,
    sqloPGRPRegisterOneCrash, probe:2159
    MESSAGE : lastCrashCount
    DATA #1 : unsigned integer, 8 bytes
    0
    DATA #2 : String, 10 bytes
    inRecovery
    DATA #3 : Boolean, 1 bytes
    false
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00007EFD8F6010EC sqloPGRPRegisterOneCrash + 0x17C
      [1] 0x00007EFD8F6536E9 sqloEDUCodeTrapHandler + 0xA59
      [2] 0x00007EFD954D6630 /lib64/libpthread.so.0 + 0xF630
      [3] 0x00007EFD8C61C517
    _ZN16sqeAgentServices19RequestAgentForApplEiiP12SQLZ_APP_HDLP23S
    QLKD_RQST_REPLY_FORMATP17SQLE_CONNECT_INFO + 0x447
      [4] 0x00007EFD8C61ADFB
    _ZN16sqeAgentServices12RequestAgentEiP18SQLCC_INITSTRUCT_TiP12SQ
    LZ_APP_HDLP23SQLKD_RQST_REPLY_FORMATi + 0x52B
      [5] 0x00007EFD8E5D0DC4 _Z21sqlcctcpconnmgr_childPcj + 0x1944
      [6] 0x00007EFD8D5BDF73 sqloEDUEntry + 0x303
      [7] 0x00007EFD954CEEA5 /lib64/libpthread.so.0 + 0x7EA5
      [8] 0x00007EFD881B496D clone + 0x6D
    
    
    And a trap file is generated with the following stack:
    
    <StackTrace>
    ossDumpStackTraceInternal
    ossDumpStackTraceV98
    OSSTrapFile::dumpEx
    sqlo_trce + 0x0404
    sqloEDUCodeTrapHandler + 0x02bf
    sqeAgentServices::RequestAgentForAppl
    sqeAgentServices::RequestAgent
    sqlcctcpconnmgr_child
    sqloEDUEntry
    </StackTrace>
    

Local fix

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37095

  • 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-06-02

  • 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:

    IT37100

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