Difference between revisions of "Cleaning Up Old QVD Files"
>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...") |
>Jeremyb |
||
| 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. | It is recommended that you keep 24 months of daily files and only retain the EOM dated files older than 24 months. | ||
| − | + | <pre> | |
ATTRDESC | ATTRDESC | ||
COLLFILE | COLLFILE | ||
| Line 34: | Line 34: | ||
VEHCINFO | VEHCINFO | ||
VISAINFO | VISAINFO | ||
| − | + | </pre> | |
| Line 42: | Line 42: | ||
It is recommended that you keep 12 months of these files. | It is recommended that you keep 12 months of these files. | ||
| − | + | <pre> | |
DTACHGLN | DTACHGLN | ||
DTACHGSH | DTACHGSH | ||
| − | + | </pre> | |
| Line 53: | Line 53: | ||
It is recommended that you keep 25 months of these files. | It is recommended that you keep 25 months of these files. | ||
| − | + | <pre> | |
TLRHIST (only used by the deprecated Transaction_Activity document) | TLRHIST (only used by the deprecated Transaction_Activity document) | ||
HIST | HIST | ||
CL | CL | ||
TLRHRS | TLRHRS | ||
| + | </pre> | ||
Revision as of 22:33, 2 April 2013
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
