Filter
Top Products
84 DB2 Manager User Guide
StorageTek Proprietary
• NEWTAPE=YES|NO
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=nnnnnn|0
This is an optional parameter specifying the maximum number of rows to
be migrated from DB2 by the utility. The utility will terminate processing