Queue Configurations
A queue configuration is a set of queues that is assigned a configuration name, like ‘Weekday’, ‘Weekend’, or ‘Monthend’. This allows different workload management configurations to be stored. The database administrator can easily switch between configurations as needed without restarting the server using the ALTER WLM statement. When a queue is created, it is added to a specific configuration.
When workload management is active, a specific configuration is made active. (This configuration is specified in the iiwlm_config catalog in iidbdb.)
When a configuration is active, any queues added to that configuration are made active and will start queuing sessions.
Note: Queues with the same name or a single queue can exist in different configurations and may have different or same properties in each configuration. For example, the ‘Batch’ queue can have a higher active_limit in the ‘Night’ than the ‘Day’ configuration.
You can change the active configuration without restarting the server by one of the following methods:
• Issuing the statement ALTER WLM CONFIG SET CONFIG=config_name.
• Updating the iiwlm_config table in iidbdb, and then running ALTER WLM RECONFIGURE FROM TABLES.
Last modified date: 08/29/2024