Converting Data Sets

To store performance data in Performance Database tables or spreadsheets, you must first convert Accounting Save data sets of OMEGAMON® 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 for Db2 PE.

You can use the CONVERT function of the Accounting Save-File Utility to convert Accounting Save data sets of OMEGAMON 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.

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.