Examples

Note: The following two examples are reports for the same audit trail.

Example 1: An unformatted audit report where all the audit events in the audit log are reported (SHOWCOM=NO).

//FMBAT EXEC PGM=FILEMGR
//STEPLIB DD DSN=FMN.SFMNMOD1,DISP=SHR
//SYSPRINT DD SYSOUT=*
//IDIOPTS DD DSN=FMN.IDIOPTS,DISP=SHR
//SYSIN DD *
$$FILEM AUD ,
$$FILEM TYPE=IMS,
$$FILEM FORMAT=NO,
$$FILEM SHOWCOM=NO,
$$FILEM LABEL='EDIT THE SUBURB DATABASE',
$$FILEM DSNAME='FMNUSER.IMSAUDIT.D101104.T121752'
Figure 1. Unformatted audit report where all the audit events in the audit log are reported (Part 1 of 2)
1IBM File Manager for z/OS IMS Component      Audit Trail Report
                                              Audit Trail Number 1
 Subsystem: IF52
 Database:  DJ2E

 Audit Trail:
   Data set name:       FMNUSER.IMSAUDIT.D101104.T121752
   Description:         EDIT THE SUBURB DATABASE

0Audit trail number 1:
   Function:            Edit
   User ID:             FMNUSER
   MVS system ID:       FMD2
   IMS subsystem:       IF52
   Database:            DJ2E
   DBD library:         FMN.REGTEST.IMS.DBDLIB
   PSB type:            Dynamic
   Region type:         DLI
   Template:            FMN.REGTEST.IMS.TEMPLATE.PLI(DJ2E)

0Event number 1:        DL/I batch processing program started on 10/11/0

0Event number 2:        Checkpoint FM000001 taken on 10/11/04 at 12.17.5
                        Updates since audit event 1 have been committed.

0Event number 3:        Segment replaced on 10/11/04 at 12.18.59
   Segment name:        SUBURB Level: 1
   Concatenated key:    KORRELOCKING

0            Segment             1         2         3         4
 Status   Start Length  123456789012345678901234567890123456789012345678
 -----------------------------------------------------------------------

0BEFORE       1     62  KORRELOCKING      6485 K6420174WYALKATCHEM   010
                        DDDDCDDCDCDC444444FFFF4DFFFFFFFEECDDCECCCD444FFF
                        269953632957000000648502642017468132133854000010
 CHANGED                *******************---******

0AFTER                  KORRELOCKING      6399 K6420174WYALKATCHEM   010
                        DDDDCDDCDCDC444444FFFF4DFFFFFFFEECDDCECCCD444FFF
                        269953632957000000639902642017468132133854000010
 CHANGED                *******************---******
0Event number 4:        Segment deleted on 10/11/04 at 12.19.52
   Segment name:        LETRBOX Level: 2
   Concatenated key:    KORRELOCKING      6967

0            Segment             1         2         3         4
 Status   Start Length  123456789012345678901234567890123456789012345678
 -----------------------------------------------------------------------
Figure 2. Unformatted audit report where all the audit events in the audit log are reported (Part 2 of 2)



0BEFORE       1     34  6967WAY OUT IN THE BUSH
                        FFFFECE4DEE4CD4ECC4CEEC44444444444
                        6967618064309503850242800000000000
                        ****

0Event number 5:        Checkpoint FM000002 taken on 10/11/04 at 12.20.1
                        Updates since audit event 2 have been committed.


1IBM File Manager for z/OS IMS Component      Audit Trail Report
                                              Audit Trail Number 1
 Subsystem: IF52
 Database:  DJ2E

0Event number 6:        Segment inserted on 10/11/04 at 12.21.34
   Segment name:        LETRBOX Level: 2
   Concatenated key:    LEEDERVILLE       6903

0            Segment             1         2         3         4
 Status   Start Length  123456789012345678901234567890123456789012345678
 -----------------------------------------------------------------------

0AFTER        1     34  6903LEEDERVILLE PLB A
                        FFFFDCCCCDECDDC4DDC4C4444444444444
                        6903355459593350732010000000000000
                        ****

0Event number 7:        Rollback call issued on 10/11/04 at 12.21.42
                        Updates since audit event 5 have been backed out

0Event number 8:        DL/I batch processing program ended on 10/11/04

