Prioritizing databases in AUS

You can assign a priority to each of your databases in the AUS maintenance system.

About this task

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 must be connected to the sysadmin database as user informix or another authorized user.

Procedure

To assign a priority to a database in AUS, add a row to the ph_threshold table in the sysadmin database:
  • 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.
If you assign more than one priority to a database, the higher priority takes precedence.

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");