|
|
|
You can create CSV files from the CA Earl Report Writer in a format compatible with CA NSM APIs that can create performance cubes from CSV files. See the Network and Systems Management (NSM) Database Performance Monitor Option guide, Using the Performance Agent, for more detailed information.
Creating a CSV file from the CA Earl Report Writer is accomplished by specifying members ERXT0262 through ERXT0269 on the SYSIN DD statement and adding CAIJSCSV and CAIJSIDX DD statements to the CA Earl execution JCL. Input to this process is your RMF data. The PDS used to store CSV files must be separate from the one used to store other CSV files created by CA JARS, as the record formats are different.
The CA Earl print exit program builds and maintains the index data set that keeps track of the location of CSV files. Again, this data set may not be the same as the one used by the CA JARS Report Writer, due to an incompatible record format.
On the next page is an example CA Earl program that creates a CSV file as output. Statements that can be modified by the user are documented following the program example. The example shows only part of the program. A complete listing of the program can be found in the CAJREARL library in member ERXT0269.
--------------------------------------------------------------------------------
NOTE ****************************************************************** 00010000
NOTE * REPORT ID: ERXT0269 * 00020008
NOTE * REPORT NAME: XCF SYSTEM ACTIVITY CSV * 00030008
NOTE * DESCRIPTION: CSV OF CROSS SYSTEM COUPLING FACILITY * 00040008
NOTE * ACTIVITY. * 00050008
NOTE * RECORD TYPES: MRXTHDR, * 00060000
NOTE * MRXT74S ( TYPE 74-2) * 00070008
NOTE ****************************************************************** 00100000
!OPTION LIST OFF 00110000
OPTION PRINTER = 216 00120000
OPTION PRTEXIT = JSICSVT 00130000
OPTION PAGE = 99999 00140000
OPTION PRECISION = ALL 00150000
OPTION CPAGE = 60 00160000
OPTION EXCLUDE 00170000
OPTION OMIT ALL BLANK LINES 00180000
OPTION WORKFILES 00190000
.
.
.
SET MEM = 'CSVM' !MEM CAN ONLY BE 4 CHARACTERS LONG 00990000
! PRINT EXIT WILL START WITH 01CC SUFFIX 01000000
! AND INCREMENT FOR EACH DATE CHANGE 01010000
! MEM WILL BE TRUNCATED TO 4 BY PRTEXIT 01020000
! 01030000
SET SELVAR001 = '4SD ' !DURATION WITHIN INTERVAL (XCF - 74S) 01040004
SET SELVAR002 = 'MSR ' !MSGS PER SECOND REJECTED (XCF - 74S) 01050004
SET SELVAR003 = 'MST ' !MSGS PER SECOND TOTAL (XCF - 74S) 01060004
SET SELVAR004 = 'XMB ' !BIG MSGS EXCEEDING OPTIMUM LENGTH (XCF - 74S) 01070004
SET SELVAR005 = 'XMF ' !MSGS FITTING DEFINED BUFFER (XCF - 74S) 01080004
SET SELVAR006 = 'XML ' !MSGS LARGER THAN DEFINED BUFFER (XCF - 74S) 01090004
SET SELVAR007 = 'XMR ' !MSGS REJECTED (XCF - 74S) 01100004
SET SELVAR008 = 'XMS ' !MSGS SMALLER THAN DEFINED BUFFER (XCF - 74S) 01110004
SET SELVAR009 = 'XMT ' !MSGS - TOTAL (XCF - 74S) 01120004
SET SELVAR010 = 'XMX ' !ACCUM MAX MSG BUFR SPACE (1K BLKS) (XCF - 74S) 01130004
SET SELVAR011 = 'XNP ' !MSGS MIGRATED NO PATH (XCF - 74S) 01140004
SET SELVAR012 = 'XPS ' !PATHS IN SERVICE (XCF - 74S) 01150004
SET SELVAR013 = 'XTC ' !ACCUM TRANSPORT CLASS MSG LENGTH (XCF - 74S) 01160004
.
.
.
PRINT TOTALS ONLY 03280000
' M=' 0 PMEM 0 ' S=' 0 PSID 0 ' R=' 0 PRESOURCE 0 03290000
' RS=' 0 PRESOURCESUB 0 ' I=' 0 PINSTANCE 0 ' D=' 0 PDATE 0 03300000
' H=' 0 PHOUR 0 ' V=' 0 PVALUE 03310000
! 03320004
END 03330000
Please pay particular attention to these, as there are requirements documented in some of them which may not be intuitive.
No modification to OPTION statements is required. You may change LIST OFF to LIST ON to view the CA Earl program in your output.
This is the prefix of your CSV PDS members. Set this prefix to any valid four character combination. With the default prefix, members will be named CSVM01CC, CSVM02CC, and so on. The CC suffix is hard-coded and may not be changed.
These are the user-selectable metrics for inclusion in the CSV output file. To include this metric in your output, ensure the line is not commented out. If you do not desire a particular metric, insert an exclamation point (!) in position 1 of that line.
The PRINT statement must not be modified by the user. These programs are coded to construct the CSV file in a particular format for NSM Database Performance Management option.
There are no other statements that can be modified.
| Copyright © 2012 CA. All rights reserved. |
|