The Statistics File Data Set and Output Records
Use the FILE subcommand to format Db2® Statistics records and write them to sequential data sets suitable for use by the Db2 load utility. You can store unreduced Statistics data into the performance database. Use the performance database to produce tailored reports using a reporting facility such as Query Management Facility (QMF).
The format of the output data from the Statistics File data set is identical with that of the CONVERT function of the Save-File utility.
You can also use the File data sets to generate CSV (comma-separated value) input-data. This CSV data can then be transferred to workstations and imported into spreadsheets to improve Db2 performance analysis using graphical representations or pivot tables. For more information refer to Reporting User's Guide.
The Statistics File data set is produced when OMEGAMON for Db2
PE Statistics
delta records are externalized using the FILE subcommand. Each such
delta record represents the period of time between two pairs of Db2 Statistics
delta records and can be represented in the File data set by up to
8 types of records. File data is written to a File data set. The following
types of records are created. Descriptions of the layouts of these
records can be found in the RKO2SAMP library under the following names:
| Record type | Description | Layout description in the RKO2SAMP library |
|---|---|---|
| General Statistics | Records contain data from IFCID 001 and 002. One general Statistics record is produced for each Statistics delta record. | DGOSDGEN |
| Buffer Pool Statistics | Records contain data derived from IFCID 002 records. One buffer pool record is produced for each buffer pool active at the start time of the corresponding delta record. Each OMEGAMON for Db2 PE Statistics delta record can produce up to 80 buffer pool Statistics records. | DGOSDBUF |
| DDF Statistics | Records contain DDF Statistics originating from IFCID 001. A DDF record is produced for all remote locations that used DRDA (where at least one location used this method at the start time of the delta record). | DGOSDDDF |
| Group Buffer Pool Statistics | Records contain data derived from IFCID 002 records. One group buffer pool record is produced for each group buffer pool active at the start time of the corresponding delta record. Each OMEGAMON for Db2 PE Statistics delta record can produce up to 80 group buffer pool Statistics records. | DGOSDGBP |
| Buffer Pool Data Set | Records contain data derived from IFCID 199. One row is written for each open data set that has an I/O event rate at least one event per second during the reporting interval. | DGOSDSET |
| Accelerator | Records contain data derived from IFCID 002. One row is written for each active accelerator attached to the DB2 subsystem that is currently reported. | DGOSDXCL |
| Aggregated Accounting | Records contain data derived from IFCID 369. One row is written for a connection type IMS, CICS, RRSAF, Utility, Batch, or DDF containing aggregated wait and CPU times of threads with IFCID 3 events for this connection type. | DGOSDACC |
| Storage Data | Records contain data derived from IFCID 225. One row is written for DB2 storage metrics valid for the reporting interval. | DGOSDSTG |
| Simulated Buffer Pool | Records contain data derived from IFCID 002 records (QBST section). One buffer pool record is produced for each simulated buffer pool. | DGOSDSIM |
| Location statistics details | Records contain data derived from IFCID 365 records (QLST section). One row is written for each remote location being reported on. | DGOSDLOC |
| Remote Application Statistics | Records contain data derived from IFCID 411 (QLAP section). One row is written for each remote application connected to Db2 subsystem. | DGOSDRAP |
| Remote User Statistics | Records contain data derived from IFCID 412 (QLAU section). One row is written for each remote userid connected to Db2 subsystem. | DGOSDRUS |
| Profile Monitoring Statistics | Records contain data derived from IFCID 402 record which is written at most once during a statistics interval, whose length is defined by subsystem parameter STATIME. For a specific profile, IFCID 402 tracks any profile warning or exception that occurred during a statistics interval. | DGOSDPRO |