Using the Logger › Size the Log Streams › How to Produce a Report

How to Produce a Report

After you acquire the statistics from the contents of a log stream, you can produce a report.

Use the following utilities to produce a report:

• The IBM report utility IXGRPT1

  IXGRPT1 provides information concerning how much data is being moved to the offload data sets within an SMF interval. This utility creates a report using SMF 88 records.

• The IEBGENER utility

  IEBGENER dumps the contents of a log stream to a sequential data set. No data is actually copied because the output is going to DUMMY. The exit program produces information about the log stream being read.

The following is a sample IEBGENER job:

//jobcard
//*
//GENER1   EXEC PGM=IEBGENER
//*
//SYSUT1   DD DISP=SHR,DSN=log.stream.name,
//         SUBSYS=(LOGR,GSVXLGEX),
//         DCB=BLKSIZE=32760
//*
//SYSPRINT DD SYSOUT=*
//SYSUT2   DD DUMMY
//SYSIN    DD DUMMY
/*

Sample output from the IEBGENER job:

(01) SYSUT1   Open     Log Stream TEST.SMFDATA.LOG
(02) SYSUT1   Options  GSVXLGEX
     SYSUT1   Options  FROM=OLDEST,TO=YOUNGEST,LOCAL
     SYSUT1   Options  FORWARD
(03) SYSUT1   Oldest   record read     yyyy/07/27 07:14:00.784201 Local
     SYSUT1   Youngest record read     yyyy/07/28 08:12:45.089467 Local
(04) SYSUT1   Oldest   block ID read   00000007254DFCBA
     SYSUT1   Youngest block ID read   0000000736E1FA43
     DDname   Record Type                   Count
     -------- ------------------------ ----------
(05) SYSUT1   CICS System Data                344
     SYSUT1   CICS Threshold                    3
     SYSUT1   CICS Transaction Detail         114
     SYSUT1   CICS Transaction Summary        114
     SYSUT1   IMS Transaction               62693
     SYSUT1   Plot Metric                    3508
     SYSUT1   WebSphere MQ                   1610
     SYSUT1   Other                        160985
     -------- ------------------------ ----------
(06) SYSUT1   Records returned             229371
     SYSUT1   Log records expanded         170604
     SYSUT1   SMF records expanded          57303
     SYSUT1   Average compression             46%
     SYSUT1   Max input record length       23674
     SYSUT1   Max output record length      32738
     SYSUT1   Avg input record length        1246
     SYSUT1   Avg output record length       2725
     SYSUT1   Avg expanded length            2725
     SYSUT1   Avg non-expanded length          94
     SYSUT1   CPU time used in exit        12.841

• (01) - <ddname> Open Log Stream <logstream>

  Indicates the specified log stream was opened.

• (02) - <ddname> Options <options>

  Defines the list of options used on the SUBSYS= parameter.

• (03) - <ddname> <message> <date> <time> <GMT|Local>

  Displays the date and time of the oldest and youngest records read.

• (04) - <ddname> Oldest block ID read 00000007254DFCBA

  Displays the block ID of the oldest and youngest records read.

• (05) - <ddname> <record type> <count>

  Displays the number of records read of a specific SMF type. SMF records created by CA SYSVIEW get listed specifically. All others get listed as "Other".

• (06) - <ddname> <statistics type> <value>

  Statistics Type:

  • Records returned - Total number of records returned to the caller.
  • Log records expanded - Number of records that were compressed and needed expanded.
  • SMF records expanded - The SMF records written by CA SYSVIEW can be compressed to save space in the SMF data sets or log. The number of records that were compressed.
  • Average compression - The average compress rate of compressed records.
  • Max input record length - The maximum input length of the records read.
  • Max output record length - The maximum output length of the records written. This value is the length after any expansion has been done.
  • Avg input record length - The average input length of the records read.
  • Avg output record length - The average output length of the records written. This value is the length after any expansion has been done.
  • Avg expanded length - The maximum output length of the records written that required expansion.
  • Avg non-expanded length - The maximum output length of the records written that did not require expansion.
  • CPU time used in exit - The amount of CPU used by the exit program.