Property | Description | Database | Location |
AccountingInfo | 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 and DB2 for i) |
Informix | Local cache | ||
MySQL | Local cache | ||
Oracle | CLIENT_INFO column in the V$SESSION table | ||
PostgreSQL | Local cache | ||
Progress OpenEdge | N/A | ||
Microsoft Windows Azure SQL Database | N/A | ||
Microsoft SQL Server | Local cache | ||
Apache Hive | Local cache | ||
Greenplum | Local cache | ||
Sybase | Local cache | ||
Action | The current action (Select, Insert, Update, or Delete, for example) within the current module | DB2 | N/A |
Informix | N/A | ||
MySQL | N/A | ||
Oracle | CLIENT_INFO column in the V$SESSION table | ||
PostgreSQL | N/A | ||
Progress OpenEdge | N/A | ||
Microsoft Windows Azure SQL Database | N/A | ||
Microsoft SQL Server | N/A | ||
Sybase | N/A | ||
Apache Hive | NA | ||
Greenplum | N/A | ||
ApplicationName | 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 and DB2 for i). For DB2 V9.1 and higher for Linux/UNIX/Windows, it is also stored in the APPL_NAME column in the SYSIBMADM.APPLICATIONS table. |
Informix | Local cache | ||
MySQL | 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 | ||
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. | ||
Sybase | clientapplname and program_name column in sysprocesses table | ||
Apache Hive | Local cache | ||
Greenplum | Local cache | ||
ClientHostName | 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 and DB2 for i) |
Informix | Local cache | ||
MySQL | Local cache | ||
Oracle | MACHINE column in the V$SESSION table | ||
PostgreSQL | Local cache | ||
Progress OpenEdge | N/A | ||
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. | ||
Sybase | clienthostname and hostname column in the sysprocesses table | ||
Apache Hive | Local cache | ||
Greenplum | Local cache | ||
ClientID | Additional information about the client to be stored in the database | DB2 | N/A |
Informix | 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 | ||
Microsoft Windows Azure SQL Database | N/A | ||
Microsoft SQL Server | N/A | ||
Sybase | N/A | ||
Apache Hive | N/A | ||
Greenplum | N/A | ||
ClientUser | 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 and DB2 for i) |
Informix | Local cache | ||
MySQL | Local cache | ||
Oracle | OSUSER column in the V$SESSION table | ||
PostgreSQL | Local cache | ||
Progress OpenEdge | N/A | ||
Microsoft Windows Azure SQL Database | N/A | ||
Microsoft SQL Server | Local cache | ||
Sybase | clientname column in sysprocesses table | ||
Apache Hive | Local cache | ||
Greenplum | Local cache | ||
ProgramID | Driver name and version on the client | DB2 | CLIENT_PRDID value. For DB2 V9.1 and higher for Linux/UNIX/Windows, it is located in the SYSIBMADM.APPLICATIONS table. |
Informix | Local cache | ||
MySQL | Local cache | ||
Oracle | PROCESS column in the V$SESSION table | ||
PostgreSQL | Local cache | ||
Progress OpenEdge | N/A | ||
Microsoft Windows Azure SQL Database | N/A | ||
Microsoft SQL Server | For Microsoft SQL Server 2000 and higher, the hostprocess column in the sysprocesses table. For Microsoft SQL Server 7, local cache. | ||
Sybase | hostprocess column in the sysprocesses table | ||
Apache Hive | Local cache | ||
Greenplum | Local cache | ||
Module | The module name to be stored in the database | DB2 | N/A |
Informix | N/A | ||
MySQL | N/A | ||
Oracle | The MODULE column in the V$SESSION table | ||
PostgreSQL | N/A | ||
Progress OpenEdge | N/A | ||
Microsoft Windows Azure SQL Database | N/A | ||
Microsoft SQL Server | N/A | ||
Sybase | N/A | ||
Apache Hive | N/A | ||
Greenplum | N/A |