Previous Topic: Roscoe User Charge Summary Report

Next Topic: Reporting Considerations


EXTDATA Reports

There are sample CA Earl and CA Easytrieve reports that will process the Roscoe Interface EXTDATA records.

Note: The EXTDATA record layout is described in the chapter "EXTDATA Reporting" in the User Guide.

OPTION LIST OFF
NOTE ******************************************************************
NOTE *  REPORT ID:      ERXTR001                                      *
NOTE *  REPORT NAME:    ROSCOE SESSION ANALYSIS                       *
NOTE *                                                                *
NOTE *  DESCRIPTION:    THIS SUMMARY REPORT WILL COLLATE ROSCOE       *
NOTE *                  SESSION PROCESSING BY USER KEY.  PLEASE NOTE  *
NOTE *                  THAT THE ROSCOE JOB NAME WILL NOT BE AVAILABLE*
NOTE *                  UNLESS THE INPUT SOURCE DATA TO THE EXTDATA   *
NOTE *                  GENERATOR (THE ROSCOE INTERFACE) WAS ROSCOE   *
NOTE *                  SMF DATA.                                     *
NOTE *                                                                *
NOTE *                  FOR EACH SESSION, THE ELAPSED TIME, CPU TIME, *
NOTE *                  TOTAL I/O COUNT, AND JOBS SUBMITTED COUNT WILL*
NOTE *                  BE DISPLAYED.                                 *
NOTE *  RECORD TYPES:   MRXTHDR,                                      *
NOTE *                  MRXTSIER                                      *
NOTE *  EXTDATA RECORD: SIER                                          *
NOTE *  MACROS:                                                       *
NOTE ******************************************************************
OPTION PRINTER = 132
OPTION PAGE = 60
OPTION PRECISION = ALL
OPTION CPAGE = 60
HISTIN:  FILE JARS RECORD=3697
  DEF INAREA                   1-3697  X
  COPY MRXTHDR
  COPY MRXTSIER
NOTE ******************************************************************
NOTE * SELECTING FROM HISTORY FILE EXTDATA, SPECIFICALLY SIER         *
NOTE ******************************************************************
!
IF     PROCID NOT = ':' OR
       EXTTYPE NOT = 'SIER'
       THEN GOTO START
ENDIF
!
NOTE ******************************************************************
NOTE *                REPORT PROCESSING SECTION                       *
NOTE ******************************************************************
!
REPORT 'ROSCOE SESSION ANALYSIS'
TITLE ' '
TITLE @1 'REPORT ID: ERXTR001'    @54 'SYSTEM ID:'  SID
TITLE @1 'SOURCE   : ROSCOE'      @54 '   ROSCOE:'  EXTSIER_ROS_JOBNAME
TITLE                             @54 ' USER KEY:'  EXTSIER_KEY_FULL
TITLE                             @54 '  ACCOUNT:'  EXTSIER_ACCOUNT
TITLE ' '
!
CONTROL    (EXTSIER_ROS_JOBNAME)  (EXTSIER_KEY_FULL)
           (EXTSIER_ACCOUNT) SKIP EXTSIER_SON_DATE
           EXTSIER_SON_TIME
!
PRINT
      @1 ' '
         EXTSIER_SON_DATE
         EXTSIER_SON_TIME
         EXTSIER_ELAP_TIME
         EXTSIER_TOT_IOS
         EXTSIER_CPU_TIME
         EXTSIER_JOBS_SUB
