skip to main content
Part 1: Getting Started : Advanced Features : Using Client Information : Storing Client Information
  
Storing Client Information
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.
Table 6. Database Locations for Storing Client Information
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) 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) or CLIENT APPLNAME register (DB2 for z/OS). For DB2 V9.1 and higher 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) 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) 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 V9.1 and higher for Linux/UNIX/Windows, the CLIENT_PRDID value is located in the SYSIBMADM.APPLICATIONS table.
Oracle
PROCESS value in the V$SESSION table.