Sample code to export execution data in CSV format

To collect the System Management Facility (SMF) type 120 subtype 100 records and export them in a comma-separated value (CSV) format, you must edit and submit ++HBRWORKDS++.SHBRJCL(HBRSMFC).

Before you submit ++HBRWORKDS++.SHBRJCL(HBRSMFC), ensure that the values for ++PSMFDS++ and ++SSMFDS++ are updated to reflect the SMF primary and secondary datasets for your system. Your values can be obtained by issuing /D SMF in SDSF. Also, ensure that the DD statement SMFOUT points to a valid writeable z/OS® UNIX System Services location for the output CSV file.

When the execution completes, a CSV file is generated with details of the SMF type 120 subtype 100 records, as in the following example output:

SMF120RTY SMF120STY

120 100

SMF120SID SMF120VER SMF120XUL SMF120XUT SMF120SDT SMF120STM SMF120EDT SMF120ETM RULEXNUM RULEXBAD RULEXFSUM RULEXCALLS RULEXTIME RULEXTMAX RULEXTMIN RULEXCPU RULEXCMAX RULEXCMIN RULEXETYP RULEXEVER RULEXFBOM RULEXFDEB RULEXFMON RULEXFTRC RULEXSIZE RULEXPNUM RULEXPATH

MVGB 8.9.0.0 OD04 zRule Execution Server 1/12/17 8:08:19 AM 1/12/17 8:20:00 AM 18 0 15 18 1654137 1603665 831 725520 683663 814 de 1.40.1 T F F F 7 2 /MiniLoanDemoRuleApp/1.0/MiniLoanDemo/1.0

MVGB 8.9.0.0 OD04 zRule Execution Server 1/12/17 8:20:00 AM 1/12/17 9:40:00 AM 90007 0 75005 90007 8604168 10963 31 8474369 8737 31 de 1.40.1 T F F F 7 2 /MiniLoanDemoRuleApp/1.0/MiniLoanDemo/1.0

MVGB 8.9.0.0 OD04 zRule Execution Server 1/12/17 9:40:00 AM 1/12/17 10:10:00 AM 3000 0 2500 3000 264851 937 32 262817 799 32 de 1.40.1 T F F F 7 2 /MiniLoanDemoRuleApp/1.0/MiniLoanDemo/1.0