Previous Topic: When to UseNext Topic: Example JCL

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

How to Use

Use the following syntax to write this command:

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

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

 ►─┬────────────────────────┬─────────────────────────────────────────────────►◄
   └─ ,TIMERG=hhmmsshhmmss ─┘

Command

AUTOCOLL

Invokes the AUTOCOLL function.

Required Keywords

OPTION=SNAPRPT

Specifies to create a report of Snapshot rowsets.

SNAPRPT

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

Valid Entries:

SNAPRPT

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 of the Snapshot rowsets.

Default Value:

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

DATERG=

Specifies the range of dates (S_MUF_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.

DBID=

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

Valid Entries:

1 to 5000

Default Value:

1019

TIMERG=

Specifies the range of times (S_MUF_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.