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
•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
•COMMIT = nnnnn0
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
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=YN
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
•S120SEC=nnnnnnn
96 | DB2 Manager User Guide |
| StorageTek Proprietary |