PI24049: DB2 ADMIN TOOL ALT ON TRIGGER WITH EDIT TRIGGER BODY SHOWS UNFORMATTED DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When doing an ALT on a trigger and specifying Y to Edit
  trigger body, the trigger DDL is unformatted/wrapped and
  hard to read.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who issue the 'ALT Redefine Trigger'    *
  *                 (ALT) line command against a TRIGGER         *
  *                 on panel ADB21J 'Triggers' and the           *
  *                 trigger is defined with the SECURED          *
  *                 option.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing the ALT line command       *
  *                      against a TRIGGER defined with the      *
  *                      SECURED option on panel ADB21J,         *
  *                      then advancing to panel ADBP7J          *
  *                      'Redefine Trigger', and specifying      *
  *                      'Yes' for the field 'Edit trigger       *
  *                      body' to edit the trigger body, the     *
  *                      format of the TRIGGER body statement    *
  *                      while syntactically correct was not     *
  *                      easy to read.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The SECURED option for a TRIGGER should be supported when
  formatting TRIGGER statements.
  

Problem conclusion

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

  UI24140 UI24141

Modules/Macros

•    ADB2FMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24140

     UP14/12/31 P F412

• RB10 PSY UI24141

     UP14/12/31 P F412

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.