Storing client information
- Last Updated: April 20, 2022
- 1 minute read
- DataDirect Connectors
- ODBC
- Aha! 8.0
- Amazon Redshift 8.0
- Apache Cassandra 8.0
- Apache Hive 8.0
- Apache Spark SQL 8.0
- Autonomous Rest Connector 8.0
- Cloudera Impala 7.1
- dBase 7.1
- + 24
Your application can store client information associated with a connection. The following table shows the driver connection options that your application can use to store client information and where that client information is stored for each database. See the specific driver chapters for a description of each option.
| Option | Description | Database | Location |
|---|---|---|---|
| Accounting Info | Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID | DB2 | CURRENT CLIENT_ACCTNG register (DB2 for Linux/UNIX/Windows, Db2 for i, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT ACCTNG register (DB2 for z/OS). |
| Oracle | CLIENT_INFO value in the V$SESSION table. | ||
| Action | The current action within the current module. | Oracle | ACTION value in the V$SESSION table. |
| Application Name | Name of the application currently using the connection | DB2 | CURRENT CLIENT_APPLNAME register (DB2 for Linux/UNIX/Windows, Db2 for i, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT APPLNAME register (DB2 for z/OS). For DB2 for Linux/UNIX/Windows, this value is also stored in the APPL_NAME value in the SYSIBMADM.APPLICATIONS table. |
| Oracle | CLIENT_IDENTIFIER attribute. In addition, this value is also stored in the PROGRAM value in the V$SESSION table. | ||
| Client Host Name | Host name of the client on which the application using the connection is running | DB2 | CURRENT CLIENT_WRKSTNNAME register (DB2 for Linux/UNIX/Windows, Db2 for i, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT WRKSTNNAME register (DB2 for z/OS). |
| Oracle | MACHINE value in the V$SESSION table. | ||
| Client ID | Additional information about the client | Oracle | CLIENT_IDENTIFIER value in the V$SESSION table. |
| Client User | User ID for whom the application using the connection is performing work | DB2 | CURRENT CLIENT_USERID register (DB2 for Linux/UNIX/Windows, Db2 for i, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT USERID register (DB2 for z/OS). |
| Oracle | OSUSER value in the V$SESSION table. | ||
| Module | The name of a stored procedure or the name of the application | Oracle | MODULE value in the V$SESSION table. |
| Program ID | Product name and version of the driver on the client | DB2 | CLIENT_PRDID value. For DB2 for Linux/UNIX/Windows, the CLIENT_PRDID value is located in the SYSIBMADM.APPLICATIONS table. |
| Oracle | PROCESS value in the V$SESSION table. |