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