PH50611: UNLOAD FAILS FOR A TABLE IN INCOMPLETE STATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare generates an UNLOAD for tables if it is needed to
  apply changes. But if the table on target is in an incomplete
  state, then this UNLOAD will fail. Compare should stop
  processing if an incomplete state is detected for a table that
  needs an UNLOAD and should warn the user that an incomplete
  state needs to be resolved.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use Object Compare                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare generates an UNLOAD      *
  *                      statement for tables to apply some      *
  *                      changes. However, if the table is in    *
  *                      an incomplete state, the UNLOAD         *
  *                      operation fails.                        *
  ****************************************************************
  This APAR corrects this problem as follows:
  When Object Compare generates an UNLOAD statement for a table,
  it checks the status of the target table. If the table is in an
  incomplete state, new error message ADB7409E is issued.
  

Problem conclusion

• The 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

• ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2CMU  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI90396

     UP23/02/10 P F302

• RD10 PSY UI90397

     UP23/02/10 P F302

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.