Altering TeamQuest Manager Proprietary Database Table Retentions Using tqzip

 

Before You Begin

Before you can alter table retentions, you must unload the table definitions for the database you want to alter.

Steps

1. Run the following command:
   
   manager/bin/tqzip -d databasename -u -c filename
   
   where DBNAME is the name of the database and FILENAME is the name of the table retention file.
   
   
2. Edit the table retention file.
   
   The table retention file should appear similar to the following, with a separate entry for each table:
   
   BEGIN TABLESPECS unloaded on 6/4/2019 8:44:17 AM
[Service.TeamQuest Log]
RetentionStart=0000
PrimaryRetention=1WEEK
Collection=ON
CollectionSpec=0000,2400,0010,0000000
FieldSpec=Message,ON
FieldSpec=Filename,ON
FieldSpec=Sample_End_Time,ON
END TABLESPECS

3. Find the table that you want to alter the primary retention for and make your changes.
   
   For example, from the example above, to change from 1 week to 4 days, the file would be as follows:
   
   BEGIN TABLESPECS unloaded on 6/4/2019 8:44:17 AM
[Service.TeamQuest Log]
RetentionStart=0000
PrimaryRetention=4DAY
FieldSpec=Message,ON
FieldSpec=Filename,ON
FieldSpec=Sample_End_Time,ON
END TABLESPECS

4. Save your changes and reload the database using the following command:
   
   manager/bin/tqzip -d databasename -l -c filename
   
   The retentions are changed. Changing retentions does not immediately remove data from the table. These changes also do not immediately free up space on your system. Your changes are displayed after tqagg runs.
   
   To release space from the table to the filesystem, run the following command after tqagg runs:
   
   manager/bin/tqrorg -d databasename -r -a