Previous Topic: When to UseNext Topic: Example JCL

AUTOCOLL (Collect and Manage Snapshots) › User Created SUMMARY Delta Rowset › How to Use

How to Use

Use the following syntax to write this command:

►►─ AUTOCOLL ─ OPTION=SUMMARY ─ ,MUFNAME=mufname ─ ,TYPE= ─┬─ AVGPERF ──┬─────►
                                                           ├─ BASELINE ─┤
                                                           ├─ INTERVAL ─┤
                                                           ├─ LAST ─────┤
                                                           └─ SUMMARY ──┘

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

 ►─┬────────────────────────┬─┬────────────────────────────┬──────────────────►
   └─ ,TIMERG=hhmmsshhmmss ─┘ └─ ,OUTTAG=cccccccccccccccc ─┘

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

Command

AUTOCOLL

Invokes the AUTOCOLL function.

Required Keywords

OPTION=SUMMARY

Specifies to total the counter columns from all Delta rowsets selected and build a new summary rowset.

Valid Entries:

SUMMARY

Default Value:

(No default)

MUFNAME=

Only Delta rowsets with this mufname will be selected for processing.

Valid Entries:

1- to 8-byte valid mufname found on one or more of the Delta rowsets.

Default Value:

(No default)

TYPE=

Specifies the type of Delta rowsets selected as input for the processing. The type of rowset is identified in the D_MUF_TYPE column.

AVGPERF

Identifies a user created Delta rowset that was built by the AVGPERF function.

BASELINE

Identifies a user created Delta rowset that was built by the BASELINE function.

INTERVAL

Identifies a DELTA INTERVAL rowset that was built by the DELTACRE function.

LAST

Identifies a DELTA LAST rowset that was built by the DELTACRE function.

SUMMARY

Identifies a user created Delta rowset that was built by the SUMMARY function.

Valid Entries:

AVGPERF, BASELINE, INTERVAL, LAST, or SUMMARY

Default Value:

(No default)

Optional Keywords

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.

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

OUTTAG=

Places a 1- to 16-byte character tag in the USERTAG column on each Delta row produced by this execution. You can then specify that tag value as a selection criteria in future executions.

Valid Entries:

1 to 16 characters

Default Value:

(No default) If the keyword is not specified, the USERTAG column will be set to blanks.

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.

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 USERTAG values will be selected for processing.