Difference between revisions of "Cleaning Up Old QVD Files"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Johno
Line 4: Line 4:
 
''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:\ .''
  
−
Vital Signs, as of version 1.5, does not attempt to clean up older qvd files. In subsequent versions this may become a feature that can be enabled.
+
Starting with Version 1.7 of Vital Signs, released Fall 2015, Vital Signs includes a '''cleanup''' job that deletes old QVD files.
  
−
The current recommendations for cleaning up this directory to save on disk space are shown here :
+
Users must '''explicitly enable''' the QVD cleanup feature and configure the number of days (and month-ends) of data that Vital Signs should keep.
  
−
''Note : The names listed are the first part of the file names, there will be date stamps appended to them in the qvd directory.''
+
The QVD cleanup is enabled and configured in the vsigns_srv.ini file.
  
 +
The actual cleanup is started by launching a job from HPUX:
  
−
'''Daily Member, Share and Loan File extracts'''
+
  /VSJOBS/JVSCLEANUP [[REQDATE=]YYYYMMDD] [PRINT=YES|NO] [DELETE=YES|NO]"
  
−
These files contain the daily extracted information for members used by the Analysis_by_Account, Summary and Loan Application documents.
+
Where:      echo "  - REQDATE    The date in YYYYMMDD format to use to determine the age of the"
−
 
+
      echo "                QVD files to be deleted.  The actual files deleted will depend"
−
It is recommended that you keep 24 months of daily files and only retain the EOM dated files older than 24 months.
+
      echo "                on the vitalsigns.ini settings located on the Windows server."
−
<pre>
+
      echo "                o Default is to use the current date."
−
ATTRDESC
+
      echo "                o The keyword REQDATE is not required."
−
COLLFILE
+
      echo "  - PRINT      YES - Print a detailed listing of the files to delete. (Default)"
−
LNADDM
+
      echo "                NO - Only a summary of deleted files is reported."
−
LNAP_APP
+
      echo "  - DELETE      YES - Actually deletes the files. (Default)"
−
LNAP_BOASST
+
      echo "                NO - No delete is performed, files are listed only."
−
LNAP_BOSCOR
 
−
LNAP_TERMS
 
−
LNFILE
 
−
LNTBCL
 
−
MBRATTR
 
−
MBRFILE
 
−
MBRPROD
 
−
SHCHGOFF
 
−
SHFILE
 
−
SHTBCL
 
−
VEHCINFO
 
−
VISAINFO
 
−
</pre>
 
−
 
 
−
 
 
−
'''Data Change Files'''
 
−
 
 
−
These files contain the data for the Spectrum Data Change document.
 
−
 
 
−
It is recommended that you keep 12 months of these files.
 
−
<pre>
 
−
DTACHGLN
 
−
DTACHGSH
 
−
</pre>
 
−
 
 
−
 
 
−
'''Transaction Files'''
 
−
 
 
−
These files are used by the older Transaction_Activity and newer Transaction_Analysis documents.
 
−
 
 
−
It is recommended that you keep 25 months of these files.
 
−
<pre>
 
−
TLRHIST (only used by the deprecated Transaction_Activity document)
 
−
HIST
 
−
CL
 
−
TLRHRS
 
−
</pre>
 

Revision as of 21:45, 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 actual cleanup is started by launching a job from HPUX:

 /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"

     echo "                QVD files to be deleted.  The actual files deleted will depend"
     echo "                on the vitalsigns.ini settings located on the Windows server."
     echo "                o Default is to use the current date."
     echo "                o The keyword REQDATE is not required."
     echo "  - PRINT       YES - Print a detailed listing of the files to delete. (Default)"
     echo "                NO - Only a summary of deleted files is reported."
     echo "  - DELETE      YES - Actually deletes the files. (Default)"
     echo "                NO - No delete is performed, files are listed only."