Client Information for Connections

Many databases allow applications to store client information that is associated with a connection. For example, the following types of information can be useful for database administration and monitoring purposes:

• Name of the application currently using the connection.
• User ID for whom the application using the connection is performing work. The user ID may be different than the user ID that was used to establish the connection.
• Host name of the client on which the application using the connection is running.
• Product name and version of the driver on the client.
• Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID.

For DB2 V9.5 for Linux/UNIX/Windows and DB2 for z/OS, this information can feed directly into the Workload Manager (WLM) for workload management and monitoring purposes. See DB2 Workload Manager (WLM) Attributes for more information about using the WLM.