Query history and workload monitoring

You can enable query history for monitoring and analysis of workloads by using the IBM® Db2® Warehouse console.

1. Log in to the Db2 Warehouse web console as bluadmin.

   https://<virtual_ip>:8443/console

2. Select Monitor > Workloads
3. For Time mode:, select History.
   This starts the collection of query history.

   

   When query history monitoring is enabled in the Db2 Warehouse web console, default monitoring profile properties are pre-defined so that you don't have to configure the database activity monitoring.

   Note: Query history is stored in the IBMOTS.SQL_DIM table. The IBM_RTMON_EVMON.EVENT_ACTIVITY table stores the following additional information:

   • planid
   • user id
   • application name
   • service class
   • workload id
   • estimated cost
   • and more.

   You can join these tables to get detailed information about a query.
4. To monitor a specific workload, click the Database drop-down menu and choose the workload.