|
Problem IC67825
|
Status: Closed |
TRAP IN SQLNQ_VIEWSEL_OFN_SM() WHEN CREATING A VIEW WITH USING A QUERY WITH CONNECT BY BASED ON ANOTHER VIEW |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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
... |
| Problem Summary: |
USERS AFFECTED: All
PROBLEM DESCRIPTION:
see ERROR DESCRIPTION
PROBLEM SUMMARY:
see ERROR DESCRIPTION |
| Local Fix: |
n/a |
| available fix packs: |
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
|
| Solution |
The complete fix for this problem first appears in DB2 UDB
Version 9.7 FixPak 3. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC68774
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.04.2010
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
