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.
Note: Oracle allows you to store additional client information including the action associated with the current module, identifying information about the client, and the name of the current module.
Note: 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. See DB2 Workload Manager (WLM) for more information about using the WLM.

Refer to Client information in the Progress DataDirect for JDBC Drivers Reference for more information.