Samples
The parts for Audit file data are as follows.
Examples of CREATE TABLE and LOAD statements 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 Audit File data sets can be loaded. The DB2 load utility control statements can be used for loading these Audit File output records into DB2 tables.
| Type of data | CREATE TABLE statements | LOAD control statements | Table description |
|---|---|---|---|
| Bind | DGOXCBND | DGOXLBND | DGOXBBND |
| Bind Repeating Data | DGOXCBRD | DGOXLBRD | DGOXBBRD |
| Auth Change | DGOXCCHG | DGOXLCHG | DGOXBCHG |
| Auth Control | DGOXCCNT | DGOXLCNT | DGOXBCNT |
| DDL | DGOXCDDL | DGOXLDDL | DGOXBDDL |
| DML | DGOXCDML | DGOXLDML | DGOXBDML |
| Auth Fail | DGOXCFAI | DGOXLFAI | DGOXBFAI |
| SQL | DGOXCSQL | DGOXLSQL | DGOXBSQL |
| Utility | DGOXCUTI | DGOXLUTI | DGOXBUTI |