Workload Configuration
Workload configuration is stored in the iidbdb database in three tables:
• iiwlm_config
• iiwlm_queue
• iiwlm_queueauth
You can directly modify the contents of the workload management system catalogs, but the changes to the configuration are not loaded nor made active until an ALTER WLM RECONFIGURE FROM TABLES query is executed or the server is restarted.
Note: Modifying the catalogs directly will cause the stored configuration (in the catalogs) to be out of sync with the configuration in memory until an ALTER WLM RECONFIGURE FROM TABLES query is executed or the server is restarted. If they stay out of sync, ALTER WLM sql commands may not run properly.
Invalid entries in the workload management system catalogs are ignored.
Modifying system catalogs in iidbdb requires using the +U or +Y flag when connecting to the database. +U takes an exclusive lock on iidbdb. +Y does not lock iidbdb.
Last modified date: 06/28/2024