Previous Topic: OPTIMIZE DATABASE

Next Topic: Format

Description

Reclaims unused space in the jobs database This command affects the following data files in NSCHED$DATA:VSS.DAT, DEPENDENCY.DAT and VSS2.DAT. Resets the counter of deleted jobs to zero. Shut down the manager and CA Common Services Integration before running this command.

Because the manager is designed to run repetitious jobs rather than one-time jobs, we recommend that you use this command after you have deleted 100 job records from the job database.

If the percentage of deleted jobs is considerably higher than the number of active jobs, compress the database. Even if the deleted jobs are less than 100, performance can be affected if the active jobs are less than or equal to the deleted jobs.

To see the current number of deleted job records since the last job-database compression, use the SCHEDULE SHOW DELETES command.

This command supersedes RUN NSCHED$:DB_UTILITY for compressing and optimizing the jobs database. To repair the database, see RUN NSCHED$:DB_UTILITY.