Previous Topic: When to UseNext Topic: Example JCL


How to Use

Use the following syntax to write this command:

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

 ►─┬────────────────────────────┬─┬───────────────────┬───────────────────────►◄
   └─ ,DBID= ─┬─ 1019-1020 ◄ ─┬─┘ └─ ,DATEC=ccyymmdd ─┘
              └─ nnnnn-nnnnn ─┘

Command

AUTOCOLL

Invokes the AUTOCOLL function.

Required Keywords

OPTION=DELTACRE

Specifies to create a Delta rowset from a Snapshot rowset.

Optional Keywords

MUFNAME=

Specifies the mufname of the rows on the Snapshot tables that are to be selected for processing (1 - 8 bytes).

Valid Entries:

A valid mufname contained on one or more Snapshot rowsets.

Default Value:

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

DBID=

Specifies the database ID of the Snapshot database where the Snapshot rowsets are located and the DBID of the Delta database where the Delta rowsets will be recorded. If this parameter is specified, both DBIDs must be provided separated by a dash ("-"). You must always specify the lower DBID first.

Valid Entries:

Two 5 digit DBIDs separated by a dash ("-").

Default Value:

1019-1020 or 01019-01020

DATEC=

Specifies that only Snapshot rowsets with a MUF enable date (S_MUF_ENABLE) greater than or equal to this date will be processed into Delta rowsets. Use the format ccyymmdd.

Valid Entries:

8 digits

Default Value:

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