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

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: November 14, 2019