Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09017 Status: Geschlossen

INSTANCE CAN CRASH RUNNING A SQL ON COLUMN BASED TABLES(CDE).

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Instance can crash running a SQL on Column Based Tables(CDE). 
The trap look like the following: 
 
2015-04-22-16.15.04.814251+120 I33801238E2318        LEVEL: 
Event 
PID     : 20934                TID : 140685860660992 PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
SAMPLE 
APPHDL  : 0-37247              APPID: 
255.255.255.255.57615.150422140056 
AUTHID  : db2inst1             HOSTNAME: db2host1 
EDUID   : 2096                 EDUNAME: db2agntcol (SAMPLE) 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] 0x00007FFFF28F02BC sqloPGRPRegisterOneCrash + 0x17C 
  [1] 0x00007FFFF2941719 sqloEDUCodeTrapHandler + 0xA49 
  [2] 0x00007FFFF7BCF710 /lib64/libpthread.so.0 + 0xF710 
  [3] 0x00007FFFF1C21963 
_ZN7ibm_cde5query24LoadNestedQueryEvaluator23getCseNestedQueryOu 
tputERmRSt6vectorINS_8services18CountedPtrWithCopyIKNS_5types10 
+ 0xEC3 
  [4] 0x00007FFFF1C1FF01 
_ZN7ibm_cde5query24LoadNestedQueryEvaluator26processInputsSynchr 
onouslyEv + 0x251 
  [5] 0x00007FFFF38427A2 
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt 
ateEPNS0_19OptPredicateTrackerE + 0x402 
  [6] 0x00007FFFEE69775E 
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat 
a + 0x31E 
  [7] 0x00007FFFF1C2D8F3 
_ZN7ibm_cde5query9Scheduler13runThreadTaskEPvPi + 0x3C3 
  [8] 0x00007FFFF1C35A6E 
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E 
  [9] 0x00007FFFF1BE5FB3 
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x83 
  [10] 0x00007FFFF0D32071 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x41 
  [11] 0x00007FFFF3933071 
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1B1 
  [12] 0x00007FFFF0B3D9F8 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x2C8 
  [13] 0x00007FFFF0B3C8FE 
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x58E 
  [14] 0x00007FFFEF97657D 
/bbdd_idisarbl/sqllib/lib64/libdb2e.so.1 + 0x30C057D 
  [15] 0x00007FFFEF97503C _Z21sqleProcessSubRequestP8sqeAgent + 
0x2DC 
  [16] 0x00007FFFEF990580 _ZN8sqeAgent6RunEDUEv + 0x4A0 
  [17] 0x00007FFFF1176047 _ZN9sqzEDUObj9EDUDriverEv + 0xF7 
  [18] 0x00007FFFF094F181 sqloEDUEntry + 0x301 
  [19] 0x00007FFFF7BC79D1 /lib64/libpthread.so.0 + 0x79D1 
  [20] 0x00007FFFEB6F6B6D clone + 0x6D
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later.                 * 
****************************************************************
Local-Fix:
Lösung
First Fixed in DB2 LUW v10.5 Fixpack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.05.2015
21.01.2016
21.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList