Client info properties support by the IBM Data Server Driver for JDBC and SQLJ
JDBC 4.0 includes client info properties, which contain information about a connection to a data source. The DatabaseMetaData.getClientInfoProperties method returns a list of client info properties that the IBM Data Server Driver for JDBC and SQLJ supports.
- NAME
- MAX_LEN
- DEFAULT_VALUE
- DESCRIPTION
Client info properties support for Db2 on Linux, UNIX, and Windows systems and Db2 for IBM i
The following table lists the client info property values that the IBM Data Server Driver for JDBC and SQLJ returns for Db2® on Linux®, UNIX, and Windows systems and for Db2 for IBM i.
NAME | MAX_LEN (bytes) | DEFAULT_VALUE | DESCRIPTION |
---|---|---|---|
ClientAccountingInformation | 255 | Empty string | The value of the accounting string from the client information that is specified for the connection. This value is stored in Db2 special register CURRENT CLIENT_ACCTNG. |
ApplicationName | 255 | Empty string | The name of the application that is currently using the connection. This value is stored in Db2 special register CURRENT CLIENT_APPLNAME. |
ClientUser | 255 | Empty string | The name of the user on whose behalf the application that is using the connection is running. This value is stored in Db2 special register CURRENT CLIENT_USERID. |
ClientHostname | 255 |
Starting with version 3.68 or 4.18 of the IBM Data Server Driver for JDBC and SQLJ, if ClientHostname is set to any value other than an IP address, no value is sent to the data server. |
The host name of the computer on which the application that is using the connection is running. This value is stored in Db2 special register CURRENT CLIENT_WRKSTNNAME. |
Client info properties support for IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to Db2 for z/OS
The following table lists the client info property values that the IBM Data Server Driver for JDBC and SQLJ returns for Db2 for z/OS® when the connection uses type 4 connectivity.
NAME | MAX_LEN (bytes) | DEFAULT_VALUE | DESCRIPTION |
---|---|---|---|
ClientAccountingInformation | 255 | A string of the form JCCversionclient-ip, where version is the driver version, and client-ip is the IP address of the client. | The value of the accounting string from the client information that is specified for the connection. This value is stored in Db2 special register CURRENT CLIENT_ACCTNG. |
ApplicationName | 255 | The string "db2jcc_application". | The name of the application that is currently using the connection. This value is stored in Db2 special register CURRENT CLIENT_APPLNAME.1 |
ClientCorrelationToken | 255 | An LUWID (logical unit of work ID) that the data server generates. | A unique value that allows you to correlate your business processes across the enterprise. This value is stored in Db2 special register CURRENT CLIENT_CORR_TOKEN. The client correlation token value is available in the accounting correlation header record of a Db2 trace, and in the -DISPLAY THREAD command output. |
ClientUser | 128 | The user ID that was specified when the connection was established. | The name of the user on whose behalf the application that is using the connection is running. This value is stored in Db2 special register CURRENT CLIENT_USERID.2 |
ClientHostname | 255 | Before version 3.68 or 4.18 of the IBM Data Server Driver for JDBC and
SQLJ The string "db2jcc_local". For version 3.68 or 4.18, or later of the IBM Data Server Driver for JDBC and SQLJ, if ClientHostname is set to any value other than an IP address, no value is sent to the data server. |
The host name of the computer on which the application that is using the connection is running. This value is stored in Db2 special register CURRENT CLIENT_WRKSTNNAME. |
Notes:
|
- If the driver sends a Connection.setClientInfo method as a DDM EXCSQLIMM command, the property value takes effect immediately after the data server processes it.
- If the driver sends a Connection.setClientInfo method as a DDM EXCSQLSET command, the property value takes effect in the next transaction on the connection. The data server processes the command prior to the first SQL statement that it executes after a COMMIT.
Client info properties support for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS
The following table lists the client info property values that the IBM Data Server Driver for JDBC and SQLJ returns for Db2 for z/OS when the connection uses type 2 connectivity.
NAME | MAX_LEN (bytes) | DEFAULT_VALUE | DESCRIPTION |
---|---|---|---|
ClientAccountingInformation | 255 | Empty string. | The value of the accounting string from the client information that is specified for the connection. This value is stored in Db2 special register CURRENT CLIENT_ACCTNG. |
ApplicationName | 255 | The string "db2jcc_application". | The name of the application that is currently using the connection. This value is stored in Db2 special register CURRENT CLIENT_APPLNAME.1 |
ClientCorrelationToken | 255 | An LUWID (Logical Unit of Work ID) that the data server generates. | A unique value that allows you to correlate your business processes across the enterprise. This value is stored in Db2 special register CURRENT CLIENT_CORR_TOKEN. The client correlation token value is available in the accounting correlation header record of a Db2 trace, and in the -DISPLAY THREAD command output. |
ClientUser | 128 | The user ID that was specified for the connection. If no user ID was specified, the RACF® user ID is used. | The name of the user on whose behalf the application that is using the connection is running. This value is stored in Db2 special register CURRENT CLIENT_USERID.2 |
ClientHostname | 255 | The string "RRSAF". For version 3.68 or 4.18, or later of the IBM Data Server Driver for JDBC and SQLJ, if ClientHostname is set to any value other than an IP address, no value is sent to the data server. |
The host name of the computer on which the application that is using the connection is running. This value is stored in Db2 special register CURRENT CLIENT_WRKSTNNAME. |
Notes:
|
Client info properties support for IBM Informix
The following table lists the client info property values that the IBM Data Server Driver for JDBC and SQLJ returns for IBM Informix®
NAME | MAX_LEN (bytes) | DEFAULT_VALUE | DESCRIPTION |
---|---|---|---|
ClientAccountingInformation | 199 | Empty string | The value of the accounting string from the client information that is specified for the connection. |
ApplicationName | 20 | Empty string | The name of the application that is currently using the connection. |
ClientUser | 1024 | Empty string | The name of the user on whose behalf the application that is using the connection is running. |
ClientHostname | 20 | The host name of the local host. For versions of the IBM Data Server Driver for JDBC and SQLJ starting with 4.18 or 3.68, if ClientHostname is set to any value other than an IP address, no value is sent to the data server. |
The host name of the computer on which the application that is using the connection is running. |