StorageTek 312564001 manual Newtape=Yes No, •DB2SSID=xxxx, •PLAN=xxxxxxxx, •S100PRI=nnnnnnn

Models: 312564001

1 189
Download 189 pages 56.09 Kb
Page 87
Image 87

NEWTAPE=YESNO

This is an optional parameter used to cause a new tape volume in the Archive Manager database to be opened at the start of migration processing. If omitted, the default value of “NO” is used.

DB2SSID=xxxx

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 OTDBL100 is used. Refer to “Perform DB2 system modifications” page 25 for information about DB2 Manager plan creation processing.

S100PRI=nnnnnnn

This is an optional parameter specifying the number of primary extent blocks to be used during allocation of temporary dataset OTDBS100 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 85 for a discussion of the unique index requirement).

S100SEC=nnnnnnn

This is an optional parameter specifying the number of secondary extent blocks to be used during allocation of temporary dataset OTDBS100 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 85 for a discussion of the unique index requirement).

S100UNIT=xxxxxxxx

This is an optional parameter specifying the unit name to be used for allocation of temporary dataset OTDBS100 used during execution of the utility. ‘xxxxxxxx’ is any valid disk or VIO unit name. If omitted, a default value of ‘VIO’ is used.

ROWMAX=nnnnnn0

This is an optional parameter specifying the maximum number of rows to be migrated from DB2 by the utility. The utility will terminate processing

84

DB2 Manager User Guide

 

StorageTek Proprietary

Page 87
Image 87
StorageTek 312564001 Newtape=Yes No, •DB2SSID=xxxx, •PLAN=xxxxxxxx, •S100PRI=nnnnnnn, •S100SEC=nnnnnnn, •S100UNIT=xxxxxxxx