|
Problem IC88322
|
Status: Closed |
A UDI SQL STATEMENT THAT REFERENCES AN INVALID VIEW IN WHICH THERE IS AN UNREFERENCED INLINE VIEW CAN CRASH THE DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
A data modifying statement (compound statement, DML that
modifies data, e.g. UDI, merge, etc. ) that references an
invalid view (that requires implicit regeneration) where the
view has an unreferenced inline view, can cause DB2 to crash
during view regeneration. The stack trace will resemble the
following:
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB083B10F ossDumpStackTraceEx + 0x01ef
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB0835ECE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAAD8CCB4E sqlo_trce + 0x040a
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAD91262A sqloEDUCodeTrapHandler + 0x025a
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAACD6B10 address: 0x00002AAAAACD6B10 ; dladdress:
0x00002AAAAACC8000 ; offset in lib: 0x000000000000EB10 ;
(/lib64/libpthread.so.0)
0x00002AAAAD7B497E
_Z34sqlns_mark_quns_for_unrelated_udisP9sqlnq_qur + 0x017a
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC3316EB _Z28sqlns_mark_quns_for_matchingP9sqlnq_qur +
0x0107
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC330881 _Z9sqlns_qgsP9sqlnq_qur17sqlnq_requestTypePc
+ 0x0189
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC10F433
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_enviiPP9sqlnq_qur + 0x2c81
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC10C7AD
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_env + 0x0021
(/var/ibmdb2/db2inst1/sqllib/lib64/libdb2e.so.1) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Any using inline views *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 10.1 fixpack 2 *
**************************************************************** |
| Local Fix: |
Ensure that all related views are validated before running the
SQL statement again |
| available fix packs: |
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
|
| Solution |
Problem is first fixed in Version 10.1 fixpack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2012
01.01.2013
01.01.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
