Filter
Top Products
96 DB2 Manager User Guide
StorageTek Proprietary
This mandatory parameter is used to specify the subsystem identifier of
the DB2 subsystem to be used during execution of the utility. The
subsystem identifier ‘xxxx’ can be 1-4 characters in length.
• PLAN=xxxxxxxx
This is an optional parameter which is used to specify the DB2 plan name
to be used during execution of the utility, where ‘xxxxxxxx’ is the 1-8
character identifier of the plan. If omitted, a default value of OTDBL120 is
used. Refer to “Perform DB2 system modifications” on page 25 for
information about DB2 Manager plan creation processing.
• COMMIT = nnnnn|0
This is an optional parameter used to specify the frequency at which DB2
commit processing is to be performed by the utility. ‘nnnnn’ is a 1-5 digit
numeric value in the range 0-99999, specifying the number of rows to be
restored between each commit request. A value of 0 indicates that no
explicit commit processing is to be performed by the program. If this
parameter is omitted, a default value of 0 is used.
Once commit processing has been successfully completed, all rows
restored since the last commit point (or since the beginning of the job, for
the first commit call) will have been successfully stored in the DB2 table,
and all subsequent access to those rows will be performed via DB2 only.
• INDEXONLY=Y
|N
This optional parameter is used to control whether the selection criteria
specified by the user for restoring rows are to be capable of resolution via
table indexes only. The default value of “Y” indicates that the selection
criteria must be capable of resolution via indexes only. If this is not the
case, the program will issue an error message and terminate with a
condition code 12. A value of “N” indicates that the selection criteria do
not need to be capable of resolution via indexes only. In this case,
execution of the row restore job may cause the utility to sequentially
process all migrated rows from the Archive Manager database.
If this parameter is omitted, the default value of “Y” is used.
• S120PRI=nnnnnnn
This is an optional parameter specifying the number of primary extent
blocks to be used during allocation of temporary dataset OTDBS120 used
during execution of the utility. ‘nnnnnnn’ is a 1-7 digit numeric value in
the range 1-8388607. If omitted, a default value of 10000 will be used.
The length of each block will be equal to 100 times the concatenated field
lengths of the table columns which are used to uniquely index each row in
the table (see “SQLIN entry specification” on page 97 for a discussion of
the unique index requirement).
• S120SEC=nnnnnnn