Previous Topic: SET AUTO_AUGMENTNext Topic: SHOW/ALL


SET VERSION_LIMIT

This command establishes the setting of the file version limit on the Performance Management parameters file and history files.

Format

SET VERSION_LIMIT=number

Description

The SET VERSION_LIMIT command establishes the setting of the file version limit on the Performance Management parameters file and history files. The version limit for these files defines the number of file generations that reside in the PSDC$DATABASE area. The initial setting is zero, indicating no version limits.

Note: Setting a version limit is particularly useful in reducing the disk space requirements for history files that have the PERIODICITY attribute. Each daily data file archived into a history file results in a new version of the history file, which supersedes the former. The version limit restricts the number of simultaneous history files of this type and reduces disk space requirements.

Example

PSDC-EDIT> SET VERSION_LIMIT=5

This command establishes a limit of five file versions of the Performance Management parameters file and history files.