Accounting File
Accounting data can contain all or a subset of available data types, depending on the specification of the DATATYPE subcommand option of the ACCOUNTING FILE command.
The specified data types can be stored in one or several data sets in any combination by means of multiple invocations of FILE DATATYPE in a JCL. To load all Accounting data from several output data sets into a DB2 table, you can run the following DB2 load control statements concurrently. For more information, see the Report Command Reference.
| Type of data | CREATE TABLE statements | LOAD control statements | Table description |
|---|---|---|---|
| General | DGOACFGE | DGOALFGE | DGOABFGE |
| Group Buffer Pool | DGOACFGP | DGOALFGP | DGOABFGP |
| Buffer Pool | DGOACFBU | DGOALFBU | DGOABFBU |
| DDF Records | DGOACFDF | DGOALFDF | DGOABFDF |
| Package Records | DGOACFPK | DGOALFPK | DGOABFPK |
| Accelerator | DGOACFXC | DGOALFXC | DGOABFXC |
Examples of SQL queries are in member DGOAQFIL.