PH25388: VARIOUS FIXES FOR V3.5.0

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When generating UNDO / REDO SQL the product generates a 6 byte
  URID value in comments.
  This APAR will extend the URID value by splitting the comment
  rows.
  Also, several changes will be implemented for Catalog Audit
  Report, including the extension of procedure names in the report
  and adding support of CREATE MASK action.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Fix 2 periods (..) between collid    *
  *                         and package name in the FREE PACKAGE *
  *                         entry;                               *
  *                      2. Remove starting period for package   *
  *                         name (location is used as the first  *
  *                         qualifier, but it is always spaces); *
  *                      3. Extend procedure name to include     *
  *                         schema qualifier;                    *
  *                      4. Add CREATE MASK support              *
  *                         (+ DROP MASK etc.);                  *
  *                      5. Add restriction to prevent reporting *
  *                         FREE PACKAGE if it was invalidated   *
  *                         (update action for PACKAGES isn't    *
  *                         supported)                           *
  *                      6. Fix CREATE/DROP ALIAS is reported    *
  *                         as CREATE/DROP view.                 *
  *                                                              *
  *                      Extend the URID value in the SQLOUT     *
  *                      comments.                               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

• Apply the PTF
  

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:

  UI70643

Modules/Macros

• ALABSQL  ALACTAU  ALAPRI
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI70643

     UP20/07/22 P F007

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.