Previous Topic: When to UseNext Topic: Example JCL

AUTOCOLL (Collect and Manage Snapshots) › Reporting Delta Rowsets › How to Use

How to Use

Use the following syntax to write this command:

►►─ AUTOCOLL ─ OPTION=DELTARPT ─┬────────────────────┬────────────────────────►
                                └─ ,MUFNAME=mufname ─┘

 ►─┬───────────────────────┬─┬────────────────────────────┬───────────────────►
   └─ ,DBID= ─┬─ 1020 ◄ ─┬─┘ └─ ,DATERG=ccyymmddccyymmdd ─┘
              └─ nnnn ───┘

 ►─┬────────────────────────┬─┬─────────────────────────┬─────────────────────►
   └─ ,TIMERG=hhmmsshhmmss ─┘ └─ ,TYPE= ─┬─ AVGPERF ──┬─┘
                                         ├─ BASELINE ─┤
                                         ├─ INTERVAL ─┤
                                         ├─ LAST ─────┤
                                         └─ SUMMARY ──┘

 ►─┬────────────────────┬─────────────────────────────────────────────────────►◄
   └─ ,USERTAG=usertag ─┘

Command

AUTOCOLL

Invokes the AUTOCOLL function.

Required Keywords

OPTION=DELTARPT

Specifies to create a report of Delta rowsets.

DELTARPT

Specifies to list each of the Delta rowsets and the number of rows in each Delta table that belongs to that rowset.

Valid Entries:

DELTARPT

Default Value:

(No default)

Optional Keywords

MUFNAME=

Specifies the name of the MUF (1-8 bytes).

Valid Entries:

A valid mufname contained on one or more Delta rowsets.

Default Value:

(No default) If this keyword is not specified, all mufnames will be selected for processing.

DBID=

Specifies the database ID of the Delta database from which the Delta or rowsets are both read and written.

Valid Entries:

1 to 5000

Default Value:

1020

DATERG=

Specifies the range of dates (D_MUF_END_DATETIME) for the selected rowsets to qualify for processing. Format ccyymmddccyymmdd

Valid Entries:

The entry must be one or more of the following:

  • Starting date value is between 19000101 and 39991231
  • Ending date value is between 19000101 and 39991231
  • Ending date must be equal or greater than the starting date
Default Value:

(No default) All dates will be selected for processing.

TIMERG=

Specifies the range of times (D_MUF_END_DATETIME) on which to base the selection. Format hhmmsshhmmss

Valid Entries:

The entry must be one or more of the following:

  • Starting time value is between 000000 and 240000
  • Ending time value is between 000000 and 240000
  • Ending time must be equal or greater than the starting time
Default Value:

(No default) All times will be selected for processing.

TYPE=

Specifies to select the rows with the following in the MUFTYPE column.

AVGPERF

Select only rows with a MUFTYPE of AVGPERF.

BASELINE

Select only rows with a MUFTYPE of BASELINE.

INTERVAL

Select only rows with a MUFTYPE of INTERVAL.

LAST

Select only rows with a MUFTYPE of LAST.

SUMMARY

Select only rows with a MUFTYPE of SUMMARY.

Valid Entries:

AVGPERF, BASELINE, INTERVAL, LAST, or SUMMARY

Default Value:

(No default) All TYPEs will be selected for processing. Process all.

USERTAG=

Specifies to restrict processing to a Delta rowset that has the specified value in the USERTAG column.

Valid Entries:

1 to 16 characters

Default Value:

(No default) All USERTAGs will be selected for processing.