PH60938: ALLOCATION ERROR OF DSNAOINI TEMPORARY DATASET WHEN PROCESSING HPU VIA OMVS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When HPU is processed via OMVS, if several HPU processes are
  started at the same time, some processes can terminate in error
  when allocating the DSNAOINI temporary dataset.
  HPU is passing &DSNAOIN in the dataset name text unit which will
  build a temporary dataset name including DSNAOIN and may result
  in duplicate datasets names when multiple tasks are running at
  the same time. The generated dataset name respects the following
  template : SYSyyddd.Thhmmss.RA000.jjobname.DSNAOIN.Hgg
  HPU should implement the following solution :
  Omits the dataset name on the dynamic allocation resulting in a
  dataset in the following form where nnnnn is a unique number
  within the system : SYSyyddd.Thhmmss.RA000.jjobname.Rggnnnnn
  

Local fix

• manually allocate a dataset to the DSNAOINI ddname with the
  following content :
  [COMMON]
  MVSDEFAULTSSID=coid
  MVSATTACHTYPE=CAF
  PLANNAME=cli-plan-name
  where :
  * coid = the Db2 sub-system specified for the process
  * cli-plan-name = the CLI plan name (default DSNACLI)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU invoked from OMVS terminates    *
  *                      in error (completion code of 8) when    *
  *                      dynamically allocating a temporary      *
  *                      dataset after having issue the          *
  *                      INZI337E message as in the example      *
  *                      below:                                  *
  *                         INZI337E DYNAMIC ALLOCATION FAILED   *
  *                         FOR TEMPORARY FILE=&DSNAOIN          *
  *                                  RC=-26868, REASON=0x0       *
  *                                  SVC99 MESSAGES ARE          *
  *                                  REPORTED IN JESMSGL CARD    *
  *                                                              *
  *                      This can unpredictably occur if at      *
  *                      least Db2 HPU unloads invoked from OMS  *
  *                      are running concurrently. The issue     *
  *                      occurrence probability is bigger when   *
  *                      Db2 HPU is invoked from OMVS several    *
  *                      times almost simultaneously             *
  *                      (same second) and more likely concerns  *
  *                      the allocation of the &DSNAOINI         *
  *                      temporary file allocated for the        *
  *                      DSNAOINI ddname used for Db2            *
  *                      invocations.                            *
  *                                                              *
  *                      When allocating temporary datasets,     *
  *                      Db2 HPU relies on the jobname included  *
  *                      in the dataset name to guarantee the    *
  *                      uniqueness of temporary datasets which  *
  *                      is not suitable for programs invoked    *
  *                      by OMVS as two runs of the same         *
  *                      program don't have distinct jobnames.   *
  *                                                              *
  *                      Local fix : none but either or both of  *
  *                      the following can significantly         *
  *                      decrease the frequency of this issue.   *
  *                      - ensure a time difference of more      *
  *                        than one second between two           *
  *                        invocations of Db2 HPU from OMVS.     *
  *                      - when invoking Db2 HPU from OMVS,      *
  *                        manually allocate a dataset under     *
  *                        the DSNAOINI ddname with the          *
  *                        following content :                   *
  *                      [COMMON]                                *
  *                      MVSDEFAULTSSID=coid                     *
  *                      MVSATTACHTYPE=CAF                       *
  *                      PLANNAME=cli-plan-name                  *
  *                                                              *
  *                      where :                                 *
  *                      coid = the Db2 sub-system specified     *
  *                      for the process                         *
  *                      cli-plan-name = the CLI plan name       *
  *                      (default DSNACLI)                       *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  allocation error of  temporary dataset when more than two Db2
  HPU unload invoked from OMVS and run concurrently
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI97393

Modules/Macros

• INZ$$CCQ INZ$$PRM INZMQRY  INZPARM  INZTDSC  INZTOOLS INZTVAR
  INZUTIB1 INZUTIB2 INZUTILC INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI97393

     UP24/07/01 P F406

• R520 PSY UI97541

     UP24/07/03 P F407

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.