Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Advanced Features : Client Information

Client Information
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.
DB2 V9.5 and V9.7 for Linux/UNIX/Windows
DB2 for z/OS

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.