Converting Data Sets

Start of change To store performance data in Performance Database tables or spreadsheets, you must first convert Accounting Save data sets of OMEGAMON® XE for DB2® PE V5.4.0 into sequential data sets that can be used by the DB2 load utility or the Spreadsheet Input-Data Generator of OMEGAMON XE for DB2 PE. End of change

Start of change You can use the CONVERT function of the Accounting Save-File Utility to convert Accounting Save data sets of OMEGAMON XE for DB2 PE V5.4.0 into sequential data sets. The RKO2SAMP library provides the sample job DGOPJACO, which you can modify to suit your installation. End of change

You can also use the ACCOUNTING SAVE subcommand with the CONVERT option to convert and save reduced data into a sequential data set. The output of this subcommand option is a sequential data set, that is specified and requested in SYSIN. The data set attributes are:

Organization: PS
Record format: VB
Record length: 9072
Block size: 9076

For more information about the ACCOUNTING SAVE subcommand refer to Report Command Reference.

The following list shows the types of records that are created by the CONVERT function (or CONVERT command option) and where to find their layout descriptions in the sample library RKO2SAMP:

General data records (DGOADSGE)
Buffer pool data records (DGOADSBU)
Distributed Data Facility (DDF) data records (DGOADSDF)
Group buffer pool records (DGOADSGP)
Package records (DGOADSPK)
Resource Limit Facility (RLF) records (DGOADSRF)
Accelerator records (DGOADSXC)

For more information about the Spreadsheet Input-Data Generator refer to Reporting User's Guide.

Feedback