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 | |
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 | |
10.5.0.1 |