DB2 - Problem description
| Problem IC74555 | Status: Closed |
DB2STOP FORCE MAY GET AN ADM14011C AND TRAP IN A FEDERATED ENVIRONMENT. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
Db2stop force may get an ADM14011C and trap in a federated
environment.
You will see a similar message at
$INSTANCEHOME/sqllib/db2dump/db2diag.log as below when you hit
this problem.
...
2011-01-14-12.02.49.972360+540 E82678A1433 LEVEL:
Critical
PID : 15552 TID : 2199165856080PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc 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/db2dump/FODC_Trap_2011-01-14-12.02.43.841173/".
DATA #1 : Signal Number Recieved, 4 bytes
11
...
.
And the associated trap file
/db2/db2dump/FODC_Trap_2011-01-14-12.02.43.841173/15552.1.000.tr
ap.txt
will have a similar stack trace as below.
...
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x0000020005115BF6 ossDumpStackTrace + 0x0102
0x0000020005110E32 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00d2
0x00000200028424AE sqlo_trce + 0x0702
0x00000200028DB3F8 sqloEDUCodeTrapHandler + 0x016c
0x0000020008409DF0 address: 0x20008409df0
0x00000200015E65BC
_Z25sqleUCagentTrustedEduTermP15sql_static_dataP16sqloModuleHand
le
+ 0x009c
0x00000200014E5C42
_ZN14sqeAppServices17ForceApplicationsEP14sqeApplicationiP12SQLZ
_APP_HDLiii
+ 0x044a
0x0000020001421DC4
_Z15sqleForceAgentsiiP12SQLZ_APP_HDLP5sqlcaiii + 0x0110
0x00000200014E9960 _ZN14sqeAppServices16ExecuteStopForceEi +
0x027c
0x000000008000B336 _Z14sqleRunSysCtlrv + 0x10ba
0x000000008000FC94 _Z11sqleSysCtlrv + 0x00a4
...
There is a problem in sqleUCagentTrustedEduTerm() and it may not
handle "db2stop force" as expected.
Running queries will be rollbacked when hit this problem.
"db2stop force" will work without any error when a fix is
integrated. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description field for more information. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 FixPack 5. * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Solution | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.02.2011 16.12.2011 16.12.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.5 |
|