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 ODBC drivers:

  • DB2 Wire Protocol
  • Oracle Wire Protocol

For Oracle 11g R2 and higher, this information is managed through the client information feature.