Cleaning Up Old QVD Files - Revision history

>Kevint at 21:01, 15 May 2019

2019-05-15T21:01:27Z

>Kevint at 22:21, 2 December 2015

2015-12-02T22:21:23Z

>Johno at 22:10, 2 December 2015

2015-12-02T22:10:28Z

>Johno at 21:45, 2 December 2015

2015-12-02T21:45:16Z

>Jeremyb at 22:33, 2 April 2013

2013-04-02T22:33:28Z

>Jeremyb: Created page with " 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..."

2013-04-02T22:32:54Z

Created page with " 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..."

New page

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:\ .''

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.

The current recommendations for cleaning up this directory to save on disk space are shown here :

''Note : The names listed are the first part of the file names, there will be date stamps appended to them in the qvd directory.''

'''Daily Member, Share and Loan File extracts'''

These files contain the daily extracted information for members used by the Analysis_by_Account, Summary and Loan Application documents.

It is recommended that you keep 24 months of daily files and only retain the EOM dated files older than 24 months.

ATTRDESC
COLLFILE
LNADDM
LNAP_APP
LNAP_BOASST
LNAP_BOSCOR
LNAP_TERMS
LNFILE
LNTBCL
MBRATTR
MBRFILE
MBRPROD
SHCHGOFF
SHFILE
SHTBCL
VEHCINFO
VISAINFO

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

DTACHGLN
DTACHGSH

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

TLRHIST (only used by the deprecated Transaction_Activity document)
HIST
CL
TLRHRS

@@ Line 40: / Line 40: @@
 The actual cleanup is started by launching a job from HPUX:
-   /VSJOBS/JVSCLEANUP [[REQDATE=]YYYYMMDD] [PRINT=YES|NO] [DELETE=YES|NO]"
+   /VSJOBS/JVSCLEANUP [PRINT=YES|NO] [DELETE=YES|NO]"
 Where:
@@ Line 48: / Line 48: @@
 | '''Default Value'''
 | '''Purpose'''
 |-
 | PRINT

@@ Line 1: / Line 1: @@
-Vital Signs creates binary qvd files housing all of the extracted data which are stored in the c:\vitalsigns\cu-name\data\qvd directory.
+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:\ .''
@@ Line 65: / Line 65: @@
 For example, running:
-  /VSJOBS/JVSCLEANUP DELETE=NO
+:/VSJOBS/JVSCLEANUP DELETE=NO
-Will print a detailed list of files that qualify for deletion, but no delete will be performed.
+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
+:/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.

@@ 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.
-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:
 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]"
-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

@@ Line 4: / Line 4: @@
 ''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.
-'''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."

@@ Line 16: / Line 16: @@
 It is recommended that you keep 24 months of daily files and only retain the EOM dated files older than 24 months.
+<pre>
 ATTRDESC
 COLLFILE
@@ Line 34: / Line 34: @@
 VEHCINFO
 VISAINFO
+</pre>
@@ Line 42: / Line 42: @@
 It is recommended that you keep 12 months of these files.
+<pre>
 DTACHGLN
 DTACHGSH
+</pre>
@@ Line 53: / Line 53: @@
 It is recommended that you keep 25 months of these files.
+<pre>
 TLRHIST (only used by the deprecated Transaction_Activity document)
 HIST
 CL
 TLRHRS