IT22297: DB2 MIGHT TRAP WHEN EXECUTING COMPLEX QUERIES CONTAINING CSES

APAR status

• Closed as program error.

Error description

• DB2 might trap when the following conditions are met:
  1. a complex query contains multiple CSEs
  2. there are predicates on the CSEs
  3. DERPRD_FF is not set for DB2COMPOPT
  
  Crash stack:
  Stack #1             Signal #11
  0        ossDumpStackTraceInternal
  1        ossDumpStackTraceV98
  2        OSSTrapFile::dumpEx
  3        sqlo_trce
  4        sqloEDUCodeTrapHandler
  5        __waitpid
  6        sqlnq_prd::replace_in_prdpderchd
  7        sqlnq_prd::reassign_prdpder
  8        sqlnq_prd::drop
  9        sqlnq_opr::drop
  10       sqlnq_qtb::box_drop_ts
  11       sqlnq_mch::merge
  12       sqlnq_som::merge_clear_wins
  13       sqlnr_form_common_subexprs
  14       sqlnr_optprep_chunk1
  15       sqlnr_optprep_chunk1_action
  16       sqlnr_comp
  17       sqlnr_seq
  18       sqlnr_rcc
  19       sqlnr_exe
  20       sqlnn_cmpl
  21       sqlnn_cmpl
  22       sqlra_compile_var
  23       sqlra_find_var
  24       sqlra_get_var
  25       sqlrr_prepare
  26       sqljs_ddm_prpsqlstt
  27       sqljsParseRdbAccessed
  28       sqljsParse
  29       sqljsSqlam
  30       sqljsDrdaAsInnerDriver
  31       sqljsDrdaAsDriver
  32       sqeAgent::RunEDU
  33       sqzEDUObj::EDUDriver
  34       sqloEDUEntry
  35       _L_lock_3599
  36       clone
  

Local fix

• - Use the following OPTGUIDELINES:
  /*<OPTGUIDELINES>
      <REGISTRY>
          <OPTION NAME='DB2COMPOPT' VALUE='NO_DERPRD_FF'/>
      </REGISTRY>
  </OPTGUIDELINES>*/
  - Set the following:
  db2set -im DB2COMPOPT=NO_DERPRD_FF
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 4 Fixpack 4
  

Temporary fix

Comments

APAR Information

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

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

  IT24841

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP