IBM Support

PM47372: In Batch Audit the command TYPE(DDL) does not result in TRACE, REPORT, FILE processings of ifcid 270 data

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Invalid processings and definitions in Batch Audit for ifcid
    270. The reported commands CREATE and ALTER TRUSTED CONTEXT
    belong to DDL.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Batch Reporting                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Ifcid 270 is not reported in Audit   *
    *                      TRACE, REPORT, nor FILEd if TYPE(DDL)   *
    *                      was requested.                          *
    *                      Instead, TYPE(AUTHCHG) processes this   *
    *                      ifcid but should not do that.           *
    *                      2. The number of DROPs and ALTERs are   *
    *                      mixed up in DDL SUMMARY report.         *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    1. TYPE(DDL) does not cause ifcid 270 data being traced,
    reported, nor filed.
    2. The number of DROPs and ALTERs are mixed up in DDL
    SUMMARY report.
    
    
    PROBLEM CONCLUSION:
    1. Hence Batch Audit processes ifcid 270 by modules that
    cover Audit DDL.
    2. The numbers of DROPs and ALTERs in DDL SUMMARY report
    have been corrected.
    

Problem conclusion

  • 1. Hence Batch Audit processes ifcid 270 by modules that
    cover Audit DDL.
    2. The numbers of DROPs and ALTERs in DDL SUMMARY report
    have been corrected.
    
    KEYWORDS : TYPE AUTHCHG AUTHORITY CHANGE DDL IFCID 270 TRUSTED
    CONTEXT SUMMARY REPORT DROP ALTER
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM47372

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-08

  • Closed date

    2011-11-22

  • Last modified date

    2011-12-02

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

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

    UK74113

Modules/Macros

  • DGOXBASS DGOXCREC DGOXCREP DGOXD000 DGOXFSQL
    DGOXF000 DGOXF001 DGOXF002 DGOXF003 DGOXF004 DGOXF005 DGOXF006
    DGOXF007 DGOXF008 DGOXF009 DGOXPCON DGOXR000 DGOXSPRT DGOXS001
    DGOXS002 DGOXS003 DGOXS004 DGOXS005 DGOXS006 DGOXS007 DGOXT000
    DGOXT001 DGOXT002 DGOXT003 DGOXT004 DGOXT005 DGOXT006 DGOXT007
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R510 PSY UK74113

       UP11/11/24 P F111

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 December 2011