Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

Printing an Audit Trail Report


To access the Print Audit Trail Specification screen, select option 5, PRINT, from the Primary Options menu, then select option 2, Print Audit Trail, from the Print Menu screen.

Print Audit Trail Specification Screen

On the Print Audit Trail Specification screen (Print - Audit Trail Facility Screen) you can specify the printer destination and sysout class for printing an audit trail dataset, as well as optional selection criteria. The name of the data set and your job card information also appear on the screen for you to verify. Enter either SUB on this screen to submit the batch job or JCL to edit the JCL and manually submit the job. To exit this screen without printing the report, enter END.

Warning

Important

Starting with File-AID for Db2 Release 6.1, the Audit report destination DD has changed from SYSTERM to F2SYSOUT. Audit report batch JCL generated in File-AID for Db2 Release 6.1 contains a F2SYSOUT DD statement. If you need to use existing JCL generated in an earlier release of File-AID for Db2 and with a File-AID for Db2 Release 6.1 or higher load library, add the F2SYSOUT DD statement in the JCL.
If no F2SYSOUT DD is specified, File-AID for Db2 will use SYSTERM DD for the Audit report destination, however, we strongly recommend to add F2SYSOUT DD.

Print - Audit Trail Facility Screen

image2021-3-12_10-6-47.png

Dataset Name

Specifies the audit trail dataset name. Defaults to the most current audit trail dataset. You may override the dataset name.

Printer Destination

Required. Enter the printer destination for the audit trail report.

Sysout Class

Required. Enter the sysout class for the audit trail report.

Lines Per Page

Required. Enter the maximum number of lines to print per page.

Optional Selection Criteria

Specify whether the Audit Trail Selection Criteria screen appears.

NO

Submits the job without selection criteria.

YES

Displays the Audit Trail Selection Criteria screen (Print — Audit Trail Selection Criteria).

Job Card Information

Enter a valid job card. See Option 3, Batch Options for entering a default job card.

Print Audit Trail Selection Criteria Screen

The Print Audit Trail Selection Criteria screen (Print — Audit Trail Selection Criteria) appears when YES is entered in the OPTIONAL SELECTION CRITERIA field on the Print Audit Trail Specification screen. You can print selected records based on starting and ending dates, starting and ending times, primary AUTHID, secondary AUTHID, creator name, and table name. Since a separate data set is created for every audit trail generated, this option is most useful if you have combined your audit trail datasets. Enter SUB to submit the JCL. Enter JCL to edit the JCL and submit manually. Enter END to exit without printing the report.

Print — Audit Trail Selection Criteria

image2021-3-12_10-7-57.png

Starting/Ending Date

Enter a range of dates for selecting audit trail records. Dates default to the present date. A wild character (*) is valid at the end of a partial date.

Starting/Ending Time

Enter a range of times for selecting audit trail records. Starting time defaults to 00:00:00. Ending time defaults to 23:59:59. A wild character (*) is valid at the end of a partial time.

Primary AUTHID

Enter a primary AUTHID. A wild character (*) is valid at the end of a partial string.

Secondary AUTHID

Enter a secondary AUTHID. A wild character (*) is valid at the end of a partial string.

Creator Name

Enter a creator name. A wild character (*) is valid at the end of a partial string.

Table Name

Enter a table name. A wild character (*) is valid at the end of a partial string.

Sample Audit Trail Report

Warning

Important

Whenever a character field contains a non-displayable character the hexadecimal representation for that field is always printed on the Audit Trail Report.

Example Audit Trail Report

image2021-3-12_10-9-19.png

Related topics


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID for Db2 21.01