Difference between revisions of "Cleaning Up Old QVD Files"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
>Johno
Line 8: Line 8:
 
Users must '''explicitly enable''' the QVD cleanup feature and configure the number of days (and month-ends) of data that Vital Signs should keep.
 
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 QVD cleanup is enabled and configured in the [[vsigns_srv.ini]] file. The relevant keywords are repeated here for convenience:
 +
 
 +
{| class="wikitable"
 +
| '''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:
 
The actual cleanup is started by launching a job from HPUX:
Line 14: Line 42:
 
   /VSJOBS/JVSCLEANUP [[REQDATE=]YYYYMMDD] [PRINT=YES|NO] [DELETE=YES|NO]"
 
   /VSJOBS/JVSCLEANUP [[REQDATE=]YYYYMMDD] [PRINT=YES|NO] [DELETE=YES|NO]"
  
Where:     echo " - REQDATE     The date in YYYYMMDD format to use to determine the age of the"
+
Where:
      echo "                QVD files to be deleted.  The actual files deleted will depend"
+
 
      echo "                on the vitalsigns.ini settings located on the Windows server."
+
{| class="wikitable"
      echo "                o Default is to use the current date."
+
| '''Job Parm (Note)'''
      echo "                o The keyword REQDATE is not required."
+
| '''Default Value'''
      echo "  - PRINT      YES - Print a detailed listing of the files to delete. (Default)"
+
| '''Purpose'''
      echo "                NO - Only a summary of deleted files is reported."
+
|-
      echo "  - DELETE     YES - Actually deletes the files. (Default)"
+
| REQDATE (1)
      echo "                NO - No delete is performed, files are listed only."
+
| Current Date
 +
| The reference date used when calculating the age of the QVD files.
 +
|-
 +
| PRINT
 +
| 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.

Revision as of 22:10, 2 December 2015

Vital Signs creates binary qvd files housing all of the extracted data which 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.
PRINT 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.