Monitoring the Workload Management System
To show if workload management is enabled
SELECT DBMSINFO ('WLM_ENABLED')
Results show Y if workload management is enabled, N if not. Workload management is enabled by default.
To see the name of the active configuration
SELECT DBMSINFO ('WLM_CONFIG')
Returns an empty row for an installation where workload management is disabled.
To see if workload management auditing is enabled
SELECT DBMSINFO ('WLM_AUDIT')
Results show Y if auditing is enabled, N if not. Auditing is disabled by default.
The IMA database (imadb) can be used to monitor the active workload management configuration.
Last modified date: 12/19/2024