How To
Summary
The document guides you on the requirements and steps to create a report of PTF Operations.
Objective
To be able to create a report that contains PTF operations for a time period.
Environment
The Security Audit Journal can be used to track PTF operations. The following document creates a report of Load, Apply and Remove PTF operations.
The AUDIT_JOURNAL_PF table function returns rows from the audit journal that contain information from the PF (PTF Operations) journal entries.
Note: The AUDIT_JOURNAL_PF table function is available on IBM i 7.5 SF99950 Level 4 & IBM i 7.4 SF99704 Level 25.
Before you start, verify that the QAUDJRN journal exists and that you have *PTFOPR as part of your QAUDLVL system value.
Use the DSPSECAUD command and make sure the following settings are configured on your system:
Security journal QAUDJRN exists . . . . . : YES
Current QAUDCTL system value . . . . . . : *AUDLVL
Current QAUDLVL system value . . . . . . : *PTFOPR
If not there, use the CHGSECAUD command to add them to your system. Keep in mind that the auditing values need to be active on your system before the report can be generated.
Steps
1) Open the ACS Run SQL Scripts tool
2) Run the following SQL:
SELECT JOB_NAME,
JOB_USER,
JOB_NUMBER,
ENTRY_TYPE,
ENTRY_TYPE_DETAIL,
PRODUCT_ID,
PTF_IDENTIFIER,
APPLY_TYPE,
ENTRY_ACTION_DETAIL
FROM TABLE (
SYSTOOLS.AUDIT_JOURNAL_PF(STARTING_TIMESTAMP => CURRENT DATE - 7 DAY)
)
Note 1: Modify the number of days for the report.
Additional Information
More information on the AUDIT_JOURNAL_PF table function:
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHyAAM","label":"Security"}],"ARM Case Number":"TS016746582","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0"}]
Was this topic helpful?
Document Information
Modified date:
23 July 2024
UID
ibm17160970