Prioritizing databases in AUS
You can assign a priority to each of your databases in the AUS maintenance system.
By default all databases have a medium priority. You can assign specific databases a high or a low priority to ensure that statistics for your most important databases are updated first. Statistics for low priority databases are updated after high and medium priority databases, if time and resources permit. For example, if you have a system with a production and a test database, you can assign the production database a high priority and the test database a low priority. You can also disable AUS for a database.
You can prioritize databases in the IBM® OpenAdmin Tool (OAT) for Informix®.
You must be connected to the sysadmin database as user informix or another authorized user.
- High priority: Add a row with the name column set to AUS_DATABASE_HIGH and the value column set to the name of the database.
- Low priority: Add a row with the name column set to AUS_DATABASE_LOW and the value column set to the name of the database.
- Disable: Add a row with the name column set to AUS_DATABASE_DISABLE and the value column set to the name of the database.
Example
The following statement sets the priority for the database that is named my_database to high:
INSERT INTO ph_threshold(id, name, task_name, value, value_type, description)
VALUES(0,
"AUS_DATABASE_HIGH",
"Auto Update Statistics Evaluation",
"my_database",
"STRING",
"Rank this database as high priority to get its tables done first");