Steps for Using RACF SMF Data Unload Utility Output with SQL/DS

To create and manage the SQL/DS database containing output from the RACF SMF data unload utility, you must:

1. Create one or more SQL/DS DBSPACEs.
2. Create SQL/DS tables.
3. Create the SQL/DS indexes.
4. Load data into the tables.
5. Reorganize the indexes (optional).
6. Delete table data (optional).

The first three steps are initial setup, and you can choose to run them once. When you get new data to import into the SQL/DS database, you erase your current table data. You then reload and reorganize your indexes.

The following sections show examples of the SQL/DS utility input for these functions.