IC83294: POSSIBLE TRAP IN SQLNO_AT_COORDINATOR WITH INTRA_PARALLEL ON

DB2 Version 9.7 Fix Pack 7 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 9a 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

• Possible trap in sqlno_at_coordinator with INTRA_PARALLEL ON
  with the following stack:
  
   <sqlno_at_coordinator>
  <E:\db2_v97fp5\ntx64\s111017\engn\include\sqlno_crule_inline.h:4
  525>
   <sqlng_process_mate_op> <sqlng_opt.C:1878>
   <sqlng_process_pipe_op> <sqlng_opt.C:1410>
   <sqlng_process_mate_op> <sqlng_opt.C:1987>
   <sqlng_process_pipe_op> <sqlng_opt.C:1410>
   <sqlng_build_thread> <sqlng_aux.C:874>
   <sqlng_process_smptq_op> <sqlng_smptq.C:306>
   <sqlng_process_tq_op> <sqlng_tq.C:467>
   <sqlng_process_return_op> <sqlng_opt.C:1063>
   <sqlng_build_thread> <sqlng_aux.C:726>
   <sqlng_main> <sqlng_exe.C:1683>
   <sqlnn_cmpl> <sqlnn_cmpl.C:3953>
   <sqlnn_cmpl> <sqlnn_cmpl.C:530>
  

Local fix

• turn off INTRA_PARALLEL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 9.7 Fix Pack 7.                       *
  ****************************************************************
  

Problem conclusion

• See Problem Description.
  

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:

  IC87866

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSN

     UP