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 IC84431 Status: Geschlossen

WHEN DB2_COMPATIBILITY_VECTOR IS SET TO ORA, A POSSIBLE RUNTIME TRAP MAY
OCCUR SOMETIME AFTER ALTER TABLE ADD "NOT NULL DEFAULT

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
After setting DB2_COMPATIBILITY_VECTOR to ORA, then altering a 
table to add "NOT NULL DEFAULT '' "  (Note two single quotes for 
the DEFAULT.   A runtime trap may occur with a stack trace 
similar to the following: 
 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00007FF0D26B093F ossDumpStackTraceEx + 0x01ef 
  (/eadb2_6/sqllib/lib64/libdb2osse.so.1) 
0x00007FF0D26AB706 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
  (/eadb2_6/sqllib/lib64/libdb2osse.so.1) 
0x00007FF0D520FE0D sqlo_trce + 0x03fb 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D52540A8 sqloDumpDiagInfoHandler + 0x00e0 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D7D1F5D0 address: 0x00007FF0D7D1F5D0 ; dladdress: 
0x00007FF0D7D10000 ; offset in lib: 0x000000000000F5D0 ; 
  (/lib64/libpthread.so.0) 
0x00007FF0D7D1C746 pthread_kill + 0x0036 
  (/lib64/libpthread.so.0) 
0x00007FF0D52534B1 sqloDumpEDU + 0x0045 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D54225CD 
_Z14sqlrGetDefaultP19SQLR_TABLE_DEFAULTSPPhS1_P10SQLD_FIELDtjjP1 
0sqlz_value + 0x0327 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D450304D 
_Z20sqldGetMissingZValueP8SQLD_TCBPhP11SQLD_COLUMNjP10sqlz_value 
m + 0x00f1 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D4505E6C address: 0x00007FF0D4505E6C ; dladdress: 
0x00007FF0D2B2F000 ; offset in lib: 0x00000000019D6E6C ; 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D5EEC787 
_Z22sqldFullFormatFixedVarP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_ 
VALUEmP8SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB + 0x0331 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D5EFF6BB 
_Z13sqldRowUpdateP8sqeAgentP8SQLD_CCBmPP10SQLD_VALUEm + 0x0487 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D5F7ED67 _Z8sqlriupdP8sqlrr_cb + 0x018d 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D5F7E7BD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm 
+ 0x00e5 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3DF1023 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 
0x0473 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3DE5035 
_Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x00df 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3A28056 
_Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + 
0x00fa 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D5F122DD 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface + 0x03d5 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3A10323 
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 
0x035b 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3A05800 address: 0x00007FF0D3A05800 ; dladdress: 
0x00007FF0D2B2F000 ; offset in lib: 0x0000000000ED6800 ; 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3A0C6A4 address: 0x00007FF0D3A0C6A4 ; dladdress: 
0x00007FF0D2B2F000 ; offset in lib: 0x0000000000EDD6A4 ; 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3A0A033 address: 0x00007FF0D3A0A033 ; dladdress: 
0x00007FF0D2B2F000 ; offset in lib: 0x0000000000EDB033 ; 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3A09DC2 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 
0x0102 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D39450D5 _ZN8sqeAgent6RunEDUEv + 0x09f7 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3FEBF94 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3FEBEEB _Z10sqlzRunEDUPcj + 0x0009 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D3D67D62 sqloEDUEntry + 0x02f4 
  (/eadb2_6/sqllib/lib64/libdb2e.so.1) 
0x00007FF0D7D175F0 address: 0x00007FF0D7D175F0 ; dladdress: 
0x00007FF0D7D10000 ; offset in lib: 0x00000000000075F0 ; 
  (/lib64/libpthread.so.0) 
0x00007FF0D1AC484D clone + 0x006d 
  (/lib64/libc.so.6) 
</StackTrace>
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users having DB2_COMPATIBILITY_VECTOR set to ORA.            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW version 10 fp1.                           * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.06.2012
07.12.2012
07.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList