PH23962: ALLOCATION ERROR UNLOADING IMAGE COPY TO SORT WHEN STORED ON THESAME TAPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When unloading from an image copy (COPYDDN option), an
  allocation error resulting from an attempt to mount a tape on a
  device alreay used occurs despite of the partition PARALLELISM
  being disabled (e.g. PARALLELISM (1,,) is specified).
  This occurs when the following conditions are fulfilled :
  - the data is unloaded from image copy datasets of a partitioned
  table space taken at the partition level
  - at least two input image copy data sets
     - must be sorted
     - are stored on tape
     - and must be mounted on the same device
  The latter condition can occur because either of the following
  situation applies:
  - case 1: two input image copy data sets dynamically alloacted
  by Db2 HPU (either because COPYDDN LAST_IC/COPYDDN -n is
  specified or COPYDDN copydd and copydd is a template_name)  are
  stored on the same tape.
  - case 2: the image copy data sets are allocated under ddnames
  (COPYDDN copydd is specified and copydd is the prefix of several
  ddnames) provided by the program that invokes Db2 HPU (they are
  typically allocated through DD statements) and that have the
  UNIT=AFF=ddname attribute to share the same TAPE device
  The exact error messages depend on the case as in the following
  examples:
  case 1:
  IKJ56221I DATA SET input.image.copy.data.set NOT ALLOCATED, VO
  IKJ56221I VOLUME IS ALLOCATED TO ANOTHER JOB OR USER, TRY LATER
  INZI800E ERROR ACCESSING TO A DATASET. ACTION: ALLOCATE RC:
  0x220 REASON: 0x0
  DDN: IC000002 DSN: input.image.copy.data.set
  case 2:
  IEC146I
  513-04,IFG0194A,COPYK39,TAOHP2,COPY2,0581,BDE001,input.image.cop
  y.data.set
  

Local fix

• If applicable, unload the data from the image copy that are to
  be mounted on the same device through distinct UNLOAD commands.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When unloading from an image copy       *
  *                      (COPYDDN option), an allocation error   *
  *                      resulting from an attempt to mount a    *
  *                      tape on a device alreay used occurs     *
  *                      despite of the partition PARALLELISM    *
  *                      being disabled (e.g. PARALLELISM (1,,)  *
  *                      is specified).                          *
  *                                                              *
  *                      This occurs when the following          *
  *                      conditions are fulfilled:               *
  *                      - the data is unloaded from image copy  *
  *                      datasets of a partitioned table space   *
  *                      taken at the partition level            *
  *                      - at least two input image copy data    *
  *                      ets                                     *
  *                         - must be sorted                     *
  *                         - are stored on tape                 *
  *                         - and must be mounted on the same    *
  *                           device                             *
  *                                                              *
  *                      The latter condition can occur because  *
  *                      either of the following situation       *
  *                      applies:                                *
  *                      - case 1: two input image copy data     *
  *                      sets dynamically alloacted by Db2 HPU   *
  *                      (either because COPYDDN LAST_IC/COPYDDN *
  *                      -n is specified or COPYDDN copydd and   *
  *                      copydd is a template_name)  are stored  *
  *                      on the same tape.                       *
  *                      - case 2: the image copy data sets are  *
  *                      allocated under ddnames (COPYDDN copydd *
  *                      is specified and copydd is the prefix   *
  *                      of several ddnames) provided by the     *
  *                      program that invokes Db2 HPU (they are  *
  *                      typically allocated through DD          *
  *                      statements) and that have the           *
  *                      UNIT=AFF=ddname attribute to share the  *
  *                      same TAPE device                        *
  *                                                              *
  *                      The exact error messages depend on the  *
  *                      case as in the following examples:      *
  *                      case 1:                                 *
  *                      IKJ56221I DATA SET input.image.copy.    *
  *                      data.set NOT ALLOCATED, VO              *
  *                      IKJ56221I VOLUME IS ALLOCATED TO        *
  *                      ANOTHER JOB OR USER, TRY LATER          *
  *                      INZI800E ERROR ACCESSING TO A DATASET.  *
  *                      ACTION: ALLOCATE RC: 0x220 REASON: 0x0  *
  *                      DDN: IC000002 DSN: input.image.copy.    *
  *                      data.set                                *
  *                      case 2:                                 *
  *                      IEC146I 513-04,IFG0194A,COPYK39,TAOHP2, *
  *                      COPY2,0581,BDE001,input.image.copy.     *
  *                      data.set                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Allocation error unloading image copy to sort when stored on the
  same tape
  

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:

Modules/Macros

• INZ$$PRM INZCHECK INZSGEN  INZTDSC  INZTPMEM INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69029

     UP20/04/22 P F004

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.