Converting Data Sets

To store performance data in Performance Database tables or spreadsheets, you must first convert Statistics 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 Statistics Save-File Utility to convert Statistics Save data sets of OMEGAMON for Db2 PE V5.4.0 into sequential data sets. The RKO2SAMP library provides the sample job DGOPJSCO, which you can modify to suit your installation.

You can also use the STATISTICS 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 STATISTICS 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 (DGOSDGEN)
  • Buffer Pool data records (DGOSDBUF)
  • DDF data records (DGOSDDDF)
  • Group Buffer Pool records (DGOSDGBP)
  • Buffer Pool data set records (DGOSDSET)
  • Accelerator data records (DGOSDXCL)
  • Aggregated Accounting data records (DGOSDACC)
  • Storage data records (DGOSDSTG)
For more information of the Spreadsheet Input-Data Generator refer to Reporting User's Guide.