Your application can store client information associated with a connection using any of the following methods:

  • Using the driver connection properties listed in the following table. This table lists the connection properties your application can use to store client information and where that client information is stored for each database. For information about specifying connection properties using a URL or a JDBC data source, refer to the user's guide for your driver
  • Using the following JDBC methods:
    • Connection.setClientInfo(properties)
    • Connection.setClientInfo(property_name, value)

    For more information about these JDBC methods, see "JDBC Support."

  • Using the JDBC extension methods provided in the com.ddtek.jdbc.extensions package. See "JDBC Extensions" for more information about the com.ddtek.jdbc.extensions package.
Table 1. Database Locations for Storing Client Information
Property Description Database Location
AccountingInfo Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID Amazon Redshift Local cache
Apache Hive Local cache
Apache Spark SQL Local cache
Db2 CURRENT CLIENT_ACCTNG register (Db2 for Linux/UNIX/Windows, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT ACCTNG register (Db2 for z/OS and Db2 for i)
Denodo Local cache
Greenplum Local cache
Informix Local cache
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server Local cache
MySQL Local cache
Oracle CLIENT_INFO column in the V$SESSION table
PostgreSQL Local cache
Progress OpenEdge N/A
Sybase Local cache
Action The current action (Select, Insert, Update, or Delete, for example) within the current module Amazon Redshift N/A
Apache Hive N/A
Apache Spark SQL N/A
Db2 N/A
Denodo N/A
Greenplum N/A
Informix N/A
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server N/A
MySQL N/A
Oracle CLIENT_INFO column in the V$SESSION table
PostgreSQL N/A
Progress OpenEdge N/A
Sybase N/A
ApplicationName Name of the application currently using the connection Amazon Redshift Local cache
Apache Hive Local cache
Apache Spark SQL Local cache
Db2 CURRENT CLIENT_APPLNAME register (Db2 for Linux/UNIX/Windows, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT APPLNAME register (Db2 for z/OS and Db2 for i). For Db2 for Linux/UNIX/Windows, it is also stored in the APPL_NAME column in the SYSIBMADM.APPLICATIONS table.
Denodo Local cache
Greenplum Local cache
Informix Local cache
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server For Microsoft SQL Server 2000 and higher, program_name column in the sysprocesses table. For Microsoft SQL Server 7, local cache.
Oracle dbms_session value. In addition, it is also stored in the PROGRAM column in the V$SESSION table.
PostgreSQL Local cache
Progress OpenEdge N/A
Sybase clientapplname and program_name column in sysprocesses table
ClientHostName Host name of the client on which the application using the connection is running Amazon Redshift Local Cache
Apache Hive Local cache
Apache Spark SQL Local cache
Db2 CURRENT CLIENT_WRKSTNNAME register (Db2 for Linux/UNIX/Windows, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT WRKSTNNAME register (Db2 for z/OS and Db2 for i)
Denodo Local cache
Greenplum Local cache
Informix Local cache
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server For Microsoft SQL Server 2000 and higher, hostname column in the sysprocesses table. For Microsoft SQL Server 7, local cache.
MySQL Local cache
Oracle MACHINE column in the V$SESSION table
PostgreSQL Local cache
Progress OpenEdge N/A
Sybase clienthostname and hostname column in the sysprocesses table
ClientID Additional information about the client to be stored in the database Amazon Redshift N/A
Apache Hive N/A
Apache Spark SQL N/A
Db2 N/A
Denodo N/A
Greenplum N/A
Informix N/A
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server N/A
MySQL N/A
Oracle For Oracle9i R1 (9.0.1) and higher, the CLIENT_IDENTIFIER column in the V$SESSION table
PostgreSQL N/A
Progress OpenEdge N/A
ClientUser User ID for whom the application using the connection is performing work Amazon Redshift Local cache
Apache Hive Local cache
Apache Spark SQL Local cache
Db2 CURRENT CLIENT_USERID register (Db2 for Linux/UNIX/Windows, Db2 Hosted, and Db2 Warehouse on Cloud) or CLIENT USERID register (Db2 for z/OS and Db2 for i)
Denodo Local cache
Greenplum Local cache
Informix Local cache
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server Local cache
MySQL Local cache
Oracle OSUSER column in the V$SESSION table
PostgreSQL Local cache
Progress OpenEdge N/A
Sybase clientname column in sysprocesses table
ProgramID Driver name and version on the client Amazon Redshift Local cache
Apache Hive Local cache
Apache Spark SQL Local cache
Db2 CLIENT_PRDID value. For Db2 for Linux/UNIX/Windows, it is located in the SYSIBMADM.APPLICATIONS table.
Denodo Local cache
Greenplum Local cache
Informix Local cache
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server For Microsoft SQL Server 2000 and higher, the hostprocess column in the sysprocesses table.
MySQL Local cache
Oracle PROCESS column in the V$SESSION table
PostgreSQL Local cache
Progress OpenEdge N/A
Sybase hostprocess column in the sysprocesses table
Module The module name to be stored in the database Amazon Redshift N/A
Apache Hive N/A
Apache Spark SQL N/A
Db2 N/A
Denodo N/A
Greenplum N/A
Informix N/A
Microsoft Windows Azure SQL Database N/A
Microsoft SQL Server N/A
MySQL N/A
Oracle The MODULE column in the V$SESSION table
PostgreSQL N/A
Progress OpenEdge N/A
Sybase N/A