Snapshot Rowsets

AutoCollect SNAPSHOT Database › Snapshot Rowsets

Snapshot Rowsets

For every Snapshot taken, one Snapshot rowset is created with the following rows being added to Snapshot tables.

SQL NAME	Table	Detail Rows	Total Rows
S_MUF_ACCOUNTING	MFY	1 per acct table*	1
S_MUF_AREA_STATS	MFA	1 per area*	1
S_MUF_CBS	MCB	1	0
S_MUF_CONFIG	MCF	1 per configuration parameter*	0
S_MUF_COVEREDVIRTUAL	MFC	1 per definition*	2
S_MUF_INTERNAL_STATS	MFV	1	0
S_MUF_OPTIONS	MFO	1	0
S_MUF_RETURN_CODES	MFU	1 per DB return code*	1
S_MUF_SMP_STATS	MFW	1	0
S_MUF_SRB_ZIIP	MCF	1 per SRB*	1
S_MUF_SYSTEM_STATS	MFS	1	1
S_MUF_TABLE_STATS	MFT	1 per table*	1
S_MUF_TCB_OR_SRB	MTC	1 per subtask*	1
S_SQL_MISC_STATS	SQM	1	0
S_SQL_SQLCODES	SQQ	1 per SQL code*	1

Note: Asterisk (*) indicates that the number of rows is dependent on the active number of DST rows at the time the Snapshot was taken. Once an entry becomes active in DST it remains there for the duration of this execution of MUF.

The following is an example of Snapshot rowsets created:

A user creates one Snapshot a day at 5 PM and one before the MUF is terminated.
The source MUF environment is cycled weekly.
The following maximum number of active items:
- Areas = 100
- Tables = 200
- Accounting tables = 5
- Virtual/Covered = 5
- DB return codes = 10
- SQL return codes = 10
Expected rowsets created per Snapshot will be 342.
8 Snapshots = 2736 Snapshot rowsets created per week.