Difference between revisions of "Cleaning Up Old QVD Files"
>Johno |
>Kevint |
||
| Line 1: | Line 1: | ||
| − | Vital Signs creates binary qvd files | + | Vital Signs creates binary qvd files containing the extracted data from the core. These files are stored in the c:\vitalsigns\cu-name\data\qvd directory. |
''Note: The vitalsigns directory may be located on a different drive than c:\ .'' | ''Note: The vitalsigns directory may be located on a different drive than c:\ .'' | ||
| Line 65: | Line 65: | ||
For example, running: | For example, running: | ||
| − | + | :/VSJOBS/JVSCLEANUP DELETE=NO | |
| − | + | will print a detailed list of files that qualify for deletion, but no delete will be performed. | |
When you are confident that the list of qualified files is correct, you can proceed to delete the files as follows: | When you are confident that the list of qualified files is correct, you can proceed to delete the files as follows: | ||
| − | + | :/VSJOBS/JVSCLEANUP DELETE=YES | |
* Remember, use the vsigns_srv INI variables HIST_QVD_NDAYS, MBR_QVD_NDAYS and MBR_QVD_NMTHENDS to configure how much history to retain in Vital Signs. | * Remember, use the vsigns_srv INI variables HIST_QVD_NDAYS, MBR_QVD_NDAYS and MBR_QVD_NMTHENDS to configure how much history to retain in Vital Signs. | ||
* If space allows, we recommend setting MBR_QVD_NMTHENDS at 60 or higher, so that you retain at least 5 years worth of month-end data. | * If space allows, we recommend setting MBR_QVD_NMTHENDS at 60 or higher, so that you retain at least 5 years worth of month-end data. | ||
* Once you are confident with your setup, schedule the JVSCLEANUP job to run monthly via UC4. | * Once you are confident with your setup, schedule the JVSCLEANUP job to run monthly via UC4. | ||
Revision as of 22:21, 2 December 2015
Vital Signs creates binary qvd files containing the extracted data from the core. These files are stored in the c:\vitalsigns\cu-name\data\qvd directory.
Note: The vitalsigns directory may be located on a different drive than c:\ .
Starting with Version 1.7 of Vital Signs, released Fall 2015, Vital Signs includes a cleanup job that deletes old QVD files.
Users must explicitly enable the QVD cleanup feature and configure the number of days (and month-ends) of data that Vital Signs should keep.
The QVD cleanup is enabled and configured in the vsigns_srv.ini file. The relevant keywords are repeated here for convenience:
| INI Keyword | Default Value | Purpose |
| QVD_DELETE_OK | N | Set this to "Y" to enable deletion of old QVD files. |
| HIST_QVD_NDAYS | 750 | Number of days of raw HIST QVDs to retain. Minimum is 400 days (roughly 13 months). |
| MBR_QVD_NDAYS | 750 | Number of days of raw MBRSHLN QVDs to retain. Minimum is 400 days (roughly 13 months). |
| MBR_QVD_NMTHENDS | 60 | Number of monthend days of raw MBRSHLN QVDs to retain. Minimum is 25 monthend days. |
- By default, approximately 25 months (750 days) of HIST and MBR (member, share, loan) daily extracts is retained. Increasing HIST_QVD_NDAYS and MBR_QVD_NDAYS will save more of the daily extracts.
- By default, 5 years (60 month-ends) of MBR (member, share, loan) month-end data is retained. Increasing MBR_QVD_NMTHENDS will save additional month-end extracts.
- Once QVD cleanup has been enabled in the vsigns_srv INI file, the actual cleanup can be performed by launching the cleanup job.
JVSCLEANUP
The actual cleanup is started by launching a job from HPUX:
/VSJOBS/JVSCLEANUP [[REQDATE=]YYYYMMDD] [PRINT=YES|NO] [DELETE=YES|NO]"
Where:
| Job Parm (Note) | Default Value | Purpose |
| REQDATE (1) | Current Date | The reference date used when calculating the age of the QVD files. |
| Yes | When set to YES, the job will print a detailed list of all QVD files deleted. | |
| DELETE | No | When set to Yes, QVD files will be deleted. When set to No, no files are deleted. |
We strongly recommend that you run the job in preview mode before actually deleting any QVD files.
For example, running:
- /VSJOBS/JVSCLEANUP DELETE=NO
will print a detailed list of files that qualify for deletion, but no delete will be performed.
When you are confident that the list of qualified files is correct, you can proceed to delete the files as follows:
- /VSJOBS/JVSCLEANUP DELETE=YES
- Remember, use the vsigns_srv INI variables HIST_QVD_NDAYS, MBR_QVD_NDAYS and MBR_QVD_NMTHENDS to configure how much history to retain in Vital Signs.
- If space allows, we recommend setting MBR_QVD_NMTHENDS at 60 or higher, so that you retain at least 5 years worth of month-end data.
- Once you are confident with your setup, schedule the JVSCLEANUP job to run monthly via UC4.
