Print disguise audit trail


The following panel is displayed when you select Option A, Print Audit, from the Data Privacy Menu.

 File-AID/RDX ----------------  Print Disguise Audit Trail  ---------------------
 Command ===>

 Primary commands: JCL view, Go to submit job

 Specify Audit Trail Information:
   Audit trail dataset     ===> 'TSOID01.RDXA.D010.D150722.T164243.M345'
   Print format            ===> H       (H = Hex; C = Character)
   Records to print        ===> 10      (nnn = number; ALL)
   Audit trail disposition ===> PK      (PK = Print dataset and keep;
                                         PD = Print dataset and delete)

 Specify Batch JCL Information:
   Sysout class            ===> *

Use this screen to request File-AID/RDX to print the contents of the audit trail that File-AID/Data Solutions created for each object being disguised. The audit trail print provides the before and after images of the disguised record. An audit trail for disguised objects will only be created when your File-AID/Data Solutions installation enforces auditing or you disguise extract request called for an audit trail.

Audit trail dataset

Specify the file name of the disguise audit trail dataset you want printed. A separate audit trail dataset is created for each disguised object of the extract (identified by its extract data record number (Dnnn). The Data Privacy Summary Report created for the disguise extract lists the audit trail dataset for each disguised object (see also Audit File). The naming convention for each Audit Trail dataset is:

prefix.RDXA.DnnnBnnn.Dyymmdd.Thhmmss.Msss

The prefix is specified when the Extract File is disguised. Dnnn is the identifing number assigned to the object in the Extract File. Bnnn is only used when an Audit Trail is produced for an MVS object that uses an XREF; Bnnn is the layout number within the XREF.

Print format

Specify whether the disguise audit trail is to be printed in character or hex mode. Formatted printing is not supported.

H

Hex. The disguise audit trail prints in hex mode. The Hex format will print three lines for each data line; a character line, a zone line and a digit line.

C

Character. The disguise audit trail prints in character mode. The character format will print a single line for each data line.

Both reports format 100 positions of the record per print line. The after images for each 100 positions only prints when the data in those positions has changed. A change flag line identifies the changed data positions.

Records to print

You can limit the number of audit records printed. This limit count is a record count; the before and after images are considered two records.

nnn

Maximum number of records to print.

ALL

All records.

Audit trail disposition

Enter one of the following:

PK

Print and Keep the audit trail dataset.

PD

Print and Delete the audit trail dataset.

Sysout class

Enter the sysout class for the Audit Trail Report.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

JCL

View the JCL for the Audit Trail Print utility. File-AID/RDX shows the Generated JCL panel where you review and modify the print JCL. Enter the SUBMIT command to submit the print job.

GO (G)

Submits this Audit Trail Print request without displaying the JCL. Before issuing the GO command, make sure you have specified the desired print options as well as the audit trail file. File-AID/RDX will also issue a message upon completion of the job.

Printing multiple audit trail datasets

When you want to concatenate multiple audit trail datasets together and produce a separate Audit Trail Report for each data set with one batch job execution, edit the generated JCL before submitting the batch job.

Audit trail report

The Audit Trail Report is printed by the batch job submitted from the Print Audit Trail screen. The report displays the audit trail contents and is printed in a character or hexadecimal format. The report also contains summary information.

Samples of the character and hexadecimal formats of the Audit Trail Report are shown in Audit Trail Report — Hexadecimal and Audit Trail Report — Character.

Each page of the Audit Trail Report begins with page headings that consist of the edited data set name, the date and time the report was produced, the File-AID/Data Solutions release number, and the page number.

Following the page headings is the date and time when the data file was opened for disguise, and the TSO user ID that was used to perform the disguise. If the data file organization was VSAM-KSDS, File-AID/RDX includes the starting position and length of the defined key.

Preceding the image of each data file disguise on the report are audit trail record headings. The first line contains a sequential number assigned to each data file disguise, the disguise action (explained more fully below), and the date and time the disguise occurred.

For VSAM-RRDS data files, File-AID/RDX includes the relative record number of the disguised record.

HEX Print Report Contents

When printing the audit trail contents in HEX, File-AID/RDX displays each record in a three-line format similar to the hexadecimal mode of BMC AMI DevX File-AID/MVS Edit unformatted mode. The top line contains the character representation of the record, the middle line contains the upper half-byte of each character in HEX, and the third line contains the lower half-byte of each character in hexadecimal.

Up to l00 positions of the record are printed in each set of three lines. The POSITION column immediately to the left of the record contents indicates the starting position in the record represented by each set of three lines. For the updated records, the before image is printed, followed immediately by the after image, if a change has occurred on that line.

When the before and after images of a changed record are displayed, the Audit Trail Report also indicates the record positions that were changed with an asterisk (*) under each changed position. For each three-line set of print lines that contains changed record positions, CHANGE ===> is printed to the left and between the print lines, on the same line as the asterisks.

Audit Trail Report — Hexadecimal

02 SEP 2004  15:47:00                       File-AID/RDX 4.2 DISGUISE AUDIT TRAIL REPORT                           PAGE:           1
EXTRACT FILE : TSOID01.R42.EXTRACT                                               OPENED ON: 30 AUG 2004 AT 14:47:34  USER ID:  TSOID01
SOURCE OBJECT: TSOID01.R42.TESTDA.EMPMAST
RECORD LAYOUT: EMPLOYEE-MASTER-FILE

====================================================================================================================================
UPDATE NUMBER:              1                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

 BEFORE      POSITION 1     00090MARTIN         EDWARD    M  AIRPLANE MANUFACTURER         427890125 101954920101M30000}
               ZONE          FFFFFDCDECD444444444CCECDC4444D44CCDDDCDC4DCDECCCEEDCD444444444FFFFFFFFF4FFFFFFFFFFFFDFFFFFD04005005
               DIGIT         0009041939500000000054619400004001997315504154613349590000000004278901250101954920101430000070D20C00
  CHANGE--->                     * ***         *** ****
 AFTER       POSITION 1     00090MURPHY         JONATHON  M  AIRPLANE MANUFACTURER         427890125 101954920101M30000}
               ZONE          FFFFFDEDDCE444444444DDDCECDD44D44CCDDDCDC4DCDECCCEEDCD444444444FFFFFFFFF4FFFFFFFFFFFFDFFFFFD04005005
               DIGIT         0009044978800000000016513865004001997315504154613349590000000004278901250101954920101430000070D20C00
 BEFORE      POSITION 101     859 O'FARREL ST.          SAN FRANCISCO  CA  12121BILL JONES                 40855558974155556981
               ZONE          0FFF4D7CCDDCD4EE44444444444ECD4CDCDCCECD44CC44FFFFFCCDD4DDDCE44444444444444444FFFFFFFFFFFFFFFFFFFF
               DIGIT         C85906D619953023B000000000021506915392360031001212129330165520000000000000000040855558974155556981
