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.