Converting Data Sets

Edit online

To store performance data in Performance Database tables or spreadsheets, you must first convert Statistics Save data sets of OMEGAMON AI for Db2 V6.1.0 into sequential data sets that can be used by the Db2® load utility or the Spreadsheet Input-Data Generator of OMEGAMON AI for Db2.

You can use the CONVERT function of the Statistics Save-File Utility to convert Statistics Save data sets of OMEGAMON AI for Db2 V6.1.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, see the 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 about the Spreadsheet Input-Data Generator, see the Reporting User's Guide.