DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 can trap in sqlnq_viewsel_ofn_sm() when creating a view 
with using a query with CONNECT BY based on another view. 
 
Example: 
 
create view myview3 as SELECT LEVEL, DEPTNAME 
 
     FROM myview1 START WITH DEPTNO = 'A00' 
 
     CONNECT BY NOCYCLE PRIOR DEPTNO = ADMRDEPT; 
 
Stack example on AIX: 
 
0x090000003137CD68 
sqlnq_viewsel_ofn_sm__FP9sqlnq_qtb17sqlnq_requestTypePUcP3loc + 
0x80 
0x0900000031902850 
sqlnq_proc_enc__FP9sqlnq_qtb17sqlnq_requestTypePUcP3loc + 0x1C8 
 
0x09000000319025E8 
add_doid__9sqlnq_qtbFPi17sqlnq_requestTypePUc + 0x98 
0x0900000031AD1280 
add_doid__9sqlnq_qtbFPi17sqlnq_requestTypePUc@glue122F + 0x8C 
 
0x0900000032333E44 
sqlnq_sel_doid__FP9sqlnq_qtb17sqlnq_requestTypePUcPiP3loc + 
0x308 
...

USERS AFFECTED: All 
 
PROBLEM DESCRIPTION: 
 
see ERROR DESCRIPTION 
 
PROBLEM SUMMARY: 
 
see ERROR DESCRIPTION

n/a

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The complete fix for this problem first appears in DB2 UDB 
Version 9.7 FixPak 3.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC68774 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.04.2010
24.09.2010
24.09.2010

9.7.