END
LIST OFF
******************************************************************
*  REPORT ID:      EZXTR001                                      *
*  REPORT NAME:    ROSCOE SESSION ACTIVITY SUMMARY               *
*  DESCRIPTION:    THIS SUMMARY REPORT WILL COLLATE ROSCOE       *
*                  SESSION PROCESSING BY USER KEY.  PLEASE NOTE  *
*                  THAT THE ROSCOE JOB NAME WILL NOT BE AVAILABLE*
*                  UNLESS THE INPUT SOURCE DATA TO THE EXTDATA   *
*                  GENERATOR (THE ROSCOE INTERFACE) WAS ROSCOE   *
*                  SMF DATA.                                     *
*                                                                *
*                  FOR EACH SESSION, THE ELAPSED TIME, CPU TIME, *
*                  TOTAL I/O COUNT, AND JOBS SUBMITTED COUNT WILL*
*                  BE DISPLAYED.                                 *
*                                                                *
*  RECORD TYPES:   MZXTHDR,                                      *
*                  MZXTSIER                                      *
*                                                                *
*  EXTDATA RECORD: SIER                                          *
*                                                                *
******************************************************************
PARM ABEXIT (SNAP) DEBUG (FLDCHK STATE)
FILE EXTDATA
%MZXTHDR
%MZXTSIER
*
JOB INPUT EXTDATA
IF     PROCID  = ':' AND EXTTYPE = 'SIER'
       GOTO PROCESS_DATA
       ELSE
       GOTO JOB
END-IF
PROCESS_DATA
*
PRINT REPORT1
*
REPORT REPORT1 SPACE 0 PAGESIZE (60 60) LINESIZE 132 NOADJUST
*
SEQUENCE EXTSIER_ROS_JOBNAME EXTSIER_KEY_FULL EXTSIER_ACCOUNT         +
         EXTSIER_SON_DATE EXTSIER_SON_TIME
*
CONTROL  EXTSIER_ROS_JOBNAME EXTSIER_KEY_FULL EXTSIER_ACCOUNT NEWPAGE
*
TITLE 01 COL 48 'ROSCOE SESSION ACTIVITY SUMMARY'
TITLE 02 ' '
TITLE 03 COL 1 'REPORT ID: EZXTR001'    COL 54 'SYSTEM ID      ' SID
TITLE 04 COL 1 'SOURCE   : ROSCOE'      COL 54 'ROSCOE         '      +
                                        EXTSIER_ROS_JOBNAME
TITLE 05                                COL 54 'USER KEY       '      +
                                        EXTSIER_KEY_FULL
TITLE 06                                COL 54 'ACCOUNT        '      +
                                        EXTSIER_ACCOUNT
LINE   EXTSIER_SON_DATE    '   ' +
       EXTSIER_SON_TIME    '   ' +
       EXTSIER_ELAP_TIME   '   ' +
       EXTSIER_TOT_IOS     '   ' +
       EXTSIER_CPU_TIME    '   ' +
       EXTSIER_JOBS_SUB

The sample output will look like this:

121/01/04                                              ROSCOE SESSION ANALYSIS  REPORT ID: ERXTR001                                  SYSTEM ID:      XAE1  SOURCE   : ROSCOE                                       ROSCOE:      ROSCOE60                                                        USER KEY:      CHIWA01                                                         ACCOUNT:      ________________  -------------------------------------------------------------------------------------------------------------------------------          SIGN ON       SIGN ON           ELAPSED              TOTAL         CPU TIME           JOBS             DATE          TIME         TIME (HR)                IOS       (TM UNITS)      SUBMITTED  -------------------------------------------------------------------------------------------------------------------------------         02/11/18      12:07:53           2.07662               5768               22              0         02/11/18      15:43:43           4.11261                428                3              1 121/01/04                                              ROSCOE SESSION ANALYSIS  REPORT ID: ERXTR001                                  SYSTEM ID:      XAE1  SOURCE   : ROSCOE                                       ROSCOE:      ROSCOE60                                                        USER KEY:      COLDE05                                                         ACCOUNT:      ________________  -------------------------------------------------------------------------------------------------------------------------------          SIGN ON       SIGN ON           ELAPSED              TOTAL         CPU TIME           JOBS             DATE          TIME         TIME (HR)                IOS       (TM UNITS)      SUBMITTED  -------------------------------------------------------------------------------------------------------------------------------         02/11/18      13:30:33           0.02614                309                4              7         02/11/18      13:32:11           3.53465               2938              250              5