====================================================================================================================================
UPDATE NUMBER:              2                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     00100MULSTROM       ROBERTA   A  HOLLYWOOD SEAMSTRESS          346573656 090859920111S80000{&
               ZONE          FFFFFDEDEEDDD4444444DDCCDEC444C44CDDDEEDDC4ECCDEEDCEE4444444444FFFFFFFFF4FFFFFFFFFFFFEFFFFFC05005007
               DIGIT         0010044323964000000096259310001008633866640251423952200000000003465736560090859920111280000050C00C10
  CHANGE--->                     ** *****
 AFTER       POSITION 1     00100ELLIOT         ROBERTA   A  HOLLYWOOD SEAMSTRESS          346573656 090859920111S80000{&
               ZONE          FFFFFCDDCDE444444444DDCCDEC444C44CDDDEEDDC4ECCDEEDCEE4444444444FFFFFFFFF4FFFFFFFFFFFFEFFFFFC05005007
               DIGIT         0010053396300000000096259310001008633866640251423952200000000003465736560090859920111280000050C00C10
 BEFORE      POSITION 101   4701 N. BASCOM AVE. #430  ANAHEIM        CA  95126GEORGE                     21555520102155559021
               ZONE          0FFFF4D44CCECDD4CEC447FFF44CDCCCCD44444444CC44FFFFFCCDDCC444444444444444444444FFFFFFFFFFFFFFFFFFFF
               DIGIT         C470105B02123640155B0B4300015185940000000031009512675697500000000000000000000021555520102155559021
====================================================================================================================================
UPDATE NUMBER:              3                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     00200JACKSON        JOSEPH    C  ORATOR                        275587177 020462920121S00000{&
               ZONE          FFFFFDCCDEDD44444444DDECDC4444C44DDCEDD444444444444444444444444FFFFFFFFF4FFFFFFFFFFFFEFFFFFC05000000
               DIGIT         0020011322650000000016257800003006913690000000000000000000000002755871770020462920121200000050C20C00
  CHANGE--->                     ****
 AFTER       POSITION 1     00200NIELSON        JOSEPH    C  ORATOR                        275587177 020462920121S00000{&
               ZONE          FFFFFDCCDEDD44444444DDECDC4444C44DDCEDD444444444444444444444444FFFFFFFFF4FFFFFFFFFFFFEFFFFFC05000000
               DIGIT         0020059532650000000016257800003006913690000000000000000000000002755871770020462920121200000050C20C00

 BEF
ORE      POSITION 101   1401 S. BASCOM AVE.       CANOGA PARK    CA  94106ANGELA                     21255520102125559021
               ZONE          0FFFF4E44CCECDD4CEC44444444CCDDCC4DCDD4444CC44FFFFFCDCCDC444444444444444444444FFFFFFFFFFFFFFFFFFFF
               DIGIT         C140102B02123640155B000000031567107192000031009410615753100000000000000000000021255520102125559021
====================================================================================================================================

Character Report Contents

The character audit trail report is similar to the HEX report except that the two hexadecimal lines are not printed. Unprintable characters are printed as blanks.

Audit Trail Report — Character

02 SEP 2004  15:47:00                       File-AID/RDX 4.2 DISGUISE AUDIT TRAIL REPORT                           PAGE:           1
EXTRACT FILE : TSOID01.R42.EXTRACT                                              OPENED ON: 30 AUG 2004 AT 14:47:34  USER ID:  TSOID01
SOURCE OBJECT: TSOID01.R42.TESTDA.EMPMAST
RECORD LAYOUT: EMPLOYEE-MASTER-FILE
====================================================================================================================================
UPDATE NUMBER:              1                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     00090MARTIN         EDWARD    M  AIRPLANE MANUFACTURER         427890125 101954920101M30000}
  CHANGE--->                     * ***         *** ****
 AFTER       POSITION 1     00090MURPHY         JONATHON  M  AIRPLANE MANUFACTURER         427890125 101954920101M30000}
 BEFORE      POSITION 101   859 O'FARREL ST.          SAN FRANCISCO  CA  12121BILL JONES                 40855558974155556981
====================================================================================================================================
UPDATE NUMBER:              2                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     00100MULSTROM       ROBERTA   A  HOLLYWOOD SEAMSTRESS          346573656 090859920111S80000{
  CHANGE--->                     ** *****
 AFTER       POSITION 1     00100ELLIOT         ROBERTA   A  HOLLYWOOD SEAMSTRESS          346573656 090859920111S80000{&
 BEFORE      POSITION 101   4701 N. BASCOM AVE. #430  ANAHEIM        CA  95126GEORGE                     21555520102155559021
====================================================================================================================================
UPDATE NUMBER:              3                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     00200JACKSON        JOSEPH    C  ORATOR                        275587177 020462920121S00000{&    
  CHANGE--->                     ****
 AFTER       POSITION 1     00200NIELSON        JOSEPH    C  ORATOR                        275587177 020462920121S00000{&    
 BEFORE      POSITION 101   1401 S. BASCOM AVE.       CANOGA PARK    CA  94106ANGELA                     21255520102125559021
====================================================================================================================================
UPDATE NUMBER:              4                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     10000ANDREWS        GEORGE       ACTOR                         576312032 042248920131S00000{    &
  CHANGE--->                     *******
 AFTER       POSITION 1     10000PEI            GEORGE       ACTOR                         576312032 042248920131S00000{    & &
 BEFORE      POSITION 101   375 MERRIVALE W. SQ.      SUNNYVALE      CA  94134DICK                       40455520104045559021
====================================================================================================================================
UPDATE NUMBER:              5                                 ACTION: CHANGE    RECORDED: 30 AUG 2004 AT 14:47:34
DATA DISPLAYED              ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 BEFORE      POSITION 1     15000MURPHY         RONALD    L  PAINTER                       987654321 120255920201S50000{ ø    
  CHANGE--->                     *** ***
 AFTER       POSITION 1     15000SIMPSON        RONALD    L  PAINTER                       987654321 120255920201S50000{ ø    
 BEFORE      POSITION 101   7716 HAWTHORNE AVE.       SANTA CLARA    CA  95025JEFF                       31255520103125559021
 ====================================================================================================================================
 02 SEP 2004  15:47:00                       File-AID/RDX 4.2 DISGUISE AUDIT TRAIL REPORT                           PAGE:          18
EXTRACT FILE : TSOID01.R42.EXTRACT                                               OPENED ON: 30 AUG 2004 AT 14:47:34  USER ID:  TSOID01
SOURCE OBJECT: TSOID01.R42.TESTDA.EMPMAST

Summary Information

Summary information is printed on the last page of the Audit Trail Report. See Audit Trail Report — Summary. It contains the following information:

  • Name of the audit trail dataset that was printed.
  • Number of data file records that were changed.
  • The number of members updated if the edit data set was a PDS.
  • Name of the updated data file that created the audit trail.
  • Names of the record layout dataset and member specified for the update and the record layout dataset type (SEQ for sequential, PDS for partitioned, PAN for CA Panvalet, LIB for CA Librarian).
  • Names of the record layout XREF dataset and member specified for the update (if an X was specified in the Record layout usage field).
  • Names of the selection criteria dataset and member, if existing selection criteria was used for the update. If temporary selection criteria was used during for the update, the literal ** TEMPORARY ** is printed.
  • Date and time the data file was closed.
  • The system ID on which the data file was updated.

Audit Trail Report — Summary

 22 JUL 2015  15:47:00                      File-AID/RDX 23.1 DISGUISE AUDIT TRAIL REPORT                           PAGE:          18
EXTRACT FILE : TSOID01.R42.EXTRACT                                               OPENED ON: 30 AUG 2004 AT 14:47:34  USER ID:  TSOID01
SOURCE OBJECT: TSOID01.R42.TESTDA.EMPMAST

                                                         SUMMARY INFORMATION

    AUDIT TRAIL FILE PRINTED:  TSOID01.RDXA.D010.D150722.T164243.M345

    TOTAL RECORDS CHANGED:             50
    TOTAL RECORDS UNCHANGED:            0
    TOTAL RECORDS DISCARDED:            0

RECORD LAYOUT: EMPLOYEE-MASTER-FILE
SOURCE OBJECT: TSOID01.R42.TESTDA.EMPMAST                                      
EXTRACT FILE : TSOID01.R42.EXTRACT                                             CLOSED ON: 22 JUL 2015AT 14:47:41    SYSTEM ID: CW01

 ************************************************* -> E N D   O F   R E P O R T <- **************************************************

Executing print audit trail independently in batch

You can execute the Print Audit Trail function as a separate step in a batch job by coding the JCL shown in the following figure. This process can be useful when you want to print multiple audit trail datasets in one batch print job.

Print Audit Trail JCL

//DISGAUDT EXEC PGM=UDASOLUT,REGION=8M
//STEPLIB   DD DISP=SHR,DSN=CPWR.MXVJ170.CXVJLOAD
//          DD DISP=SHR,DSN=CPWR.MXVJ170.SXVJLOAD
//SYSPRINT DD  SYSOUT=*
//SYSLIST  DD  SYSOUT=*
//DD01     DD  DISP=(OLD,KEEP,KEEP),
//             DSN=’TSOID01.prefix.RDXA.D010.D150722.T164243.M345’
//SYSIN    DD  *
$$DD01 APRINT
/*

Audit Trail Print Execution Return Codes

The audit trail print execution return codes are summarized in the following table.

 Print Execution Return Codes

RC

Explanation

Error Description

0

Job ran to completion.

None.

8

Job may have ended prematurely.

Data set related error.

12

Job may have ended prematurely.

I/O related error.

16

Severe error occurred.

System error.

 

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