PM14372: AN ABEND0C1, ABENDU1010, OR AN INCORRECT RESULT CAN OCCUR WHEN SEVERAL SELECT ARE PROCESSED BY DB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABEND0C1, or an ABENDU1010, or an incorrect result
  (potentially duplicated lines in the output files) can occur
  when several SELECT statements are processed by DB2 while other
  SELECT statements are processed natively on the same tablespaces
  in the same HPU invocation and with parallelism between the
  tablespaces activated (parmlib variable VUX030/UTLPARAL
  greater than the 1st or 3rd sub-parameter of PARALLELISM sysin
  option set to a value greater than 1).
  PB10693
  

Local fix

• Possible bypass consists in setting parmlib parameter
  VUX030/UTLPARAL to 1 or specifying PARALLELISM(,,1) in SYSIN.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU 3.1 only: An abend S0C1, or an      *
  *                      abend U1010, or an incorrect result     *
  *                      (potentially duplicated lines in the    *
  *                      output files) can occur when several    *
  *                      SELECT statements are processed by DB2  *
  *                      while other SELECT statements are       *
  *                      processed natively on the same          *
  *                      tablespaces in the same HPU invocation, *
  *                      with parallelism between TS activated   *
  *                      (parmlib variable VUX030/UTLPARAL > 1   *
  *                      or 3rd sub-parameter of PARALLELISM     *
  *                      sysin option set to a value greater     *
  *                      than 1). Possible bypass consists in    *
  *                      setting parmlib parameter               *
  *                      VUX030/UTLPARAL to 1 or specifying      *
  *                      PARALLELISM(,,1) in SYSIN.              *
  *                      PB 10693                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Temporary file handling was fixed in inzspusq  module.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK58894

     UP10/07/23 P F007

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.