This optional parameter in the EXEC statement determines whether the CTDCLHST utility checks for USER or INDEX records with missing SYSDATA records, or for SYSDATA records with missing USER records.
Table 214 CTDCLHST – NOSYS parameter values
Value |
Description |
---|---|
Y (Yes) |
The utility checks for orphan USER or INDEX records (that is, those with missing SYSDATA records), issues a message for each one found, and deletes it. |
N (No) |
The utility does not check for orphan USER or INDEX records. Because this process is not run, the performance of the utility is substantially improved. |
S (SYSDATA) |
The utility checks for orphan USER, INDEX, or SYSDATA records, issues a message for each one found and deletes it. (The deletion may be delayed until the next utility run.) |
Parent Topic |