home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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