AutoCollect – Creating SNAPSHOT and System DELTA Rowsets › Snapshots of Selected DST Tables

Snapshots of Selected DST Tables

The AUTOCOLL OPTION=SNAPSHOT function pulls information from selected Dynamic System Tables (DST) and stores it in the SNAPSHOT database (DBID 1019) in the repository MUF.

The DST information is copied to the SNAPSHOT tables with additional columns added to the front of each row to uniquely identify each Snapshot rowset.

• S_MUF_ENABLE—Date/time this execution of MUF was enabled
• S_MUF_DATETIME—Date/time of the Snapshot
• S_MUF_TOTALROW—Differentiate between normal and total rows (see the following)

The columns can be combined with the MUF_NAME and other columns for each table definition to uniquely identify the rows in a given Snapshot rowset.

The rest of the row's content is copied intact from the DST row. When the DST table being processed has one row, such as the MUF_SYSTEM_STATS table, there is one detail Snapshot row created. When the DST table has multiple rows, such as the MUF_AREA_STATS table, the Snapshot table will have a corresponding set of detail rows.

For multiple-row DST tables, the AutoCollect process also creates one or more total rows in the Snapshot table. The total rows are indicated by having the S_MUF_TOTALROW flag set to Y, detail rows have this flag set to N. The total row's value columns is the total of values collected from detail rows for this table, in this Snapshot rowset.

For more information about the number and contents of each Snapshot rowset, see SNAPSHOT Database.