|
Problem IC79938
|
Status: Closed |
WHEN DB2_COMPATIBILITY_VECTOR IS SET TO ORA, A POSSIBLE RUNTIME TRAP MAY OCCUR SOMETIME AFTER ALTER TABLE ADD "NOT NULL DEFAULT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Users having DB2_COMPATIBILITY_VECTOR set to ORA. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW version 97fp6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84403 IC84411 IC84431
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.11.2011
13.06.2012
13.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
