PI63050: DB2 ADMIN TOOL JCL ERROR DURING MIGRATION OF TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When migrating two or more tables in which one table's SPACE
  attribute from SYSIBM.SYSTABLEPART equals be -1, the Source
  Job ends with JCL Error in STEP DELCVxxx:
     IEF344I RZPFKFSS DELCVxxx CTLO2 - ALLOCATION FAILED DUE TO
             DATA FACILITY SYSTEM ERROR
     IGD17101I DATA SET >hlq<.CNC.S1 NOT DEFINED BECAUSE
             DUPLICATE NAME EXISTS IN CATALOG
             RETURN CODE IS 8 REASON CODE IS 38 IGG0CLEH
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the Migrate (MIG) function.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When migrating multiple tables          *
  *                      including table(s) with value of        *
  *                      -1 for column SPACE in                  *
  *                      SYSIBM.SYSTABLEPART, the Source         *
  *                      job ended with a JCL Error in           *
  *                      STEP DELCVxxx.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following JCL error is observed when migrating migrating
  tables including table(s) with value of -1 for column SPACE in
  SYSIBM.SYSTABLEPART:
  
  IEF344I >jobname< DELCVxxx CTLOn - ALLOCATION FAILED
               DUE TO DATA FACILITY SYSTEM ERROR
  IGD17101I DATA SET >hlq<.CNC.Sn NOT DEFINED BECAUSE
                    DUPLICATE NAME EXISTS IN CATALOG RETURN
                    CODE IS 8 REASON CODE IS 38 IGG0CLEH
  

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:

  UI43591 UI43592

Modules/Macros

•    ADB28CL  ADB28LT  ADB28M   ADB28MCT ADB28M2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI43591

     UP17/01/03 P F612

• RB20 PSY UI43592

     UP17/01/03 P F612

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.