Defining work data sets

Three sequential data sets are required during execution of CHECK DATA. Two work data sets and one error data set are described by DD statements in the WORKDDN and ERRDDN options.

Procedure

To define work data sets:

  1. Find the approximate size, in bytes, of the WORKDDN data set:
    Option Description
    If a table space has a LOB column Count a total of 70 bytes for the LOB column and multiply the sum by the number of keys and LOB columns that are checked.
    If a table space does not have a LOB column Start of changeAdd 20 to the length of the longest foreign key.

    For nonpadded indexes, the length of the longest foreign key is the maximum possible length of the key with all varying-length columns in the key padded to their maximum length, plus 2 bytes for each varying-length column.

    End of change
  2. Create the ERRDDN data set so that it is large enough to accommodate one error entry (length=60 bytes) per violation that CHECK DATA detects.