Data sets that REPAIR uses

The REPAIR utility uses a number of data sets during its operation.

The following table lists the data sets that REPAIR uses. The table lists the DD name that is used to identify the data set, a description of the data set, and an indication of whether it is required. Include statements in your JCL for each required data set and any optional data sets that you want to use.

Table 1. Data sets that REPAIR uses
Data set	Data set	Required?
SYSIN	Input data set that contains the utility control statement.	Yes
SYSPRINT	Output data set for messages.	Yes
Optional output data set	Data set that contains copies of the Db2 catalog records that are used to rebuild the DBD. You define the DD name.	No

The following objects are named in the utility control statement and do not require a DD statement in the JCL:

Table space or index: Object that is to be repaired.

Calculating output data set size

Use the following formula to estimate the size of the output data set:

SPACE = (4096,(n,n))

In this formula, n = the total number of Db2 catalog records that relate to the database on which REPAIR DBD is being executed.

You can calculate an estimate for n by summing the results of SELECT COUNT(*) from the following catalog tables, for catalog table rows whose database name matches the name of the database on which REPAIR DBD is being executed.

SYSCOLAUTH
SYSCOLUMNS
SYSFIELDS
SYSFOREIGNKEYS
SYSINDEXES
SYSINDEXPART
SYSKEYS
SYSRELS
SYSSYNONYMS
SYSTABAUTH
SYSTABLEPART
SYSTABLES
SYSTABLESPACE