IC63968: DB2 crash with SIGSEGV in sqlnq_qtbqunchild2 or sqlnq_qtboprparent2

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• DB2 instance abend with SIGSEGV (signal 11) in either
  sqlnq_qtbqunchild2 or sqlnq_qtboprparent2 function during query
  processing.
  
  Here are some examples of the SIGSEGV traps -
  
  Example #1 -
  
  _ZN17sqlnq_qtbqunchild2ppEv
  _Z17sqlnr_sop_fix_hxpP9sqlnq_oprPiP3loc
  _Z21sqlnr_setophxp_actionP10sqlnr_qrwaPiP14sqlnr_progress
  _Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progre
  ss
  _Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass
  ...
  
  Example #2 -
  
  _ZN18sqlnq_qtboprparent2opEv
  _Z17sqlnr_sop_fix_hxpP9sqlnq_oprPiP3loc
  _Z21sqlnr_setophxp_actionP10sqlnr_qrwaPiP14sqlnr_progress
  _Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progre
  ss
  _Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass
  ...
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DB2 instance abend with SIGSEGV (signal 11) in either        *
  *                                                              *
  * sqlnq_qtbqunchild2 or sqlnq_qtboprparent2 function during    *
  * query                                                        *
  * processing.                                                  *
  *                                                              *
  *                                                              *
  *                                                              *
  * Here are some examples of the SIGSEGV traps -                *
  *                                                              *
  *                                                              *
  *                                                              *
  * Example #1 -                                                 *
  *                                                              *
  *                                                              *
  *                                                              *
  * _ZN17sqlnq_qtbqunchild2ppEv                                  *
  *                                                              *
  * _Z17sqlnr_sop_fix_hxpP9sqlnq_oprPiP3loc                      *
  *                                                              *
  * _Z21sqlnr_setophxp_actionP10sqlnr_qrwaPiP14sqlnr_progress    *
  *                                                              *
  * _Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_prog
  * ss                                                           *
  *                                                              *
  * _Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass  *
  *                                                              *
  * ...                                                          *
  *                                                              *
  *                                                              *
  *                                                              *
  * Example #2 -                                                 *
  *                                                              *
  *                                                              *
  *                                                              *
  * _ZN18sqlnq_qtboprparent2opEv                                 *
  *                                                              *
  * _Z17sqlnr_sop_fix_hxpP9sqlnq_oprPiP3loc                      *
  *                                                              *
  * _Z21sqlnr_setophxp_actionP10sqlnr_qrwaPiP14sqlnr_progress    *
  *                                                              *
  * _Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_prog
  * ss                                                           *
  *                                                              *
  * _Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass  *
  *                                                              *
  * ...                                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 9.7 fix pack 1                        *
  ****************************************************************
  

Problem conclusion

• Fixed in DB2 version 9.7 fix pack 1
  

Temporary fix

Comments

APAR Information

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

  LI74171

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSN

     UP