suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT37100 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem 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: db2dpe               NODE : 000
HOSTNAME: heeudpedb03
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: db2dpe               NODE : 000
HOSTNAME: heeudpedb03
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: db2dpe               NODE : 000
HOSTNAME: heeudpedb03
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: db2dpe               NODE : 000
HOSTNAME: heeudpedb03
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:


ossDumpStackTraceInternal
ossDumpStackTraceV98
OSSTrapFile::dumpEx
sqlo_trce + 0x0404
sqloEDUCodeTrapHandler + 0x02bf
sqeAgentServices::RequestAgentForAppl
sqeAgentServices::RequestAgent
sqlcctcpconnmgr_child
sqloEDUEntry
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5 FP7 or later                                 *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5 FP7 or later                                 *
****************************************************************
Comment
Upgrade to 11.5 FP7 or later
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.06.2021
22.11.2021
22.11.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)