PI45088: FORMATTING OF CHANGE STATEMENTS WHEN REGISTERING A CHANGE VIA AL T.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Formatting of Change Statements when registering a change via
  ALT functions.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Change Management when using    *
  *                 the 'ALT Alter Table' (ALT).                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When registering a change using ALT,    *
  *                      the change statements are not           *
  *                      formatted, 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.
  
  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 "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:

Modules/Macros

•    ADBALT   ADBCRCM  ADBEALT  ADB2CMF  ADB2CMP
  ADB2CMR  ADB2CMT  ADB27CAA ADB9000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI29705

     UP15/08/20 P F508

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.