PI53028: ENABLE SUPPORT FOR DB2 V11 NEW AUDIT CAPABILITY.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enable support for DB2 V11 new audit capability.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use Object Compare         *
  *                 to compare tables.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 APARs PM99683, PI15298,             *
  *                      and PI15666 added an                    *
  *                      as-generated-expression-clause          *
  *                      to the column definition with the       *
  *                      GENERATED clause. The SQLREF            *
  *                      defines it as:                          *
  *                                                              *
  *                      AS ( non-deterministic-expression )     *
  *                                                              *
  *                      The non-deterministic-expression is     *
  *                      defined as:                             *
  *                                                              *
  *                      - DATA CHANGE OPERATION                 *
  *                      - special-register                      *
  *                      - session-variable                      *
  *                                                              *
  *                      A special register can be:              *
  *                      CURRENT CLIENT_ACCTNG                   *
  *                      CURRENT CLIENT_APPLNAME                 *
  *                      CURRENT CLIENT_CORR_TOKEN               *
  *                      CURRENT CLIENT_USERID                   *
  *                      CURRENT CLIENT_WRKSTNNAME               *
  *                      CURRENT SERVER                          *
  *                      CURRENT SQLID                           *
  *                      SESSION_USER | USER                     *
  *                                                              *
  *                      A session-variable is:                  *
  *                      SYSIBM.PACKAGE_NAME                     *
  *                      SYSIBM.PACKAGE_SCHEMA                   *
  *                      SYSIBM.PACKAGE_VERSION                  *
  *                                                              *
  *                      Enhancement has been provided           *
  *                      to enable DB2 Administration            *
  *                      Tool for z/OS and DB2 Object            *
  *                      Comparison Tool for z/OS to             *
  *                      support the new Audit capability        *
  *                      in DB2 for z/OS.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Enhancement has been provided to enable DB2 Administration
  Tool for z/OS and DB2 Object Comparison Tool for z/OS to
  support the new Audit capability in DB2 for z/OS.
  

Problem conclusion

Temporary fix

Comments

• Enhancement is 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

•    ADBCCM   ADBCCMM  ADBCDTS  ADBDAT   ADBDK
  ADBE6CF  ADBE6CFU ADBH1TAB ADBH6CTF ADBH6CTU ADBH6CUU ADBH7C1
  ADBPA    ADBPA1   ADBP7CK0 ADBTEPR  ADBTEPU  ADBTEP2  ADB2CID
  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2FMT  ADB2IGN  ADB2MSK  ADB2MSQ
  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES
  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2WVL  ADB21CI1 ADB21TAB
  ADB26CRT ADB26CT  ADB26CTF ADB26CTU ADB26CUU ADB26Q   ADB27AC
  ADB27C   ADB27CMR ADB27CU  ADB27DUP ADB98
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI33960

     UP15/12/23 P F512

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.