Data Structure of Exported Reports
Strobe defines a data structure for the measurement session history reports that are exported using the Strobe - History - Print/Export panel. The reports are exported as comma separated value (CSV) files, and can be imported into a spreadsheet application.
This appendix describes the data structure of the exported measurement session history file for the summary, detail, measurement comparison, and cost comparison views.
Summary Report Data Structure
The data structure for any summary report consists of one type of record. The following table presents the order of fields in the summary record by type of view.
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
JOBNAME | TRAN NAME | DBRM NAME |
STEPNAME | HISTORY RECS | HISTORY RECS |
PROGRAM | LAST MEASUREMENT DATE | LAST MEASUREMENT DATE |
HISTORY RECS | LAST MEASUREMENT TIME | LAST MEASUREMENT TIME |
LAST MEASUREMENT DATE | LAST TRAN COUNT | LAST STMT EXEC COUNT |
LAST MEASUREMENT TIME | LAST TOTAL CPU PCT | LAST TOTAL CPU PCT |
LAST SERVICE UNITS | LAST AVG CPU SEC PER TRAN | LAST AVG CPU SEC PER STMT |
LAST SESSION MINS | LAST AVG SERV UNITS PER TRAN | LAST AVG SERV UNITS PER STMT |
SESSION SECS | ||
CPU MIN | ||
CPU SECS | ||
EXCPS |
Detail Report Data Structure
The data structure for any detail report consists of two types of records: one header record, and one or more detail records.
The order of fields in the header record is as follows:
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
JOBNAME | TRAN NAME | DBRM NAME |
STEPNAME | FREQUENCY | FREQUENCY |
PROGRAM | ||
FREQUENCY |
The order of the fields in the detail record is as follows:
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
MEASUREMENT DATE | MEASUREMENT DATE | MEASUREMENT DATE |
MEASUREMENT TIME | MEASUREMENT TIME | MEASUREMENT TIME |
COST CATEGORY | JOBNAME | JOBNAME |
SESSION MINS | STEPNAME | STEPNAME |
SESSION SECS | PROGRAM | PROGRAM |
CPU MIN | TRAN COUNT | STMT EXEC COUNT |
CPU SECS | TOTAL CPU PCT | TOTAL CPU PCT |
WAIT MIN | AVG SERV TIME | STMT EXEC AVG TIME |
WAIT SECS | AVG CPU SEC PER TRAN | AVG CPU SEC PER STMT |
STRETCH MIN | AVG SERV UNITS PER TRAN | AVG SERV UNITS PER STMT |
STRETCH SECS | COST CATEGORY | DBRM CREATE DATE |
EXCP COUNT | SYSTEM ID | COST CATEGORY |
SERVICE UNITS | CPU MODEL | SYSTEM ID |
SYSTEM ID | COMMENT | CPU MODEL |
CPU MODEL | HISTORIAN | COMMENT |
COMMENT | HISTORIAN | |
HISTORIAN |
Measurement Comparison Data Structure
The data structure for any comparison report consists of three types of records: a header record, one baseline record, and one or more comparison records.
The order of fields in the header record is as follows:
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
JOBNAME | TRAN NAME | DBRM NAME |
STEPNAME | FREQUENCY | FREQUENCY |
PROGRAM | ||
FREQUENCY |
The header record is followed by at least one baseline record, and one or more comparison records. These records have the following fields:
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
MEASUREMENT DATE | MEASUREMENT DATE | MEASUREMENT DATE |
MEASUREMENT TIME | MEASUREMENT TIME | MEASUREMENT TIME |
COST CATEGORY | JOBNAME | JOBNAME |
SESSION MINS | STEPNAME | STEPNAME |
SESSION SECS | PROGRAM | PROGRAM |
CPU MIN | TRAN COUNT | STMT EXEC COUNT |
CPU SECS | TOTAL CPU PCT | TOTAL CPU PCT |
WAIT MIN | AVG SERV TIME | STMT EXEC AVG TIME |
WAIT SECS | AVG CPU SEC PER TRAN | AVG CPU SEC PER STMT |
STRETCH MIN | AVG SERV UNITS PER TRAN | AVG SERV UNITS PER STMT |
STRETCH SECS | SYSTEM ID | DBRM CREATE DATE |
EXCP COUNT | CPU MODEL | SYSTEM ID |
SERVICE UNITS | COMMENT | CPU MODEL |
SYSTEM ID | HISTORIAN | COMMENT |
CPU MODEL | HISTORIAN | |
COMMENT | ||
HISTORIAN |
Cost Comparison Data Structure
The data structure for any comparison report consists of three types of records: a header record, one baseline record, and one or more comparison records.
The order of fields in the header record is as follows:
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
JOBNAME | TRAN NAME | DBRM NAME |
STEPNAME | FREQUENCY | FREQUENCY |
PROGRAM | ||
FREQUENCY |
The header record is followed by at least one baseline record, and one or more comparison records. These records have the following fields:
Job/Step/Program View | Transaction View | DBRM View |
|---|---|---|
MEASUREMENT DATE | MEASUREMENT DATE | MEASUREMENT DATE |
MEASUREMENT TIME | MEASUREMENT TIME | MEASUREMENT TIME |
COST CATEGORY | JOBNAME | JOBNAME |
CPU MIN | STEPNAME | STEPNAME |
CPU SECS | PROGRAM | PROGRAM |
EXCP COUNT | COST CATEGORY | COST CATEGORY |
SERVICE UNITS | AVG CPU SEC PER TRAN | AVG CPU SEC PER STMT |
COST PER RUN | AVG SERV UNITS PER TRAN | AVG SERV UNITS PER STMT |
COST PER YEAR | COST PER TRAN | COST PER STMT |
COMMENT | COST PER YEAR | COST PER YEAR |
HISTORIAN | COMMENT | DBRM CREATE DATE |
HISTORIAN | COMMENT | |
HISTORIAN |