PM77220: MSGDSNU1015I ERROR ALLOCATING DATASET CODE=X'02200000' MSGIKJ56221I DATA SET NOT ALLOCATED RC08 RC8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool or DB2 Object Comparison Tool
  for z/OS report drop/create scenarios that fail when UNLOAD
  data goes to TAPE device, and TEMPLATE statement for TAPE
  includes STACK YES parm. Job fails in LOAD utility.
  .
  Error messages appear similar to:
  .
  DSNU1015I   312 10:31:12.11 DSNUGDYN - ERROR ALLOCATING DATA
    SET DSN=<datasetname> CODE=X'02200000' .
  .
  IKJ56221I DATA SET <datasetname> NOT ALLOCATED, VOLUME NOT
     AVAILABLE+ .
  IKJ56221I VOLUME  IS ALLOCATED TO ANOTHER JOB OR USER, TRY LATER
  

Local fix

• Remove STACK YES parm from tape TEMPLATE statement
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool or DB2  *
  *                 Object Comparison Tool for z/OS who use      *
  *                 ADBTEP2 Batch Restart program to run Work    *
  *                 Statement List (WSL) statements in which an  *
  *                 UNLOAD of data goes to a TAPE / 'removable   *
  *                 media' / 'CART' / '3480' device with the     *
  *                 STACK option set to 'YES'.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool or DB2       *
  *                      Object Comparison Tool for z/OS,        *
  *                      DROP/CREATE scenarios fail in the       *
  *                      LOAD utility with an allocation         *
  *                      error if an UNLOAD of data goes         *
  *                      to a TAPE  / 'removable media' /        *
  *                      'CART' / '3480' device and the          *
  *                      TEMPLATE statement for the device       *
  *                      includes the STACK='YES' parameter.     *
  *                      Error messages appear similar to:       *
  *                      .                                       *
  *                      DSNU1015I 312 10:31:12.11               *
  *                      DSNUGDYN - ERROR ALLOCATING             *
  *                      DATA SET                                *
  *                      DSN=>datasetname<                       *
  *                      CODE=X'02200000'.                       *
  *                                                              *
  *                      IKJ56221I DATA SET >datasetname<        *
  *                      NOT ALLOCATED, VOLUME NOT               *
  *                      AVAILABLE+.                             *
  *                      IKJ56221I VOLUME IS ALLOCATED           *
  *                      TO ANOTHER JOB OR USER, TRY             *
  *                      LATER                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool or DB2 Object Comparison Tool for
  z/OS, DROP/CREATE scenarios fail in the LOAD utility with an
  allocation error 'VOLUME NOT AVAILABLE+' if an UNLOAD of data
  goes to a TAPE  / 'removable media' /  'CART' / '3480' device
  and the TEMPLATE statement for device includes the STACK='YES'
  parameter.
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADBETEP  ADBTEP2  ADB2PA6
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK93463

     UP13/04/18 P F304

• RA20 PSY UK93464

     UP13/04/18 P F304

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.