DB2 - Problembeschreibung
Problem IC84014 | Status: Geschlossen |
A UDI SQL STATEMENT THAT REFERENCES AN INVALID VIEW IN WHICH THERE IS AN UNREFERENCED INLINE VIEW CAN CRASH THE DATABASE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Any using inline views * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 fixpack 7 or later * **************************************************************** | |
Local-Fix: | |
Ensure that all related views are validated before running the SQL statement again | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Problem is first fixed in Version 9.7 fixpack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC88322 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.06.2012 05.11.2012 05.11.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |