PM69333: AUDIT REPORT SHOWS GRANT/REVOKES FOR SELECT SQL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The audit report seems to show confusing data as it lists
  GRANT/REVOKES in the overview at the beginning of the report.
  But then in the details of the report, only SELECT activity is
  shown.
  
  O2SUM:
  
     LOCATION: COLLECTIONS_WEST
        GROUP: N/P
       MEMBER: N/P
    SUBSYSTEM: ID2C
  DB2 VERSION: V10
  
   PRIMAUTH                        TOTAL
   --------------------------   ----------
   IDBXS52                              14
   *GRAND TOTAL*                        14
  AUDIT REPORT COMPLETE
  .
  .
      OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R1)
          AUDIT REPORT - SUMMARY
  
              ORDER: PRIMAUTH
               SCOPE: MEMBER
    AUTH       GRANT/      DDL      DML READ  DML WRITE
   FAILURE     REVOKE     ACCESS     ACCESS     ACCESS
  ---------  ---------  ---------  ---------  ---------
          0         11          0          0          0
          0         11          0          0          0
  .
  .
            PAGE: 1-1
  REQUESTED FROM: ALL      00:00:00.00
              TO: DATES    23:59:00.00
     ACTUAL FROM: 07/05/12 17:32:47.19
              TO: 07/05/12 17:33:26.37
      DML       AUTHID    UTILITY
    AT BIND     CHANGE     ACCESS
   ---------  ---------  ---------
           0          3          0
           0          3          0
  
  
  O2DAC:
  
     LOCATION: N/P
        GROUP: N/P
       MEMBER: N/P
    SUBSYSTEM: N/P
  DB2 VERSION: N/P
  NO DATA TO REPORT
  AUDIT REPORT COMPLETE
  .
  OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R1)
       AUDIT REPORT - DETAIL
  
  
           SCOPE: MEMBER
  .
  .
            PAGE: 0-1
  REQUESTED FROM: ALL      00:00:00.00
              TO: DATES    23:59:00.00
     ACTUAL FROM: N/P
              TO: N/P
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: IFCID361 is taken into account when     *
  *                      GRANT/REVOKE value is calculated        *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  IFCID361 is taken into account when GRANT/REVOKE
  value is calculated
  
  PROBLEM CONCLUSION:
  Only IFCID141 should be taken into account when GRANT/REVOKE
  value is calculated
  
  KEYWORDS:
  AUDIT GRANT/REVOKE SUMMARY
  

Problem conclusion

• PROBLEM CONCLUSION:
  Only IFCID141 should be taken into account when GRANT/REVOKE
  value is calculated
  
  KEYWORDS:
  AUDIT GRANT/REVOKE SUMMARY
  

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:

  UK82116 UK82117

Modules/Macros

•    DGOXBASS
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK82116

     UP12/09/27 P F209

• R511 PSY UK82117

     UP12/09/27 P F209

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.