Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
In a very rare condition when a statement contains a user-defined function with correlation and a Union All view, DB2 could create an invalid internal structure during the compilation and abend the database with the call stack like the one below: 0x090000001403C360 pp__17sqlnq_fcsqclchildFv + 0xC 0x090000001405D964 sqlnr_multicolprd_cond__FP14sqlnr_progressP10sqlnr_qrwaPi + 0x5CC 0x09000000140698C4 sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres s + 0x334 0x090000001406A038 sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass + 0x168 0x090000001406A684 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x174 0x0900000014003654 sqlnr_any_prd_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0xB8 0x0900000014069A64 sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres s + 0x4D4 0x090000001406A038 sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass + 0x168 0x090000001406A684 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x174
Local fix
The problem can be avoid by issuing "SET CURRENT QUERY OPTIMIZATION 1."
Problem summary
Users affected: ALL Problem Description: Problem Summary:
Problem conclusion
Problem was first fixed in Version 9.1 Fix Pack 7
Temporary fix
The problem can be avoid by issuing "SET CURRENT QUERY OPTIMIZATION 1".
Comments
APAR Information
APAR number
JR31072
Reported component name
DB2 UDB PE WIND
Reported component ID
5724B5501
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-12
Closed date
2009-05-04
Last modified date
2009-05-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB PE WIND
Fixed component ID
5724B5501
Applicable component levels
R910 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021