PH07657: DB2 ADMINISTRATION TOOL - CATALOG COPY USABILITY ISSUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During Catalog Copy, LOAD into catalog copy table SYSCONTROLS
  failed with:
     DSNU053I - FIELD 'DSN_ROWEND' NOT FOUND
  
  Several Catalog Copy usability issues likely contributed
  to this incident. The following issues will be addressed.
  
  Catalog Copy usability issues:
  1. END/F3 from confirmation panel ADB2CCJX doesn't allow Enter
     key on panel ADB2CCJ to progress. User currently has to
     END/F3 from ADB2CCJ 'Create Catalog Copy and Bind Batch Jobs'
     and enter line command "J" on panel ADB2CCD 'Display Catalog
     Copy Versions' to get around this.
  2. Update associated help panel on recommended use (best
     practice) of CC.
  3. Ensure file <hlq>.GENDROPD drops objects that may have
     RESTRICT ON DROP.
  4. FREE DD(ADB2CJCL) upon exiting CC.
  

Local fix

• Contact Db2 Tools Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Improve usability of Catalog Copy and   *
  *                      help panel information in an effort to  *
  *                      reduce manual intervention to resolve   *
  *                      SQLCODE = -204 and SQLCODE = -672.      *
  *                      Cleanup instructions/guidelines have    *
  *                      also been added to help panel ADBHCCJ   *
  *                      on how to resolve error message         *
  *                      "FIELD 'DSN_ROWEND' NOT FOUND" after    *
  *                      submitting generated job CPYRUNxx.      *
  *                                                              *
  *                      SQLCODEN204 / SQLCODEN672               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Catalog Copy issues when using option CC from panel ADB2:
   1. END/F3 from Catalog Copy confirmation panel ADB2CCJX
      'Duplicate Object Notification' doesn't allow Enter key on
      panel ADB2CCJ 'Create Catalog Copy and Bind Batch Jobs' to
      progress further.
   2. Help panel lacks information on what job to submit first.
   3. Help panel lacks informational guidelines on what to do
      should DBA have a need to drop/recreate associated database
      for Catalog Copy. Without this information can lead to
      SQLCODE=-204, -672, and/or error message "FIELD
      'DSN_ROWEND' NOT FOUND"
   4. Generated file '<hlq>.GENDROPD' does not drop objects that
      may have RESTRICT ON DROP.
   5. The following error message will occur when "Unit name"
      input field is blank on BP panel ADB2UPA.
      ISPZ000 OUTPUT file error: Error allocating dataset
       <hlq>.GENDROPD. ALLOC DD(DROPDD)
       DA('<hlq>.GENDROPD') NEW CATALOG LRECL(80)
       RECFM(F B) DSORG(PS) SPACE(5 5) TRACKS
       UNIT() REU
  

Problem conclusion

• Problems have 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:

  UI63333

Modules/Macros

•    ADBHCCD  ADBHCCJ  ADB2CC   ADB2CCJ  ADB2CCM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63333

     UP19/06/04 P F906

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.