Using the RACF SMF data unload utility output with DB2
The records produced by the RACF® SMF
data unload utility are designed to be processed by the DB2® load utility or its equivalent.
The definition and control statements for a DB2 utilization of the output, all of which are
contained in SYS1.SAMPLIB, are as follows:
- Sample data definition language (DDL) statements to define the relational presentation of the audit information and sample DB2 definitions which perform database and index creation. These are in member IRRADUTB.
- Sample control statements for the DB2 load utility that map the output from the RACF SMF data unload utility. These are in member IRRADULD.
- Sample structured query language (SQL) queries that demonstrate useful inquiries that can be made. These are in member IRRADUQR.
For complete information about DB2,
see:
- DB2 for MVS/ESA Administration Guide
- DB2 for MVS/ESA SQL Reference
- DB2 for MVS/ESA What's New