Many databases allow applications to store client information 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.
Client information is available in the following DataDirect Connect Series forODBC drivers:
DB2 Wire Protocol
Oracle Wire Protocol
For DB2 V9.5 and higher 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.
For Oracle 11g R2 and higher, this information is managed through the client information feature.
Name of the application currently using the connection.