Altering Proprietary Database Retentions Through GUI, CLI, and Installations

 

Before You Begin

You can alter proprietary database retentions from the graphical user interface (GUI), through CLI, or during installation.

Steps
To alter retentions on a proprietary database through the GUI:

1. Log into TeamQuest Administration Console.
   Note: You can access TeamQuest Administration Console using the https://nodename:port URL.
2. Click Database Settings and adjust the database as needed.
   Note: If only one database exists, it is selected by default.
3. From the left panel, click Aggregation.
   Available aggregation sets are displayed.
   
   1. From the Aggregation Set List page, select an aggregation set.
   2. From the Retention field, click the Edit link.
   3. Make your changes.
   4. Click Save.  

To add a new aggregation set:

1. Log into TeamQuest Administration Console.
   Note: You can access TeamQuest Administration Console using the https://nodename:port URL.
2. Click Database Settings and adjust the database as needed.
   Note: If only one database exists, it is selected by default.
3. From the left panel, click Aggregation.
   Available aggregation sets are displayed.
4. Click Add Aggregation Set.
5. Type a name for the aggregation set.
   Fortra recommends naming the aggregation set by the size. For example, 8-hour, 5-minute, and so on.
6. Type the granularity.
   Granularity uses the HH:MM:SS time format. For example, 08:00:00 for 8 hour.
7. Type the retention.
   This value determines how long data is retained in the set before it is deleted.
8. Select the next available smallest size of the source.
   For example, if your retention is 8-hour, and the next smallest size is 1-hour, select 1-hour.
9. Click Add.
   The set is created and obtains data when the next aggregation runs.

To add retentions and aggregation sets through CLI:
You can add and edit retentions and aggregation sets using CLI when you are logged in as the Microsoft Windows administrator.

To view available aggregation sets and information for the default database, run tqasa with no options from the manager\bin directory.

To alter existing aggregation set retentions:

From the manager\bin directory, run the following command:
tqasa -d <dbname> -m aggregationsetname -g -k retentionname

For example, if you want to change an 8-hour aggregation set to 1-year in the production, run the following command:
tqasa -d production -m 8-hour -k 365

To create an 8-hour aggregation set using CLI:

From the manager\bin directory, run the following command:
tqasa -d production -m 8-hour -g 28800 -k 365

where the value for -g is the number of seconds for the granularity. For example, 8 hours is 8 hours * 60 minutes in an hour * 60 seconds in a minute.

For more information, see the CONFIG= file section for the CustomDatabase= field in the Format section of the TeamQuest CMIS Installation Guide.