How to Use

AUTOCOLL (Collect and Manage Snapshots) › Create DSV Output Datasets › How to Use

How to Use

Use the following syntax to write this command:

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

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

 ►─┬─────────────────────────────┬─┬─────────────────────────────┬────────────►
   └─ ,DECIMAL= ─┬─ . ◄ ───────┬─┘ └─ ,DELIMIT= ─┬─ ; ◄ ───────┬─┘
                 └─ character ─┘                 └─ character ─┘

 ►─┬────────────────────────┬─┬────────────────────────┬──────────────────────►
   └─ ,HEADER= ─┬─ YES ◄ ─┬─┘ └─ ,TIMERG=hhmmsshhmmss ─┘
                └─ NO ────┘

 ►─┬─────────────────────────┬─┬────────────────────┬─────────────────────────►◄
   └─ ,TYPE= ─┬─ AVGPERF ──┬─┘ └─ ,USERTAG=usertag ─┘
              ├─ BASELINE ─┤
              ├─ INTERVAL ─┤
              ├─ LAST ─────┤
              └─ SUMMARY ──┘

Command

AUTOCOLL: Invokes the AUTOCOLL function.

Required Keywords

OPTION=DSVOUT

Specifies to create a DSV output dataset.

Valid Entries:: DSVOUT
Default Value:: (No default)

Optional Keywords

MUFNAME=

Specifies the mufname of the row on the Delta tables that is to be selected to process (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.

DATERG=

Specifies the range of dates (D_MUF_END_DATETIME) for the selected Delta 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.

DECIMAL=

Specifies the character to use for the decimal point, such as a period (.) or a comma (,).

Valid Entries:: One character enclosed in single quotes
Default Value:: period ('.')

DELIMIT=

Specifies the character to use as the delimiter between values in the DSV output. Do not use a period (.) or a comma (,) as these special characters occur normally throughout the AutoCollect data and would cause the DSV output to be unusable.

Valid Entries:: One character
Default Value:: semicolon (;)

DBID=

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

Valid Entries:: 1 to 5000
Default Value:: 1020

HEADER=

Specifies whether to produce a header row (using column names) as the first row of the DSV output.

Valid Entries:: NO or YES
Default Value:: YES

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 Delta rows with a MUFTYPE of AVGPERF.
BASELINE: Select only Delta rows with a MUFTYPE of BASELINE.
INTERVAL: Select only Delta rows with a MUFTYPE of INTERVAL.
LAST: Select only Delta rows with a MUFTYPE of LAST.
SUMMARY: Select only Delta 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.

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.