home clear 64x64
en blue 200x116 de orange 200x116 info letter User
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 IC75682 Status: Closed

INSTANCE MAY BE CRASHED BY DB2SYSC RECEIVING SIGNAL 11 AT SQLFGETDB

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
From db2diag.log.......................................... 
: 
2011-01-11-14.46.07.596758+540 I107541A397        LEVEL: Event 
PID     : 581702               TID  : 1     PROC : db2agent 
(instance) 0 
INSTANCE: db2inst1             NODE : 000 
APPHDL  : 0-625                APPID: 
*LOCAL.db2inst1.10111054552 
AUTHID  : DB2INST1 
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, 
probe:20 
STOP    : Completed invoking /home/db2inst1/sqllib/bin/db2cos 
 
2011-01-11-14.46.07.603745+540 E107939A608        LEVEL: Severe 
PID     : 581702               TID  : 1     PROC : db2agent 
(instance) 0 
INSTANCE: db2inst1             NODE : 000 
APPHDL  : 0-625                APPID: 
*LOCAL.db2inst1.10111054552 
AUTHID  : DB2INST1 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
prob... 
MESSAGE : ADM0503C  An unexpected internal processing error has 
occur... 
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN 
SHUTD... 
          Diagnostic information has been recorded.  Contact IBM 
Supp... 
          further assistance. 
 
2011-01-11-14.46.07.605890+540 E108548A741        LEVEL: Severe 
PID     : 581702               TID  : 1     PROC : db2agent 
(instance) 0 
INSTANCE: db2inst1             NODE : 000 
APPHDL  : 0-625                APPID: 
*LOCAL.db2inst1.10111054552 
AUTHID  : DB2INST1 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
prob... 
DATA #1 : Signal Number Recieved, 4 bytes 
11 
DATA #2 : Siginfo, 64 bytes 
0x0FFFFFFFFFFEF070 : 0000 000B 0000 0000 0000 0032 0000 0000 
........ 
0x0FFFFFFFFFFEF080 : 0000 0000 0000 0000 0FFF FFFF EFFF FFFC 
........ 
0x0FFFFFFFFFFEF090 : 0000 0000 0000 0000 0000 0000 0000 0000 
........ 
0x0FFFFFFFFFFEF0A0 : 0000 0000 0000 0000 0000 0000 0000 0000 
........ 
. 
From errpt_a.out................................ 
   : 
Label:         CORE_DUMP 
ID:             C69F5C9B 
 
Date:       Tue Jan 11 14:46:19 JST 2011 
   : 
SIGNAL NUMBER 
          11 
USER'S PROCESS ID: 
                581702 
FILE SYSTEM SERIAL NUMBER 
       38008 
INODE NUMBER 
        4096 
core file name 
/work/core.581702.11054607 
PROGRAM NAME 
db2sysc 
STACK EXECUTION DISABLED 
           0 
COME FROM ADDRESS REGISTER 
?? 
PROCESSOR ID 
  hw_fru_id: 0 
  hw_cpu_id: 1 
 
ADDITIONAL INFORMATION 
?? 
sqlfGetDb 1180 
 
Date 
REPORTABLE 
1 
INTERNAL ERROR 
0 
SYMPTOM CODE 
PCSS/SPI2 FLDS/db2sysc SIG/4 FLDS/sqlfGetDb VALU/1180 
-------------------------------------------------------- 
. 
From db2cos5817021.0................................... 
   : 
Address            AppHandl [nod-index] AgentPid ... ClientNm 
... 
   : 
0x0780000000A5D780 625      [000-00625] 581702   ... db2dasst 
... 
. 
...........................................................
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
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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       :
07.04.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 FixList