LI72676: DB2 MAY ISSUE SQL0901N ERROR IN QUERY OPTIMIZATION

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 1  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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

• see problem description
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 1
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  LI72503

• 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 PSY

     UP

• R950 PSY

     UP