Samples
The parts for Statistics File and Save-File data are as follows.
Examples of CREATE TABLE, LOAD statements, SQL queries, and descriptions of the statistics tables are in library RKO2SAMP. The description files are in a format that can be loaded into Db2 tables.
The CREATE TABLE examples can be used for building the Db2 tables into which the Statistics File data sets and the converted Statistics Save records can be loaded. The Db2 load utility control statements can be used for loading these Statistics File data sets and converted Statistics Save records into Db2 tables.
| Type of data | CREATE TABLE statements | LOAD control statements | Sample query | Table description |
|---|---|---|---|---|
| General Data | DGOSCGEN | DGOSLGEN | DGOSQGEN | DGOSBGEN |
| Buffer Pool | DGOSCBUF | DGOSLBUF | DGOSQBUF | DGOSBBUF |
| DDF | DGOSCDDF | DGOSLDDF | DGOSQDDF | DGOSBDDF |
| Group Buffer Pool | DGOSCGBP | DGOSLGBP | DGOSBGBP | |
| Buffer Pool Data Set | DGOSCSET | DGOSLSET | DGOSBSET | |
| Accelerator | DGOSCXCL | DGOSLXCL | DGOSBXCL | |
| Aggregated Accounting | DGOSCACC | DGOSLACC | DGOSBACC | |
| Storage Data | DGOSCSTG | DGOSLSTG | DGOSBSTG | |
| Simulated BP Data | DGOSCSIM | DGOSLSIM | DGOSBSIM | |
| Location statistics details | DGOSCLOC | DGOSLLOC | DGOSQLOC | DGOSBLOC |
| Remote Application Statistics | DGOSCRAP | DGOSLRAP | DGOSBRAP | |
| Remote User Statistics | DGOSCRUS | DGOSLRUS | DGOSBRUS | |
| Profile Monitoring | DGOSCPRO | DGOSLPRO | DGOSQPRO | DGOSBPRO |
The sample query in DGOSQDDF uses the view defined in DGOSVDDF.
The samples provided are valid for Statistics File and Save-File data.
Save data sets must be converted to the Save-File layout before they can be loaded into tables.