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