DB2 provides a Workload Manager (WLM) that allows an administrator to define different work load classifications and store client information associated with a connection. The WLM is a priority and resource manager within DB2 for Linux/UNIX/Windows. On z/OS, the WLM is part of the operating system. WLM prioritizes and matches DB2 workloads with available resources. DB2 workloads allow you to categorize similar types of work. For example, a database administrator can create a DB2 workload named Sales to service all connections that come from Sales applications.
The WLM automatically adjusts server resources, such as CPU and memory, based on the service class associated with a DB2 workload. Therefore, an application’s performance is tied to the DB2 workload to which it is assigned and, ultimately, to the service class associated with that workload. For example, an application that performs batch work nightly when resource usage is low can use the default workload. In contrast, sales updates that need to be processed quickly twice a day need to use a workload that is governed by a high priority service class.
It is important to understand that, unless specified otherwise, all work runs in the default workload that is governed by the default service class. To ensure the best performance, consult with your database administrator to verify that your application is associated with the appropriate DB2 workload and service class.
In addition to workload management, WLM also provides monitoring functionality that is useful for troubleshooting. For example, the database administrator can set threshold limits to detect long-running queries and gather information about those queries.
The DB2 Wire Protocol driver allows your application to set client information in the DB2 database that can be used by the WLM to classify work. If you know that your database environment uses WLM, coordinate with your database administrator to determine which connection options you need to set. These options are located on the
Client Monitoring tab of the driver Setup dialog box. See
“Using Client Information” for a general description of client information and its implementation.
Table 5-3 lists the WLM attributes for DB2 V9.5 and V9.7 for Linux/UNIX/Windows that map to information set by driver connection options. Refer to your DB2 documentation for information about using these WLM attributes.
Table 5-4 lists the WLM attributes for DB2 for z/OS that map to information set by driver connection options. Refer to your DB2 documentation for information about using these WLM attributes.
The driver supports authentication and encryption. Security connection options are located on the
Security tab of the driver Setup dialog box. See
“Using Security” for a general description of security and its implementation. The following security information is specific to the DB2 Wire Protocol Driver.
The driver supports connection pooling and its related connection options. Connection pooling connection options are located on the
Pooling tab of the driver Setup dialog box. See
“Using DataDirect Connection Pooling” for a general description of connection pooling and its implementation.
The driver supports DataDirect bulk load and its related connection options. Bulk load connection options are located on the
Bulk tab of the driver Setup dialog box. See
“Using DataDirect Bulk Load” for a general description of DataDirect bulk load and its implementation.