Copying a table space

Use this window to make an image copy of one or more table spaces, or of a data set within a table space.

Authorities. Authorities and privileges

To make a copy of a table space:

  1. Open the Copy on a Table Space window.

  2. 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.
  3. Optional: When critical data is involved, select the Check each page for validity check box to check each page to prevent the undetected copying of inconsistent data. Each page is checked for validity one page at a time, but it does not include any cross page checking. If an error is found, a message is issued describing the type of error. Only the first error is identified. COPY will continue checking the remaining pages in the table space or index space specified.
  4. Click Add to add a table space to the set to copy using the Add Object window.
  5. Click Change to change the data set information for the selected table space, or change a partition number if the table space is a partitioned table space.
  6. Click Remove to delete an object from the list.
  7. If you do not want to process the objects in parallel, select the radio button.
  8. 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.
  9. 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.
  10. Click OK to process the Copy utility.

Related information