0Audit trail number 1 statistics:
   Segments replaced:   1
   Segments inserted:   1
   Segments deleted:    1
   Total DB changes:    3
   Checkpoints:         2
   Rollbacks:           1
   Records skipped:     0

0End of audit trail number 1



-Audit trail report summary:
   No. of audit trails: 1
   Print format:        UNFORMATTED
   Lines per page:      60
   Changed fields only: NO

Example 2: A formatted audit report where only committed updates are reported (SHOWCOM=YES).

//FMBAT EXEC PGM=FILEMGR
//STEPLIB DD DSN=FMN.SFMNMOD1,DISP=SHR
//SYSPRINT DD SYSOUT=*
//IDIOPTS DD DSN=FMN.IDIOPTS,DISP=SHR
//SYSIN DD *
$$FILEM AUD ,
$$FILEM TYPE=IMS,
$$FILEM FORMAT=YES,
$$FILEM HICHG=YES,
$$FILEM SHOWCOM=YES,
$$FILEM LABEL='EDIT THE SUBURB DATABASE',
$$FILEM DSNAME='FMNUSER.IMSAUDIT.D101104.T121752'
Figure 3. Formatted audit report where only committed updates are reported (Part 1 of 2)
1IBM File Manager for z/OS IMS Component      Audit Trail Report
                                              Audit Trail Number 1
 Subsystem: IF52
 Database:  DJ2E

 Audit Trail:
   Data set name:       FMNUSER.IMSAUDIT.D101104.T121752
   Description:         EDIT THE SUBURB DATABASE

0Audit trail number 1:
   Function:            Edit
   User ID:             FMNUSER
   MVS system ID:       FMD2
   IMS subsystem:       IF52
   Database:            DJ2E
   DBD library:         FMN.REGTEST.IMS.DBDLIB
   PSB type:            Dynamic
   Region type:         DLI
   Template:            FMN.REGTEST.IMS.TEMPLATE.PLI(DJ2E)

0Event number 1:        DL/I batch processing program started on 10/11/0

0Event number 2:        Segment replaced on 10/11/04 at 12.18.59
   Segment name:        SUBURB Level: 1
   Concatenated key:    KORRELOCKING

0            Segment             1         2         3         4
 Status   Start Length  123456789012345678901234567890123456789012345678
 -----------------------------------------------------------------------
 1 SUBURB                            AN    62
  2 SUBURB_NAME                      AN    18  KORRELOCKING
  2 POST_CODE                        ZD     4*  6485
  2 SUBURB_TYPE                      AN     1
  2 PUBLIC_PHONE                     AN     4  K642
  2 DISTANCE_2_PERTH                 ZD     4    174
  2 CLOSEST_CENTRE                   AN    14  WYALKATCHEM
  2 DISTANCE_2_CENTRE                ZD     3    10
  2 MAP_REFERENCE                    AN     9
   3 LATITUDE_DEGREE                 ZD     2   31
   3 LATITUDE_MINUTE                 ZD     2   12
   3 LONGITUDE_DEGREE                ZD     3   117
   3 LONGITUDE_MINUTE                ZD     2   28
  2 ACRONYM                          AN     5  KORRE
Figure 4. Formatted audit report where only committed updates are reported (Part 2 of 2)

0** End of Segment Structure - Length = 62

0Event number 3:        Segment deleted on 10/11/04 at 12.19.52
   Segment name:        LETRBOX Level: 2
   Concatenated key:    KORRELOCKING      6967

0            Segment             1         2         3         4
 Status   Start Length  123456789012345678901234567890123456789012345678
 -----------------------------------------------------------------------
 1 LETTER_BOX                        AN    34
  2 KEY                              AN    34
   3 POST_CODE                       AN     4  6967
   3 LOCATION                        AN    30  WAY OUT IN THE BUSH

0** End of Segment Structure - Length = 34


1IBM File Manager for z/OS IMS Component      Audit Trail Report
                                              Audit Trail Number 1
 Subsystem: IF52
 Database:  DJ2E

0Event number 4:        DL/I batch processing program ended on 10/11/04

0Audit trail number 1 statistics:
   Segments replaced:   1
   Segments inserted:   0
   Segments deleted:    1
   Total DB changes:    2
   Records skipped:     0

0End of audit trail number 1


-Audit trail report summary:
   No. of audit trails: 1
   Print format:        FORMATTED
   Lines per page:      60
   Changed fields only: NO