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

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 FixList