How to Use

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

How to Use

Use the following syntax to write this command:

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

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

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

Command

AUTOCOLL: Invokes the AUTOCOLL function.

Required Keywords

OPTION=SNAPDEL

Specifies to delete Snapshot rowsets.

SNAPDEL: Specifies to select Snapshot rowsets to be deleted.
Valid Entries:: SNAPDEL
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 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:

Process all dates

DBID=

Specifies the database ID of the Snapshot database from which the Snapshot rowsets are to be deleted.

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:

Process all