A fix is available
APAR status
Closed as program error.
Error description
DB2 does not clean up an internal object properly during the call to estimate the cardinality of a portion of SQL statement. Then DB2 hits an internal error when discovering the inconsistent state of the internal object that was not cleaned up. As the symptom, the db2diag.log includes the following information: FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 44 sqlerrmc: FCS Column Descriptor pointer does not exist sqlerrp : SQLNQ063 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFFCE (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) And the call stack indicates that the following functions are called: sqlnq_cst::populate_from_cd sqlnq_fcs::need_statistics sqlnr_estimate_sel_card sqlnr_estimate_oj_card sqlnr_estimate_box_card sqlnr_estimate_card sqlnr_joinppd_ojppd4np_cond sqlnr_joinppd_magic_detail sqlnr_joinppd_action
Local fix
Not available
Problem summary
Users Affected: ALL Problem Description: DB2 does not clean up an internal object properly during the call to estimate the cardinality of a portion of SQL statement. Then DB2 hits an internal error when discovering the inconsistent state of the internal object that was not cleaned up. Problem Summary: SET CURRENT QUERY OPTIMIZATION CAUSES SQL0901N ERROR WITH SQLSTATE 58004.
Problem conclusion
Problem was first fixed in Version 8.1 FixPak 16 (a.k.a. Version 8.2 FixPak 9)
Temporary fix
Comments
APAR Information
APAR number
LI72505
Reported component name
DB2 UDB EXE LIN
Reported component ID
5724E4904
Reported release
820
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-07-18
Closed date
2008-02-05
Last modified date
2008-02-05
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 EXE LIN
Fixed component ID
5724E4904
Applicable component levels
R820 PSN
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":"820","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 October 2021