IZ25820: DB2 INSTANCE CRASH WHEN CREATE SQL STORED PROCEDURE.

DB2 Version 9.5 Fix Pack 3b 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 instance crash when create stored procedure.
  The problem affects graph cleanup while compiling SQL
  procedures.
  
  If the problem occurs, will get similar stack
  Stack #1          Signal #11        Timestamp
  2008-06-16-15.40.19.745009
  0   sqlnq_qtb::box_drop
  1   sqlnq_cleanup_qurdcl
  2   sqlnq_psm_sem_act
  3   sqlnp_smactn
  4   sqlnp_parser
  5   sqlnp_main
  6   sqlnn_cmpl
  7   sqlnn_cmpl
  8   sqlra_compile_var
  9   sqlra_find_var
  10   sqlra_get_var
  11   sqlri_ddl_get_section
  12   sqlri_ddl_common
  13   sqlriddl
  14   sqlriExecThread
  15   sqlriSectInvoke
  16   sqlrr_execute_immediate
  17   sqlrr_execimmd
  18   sqljs_ddm_excsqlimm
  19   sqljsParseRdbAccessed
  20   sqljsParse
  21   sqljsSqlam
  <more stack entries...>
  

Local fix

Problem summary

• DB2 instance crash when create stored procedure.
  The problem affects graph cleanup while compiling SQL
  procedures.
  

Problem conclusion

• If the problem occurs, will get similar stac
  Stack #1          Signal #11        Timestam
  2008-06-16-15.40.19.745009
  0   sqlnq_qtb::box_drop
  1   sqlnq_cleanup_qurdcl
  2   sqlnq_psm_sem_act
  3   sqlnp_smactn
  4   sqlnp_parser
  5   sqlnp_main
  6   sqlnn_cmpl
  7   sqlnn_cmpl
  8   sqlra_compile_var
  9   sqlra_find_var
  10   sqlra_get_var
  11   sqlri_ddl_get_section
  12   sqlri_ddl_common
  13   sqlriddl
  14   sqlriExecThread
  15   sqlriSectInvoke
  16   sqlrr_execute_immediate
  17   sqlrr_execimmd
  18   sqljs_ddm_excsqlimm
  19   sqljsParseRdbAccessed
  20   sqljsParse
  21   sqljsSqlam
  <more stack entries...>
  

Temporary fix

Comments

APAR Information

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

  IZ25781

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

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R950 PSY

     UP