PI55359: REPORT UNIQUE CONSTRAINTS ON TOTALS REPORT.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Report unique constraints on Totals Report.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the Change Management batch          *
  *                 interface (CM batch).                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Change Management Analyze phase     *
  *                      is enhanced to show totals for Unique   *
  *                      Constraints in the 'Totals Report'      *
  *                      for a multi-target change.  The 'Totals *
  *                      Report' is only available in CM batch.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Unique Constraints is an important statistic in determining
  the scope of a change, but it was not previously reported.
  

Problem conclusion

Temporary fix

Comments

• The CM Analyze phase now shows Unique Constraints in the
  'Totals Report' for a multi-target change.  The 'Totals Report'
  is only available in CM batch.
  
  
  The 'Totals Report' will contain a line in the report
  describing the Object Type, in this case 'Unique Constraints'
  the type of action(s) performed for the Unique Constraints,
  and a total sum of the actions performed:
  
  Totals Report
  =============
  
  Object Type       Alter  Create   Drop   Recreated   Totals
  -----------       -----  -------  -----  ----------  -------
   ......
  Unique Constraints    0        0      0           0        0
  -----------------  ----- -------  -----  ----------  -------
  Totals                0        0      0           0        0
  
  Where:
   Alter:      There are no altered unique constraints
   Create:     constraints added with a new table or
               constraints added on existing table
   Drop:       constraints dropped with a dropped table or
               constraints dropped from existing table
               (if the constraint is on target only)
   Recreated:  constraints without any changes, that are
               dropped and recreated because the table is
               dropped and recreated
  
  The DB2 Administration Tool for z/OS User's Guide and
  Reference, Version 11, Release 2 has been updated:
  
  https://ibm.biz/BdHTdA
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADBCCM   ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM1  ADB2CM2  ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI35223

     UP16/02/11 P F602

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.