Fixes are available
DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a 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
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
sqlnr_estimate_card() gives -901, not cleaning up the stat cache properly
Problem conclusion
Problem was first fixed in Version 9.1 FP 4
Temporary fix
Comments
APAR Information
APAR number
LI72503
Reported component name
DB2 UDB EXE LIN
Reported component ID
5724E4904
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-07-17
Closed date
2007-11-15
Last modified date
2007-11-15
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
R910 PSN
UP
Document Information
Modified date:
07 January 2022