Using copy in a utility procedure

In the Add Utility Procedure Element window select Copy to specify the copy utility should be run on the object list when the utility procedure is run.

An object list is a collection of predefined objects such as indexes or table spaces that can be referred to in order to run a utility on all of the objects in the object list using only a single command.


To specify Copy to be run on an object list through a utility procedure:

  1. Select the Reference or Change radio button to indicate whether other programs can access or update the table space while COPY is running. A Reference share level allows read-only access by other programs. A Change share level allows other programs to change the table space.

  2. If you do not want to process the objects in parallel, select the radio button.

  3. If you want to process the objects in parallel and you want DB2 to determine the maximum number of objects to process, select the DB2 determines the number of objects to be processed in parallel radio button.

  4. If you want to process the the objects in parallel, you select the radio button and then define a maximum limit of objects to be processed in parallel at one time.

  5. Specify the data set templates to use.

  6. Optional: Select the to open a the Change Error Processing window.

  7. Select the OK push button to add the element to the utility procedure.




Related information:

DB2 for OS/390 Version 6