Configuring the query service for the data sets store connections
The Cognos® Analytics query service removes tables from the schema that is associated with Data sets store connections. You can change how often the service checks for tables to be removed.
The default values can be changed by defining the following advanced server properties on the query service:
- qs.dbdatasets.orphanedTablesCleanupInterval
- By default, the query service checks every 900 seconds (15 minutes) for tables to be removed.
- qs.dbdatasets.orphanedTablesStaleInterval
- By default, the query service checks every 28800 seconds (8 hours) for tables where an upload
failed unexpectedly. For example, when data was being uploaded, a network or database error caused
the connection to become invalid.
The minimum integer value that can be specified is for this property is 60 seconds.
Using a value greater than the default increases the period of time before space in the database is released.