PI53423: FORMAT CHANGE STATEMENTS - PART 2.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Format change statements - Part 2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Change Management (CM) when     *
  *                 using the 'ALT Alter Table' (ALT) function   *
  *                 and the APPLY method to process virtual      *
  *                 changes on panel ADB2CCR 'Pending            *
  *                 Changes - Conflict Resolution'.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When registering a change using ALT,    *
  *                      the change statements are not           *
  *                      formatted when pending changes          *
  *                      are applied, making it difficult        *
  *                      for the user to find specific tokens    *
  *                      within the change statement text.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following enhancements are delivered:
  
  1- Formatting of the change statements that are generated by
  the ALT function that will be registered as part of a change.
  This enhancement will take care of formatting when option
  'Apply virtual changes' is set to 'APPLY' on panel ADB2CCR
  to process virtual changes.
  
  2- In some cases, a more granular change statement, for
  example, (ADMIN) ALTER statement will now be generated
  instead of the more common ADMIN DROP/CREATE pair of
  statements. The content of the Work Statement List ( WSL )
  during a 'Run Change' should have no differences regardless
  of the change statement.
  

Problem conclusion

Temporary fix

Comments

• Formatting enhancements are delivered.
  

APAR Information

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

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

  UI34273

Modules/Macros

•    ADBALT   ADBCVC   ADBEALT  ADB27CAA ADB27CX
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI34273

     UP16/01/09 P F601

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.