DB2 10.5 for Linux, UNIX, and Windows

DB2Connection.ClientWorkStation property

Gets or sets the client workstation name.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax

[Visual Basic]
Public Property ClientWorkStation As String
[C#]
public string ClientWorkStation {get; set;}
[C++]
public: __property String* get_ClientWorkStation();
public: __property void set_ClientWorkStation(String*);
[JScript]
public function get ClientWorkStation() : String;
public function set ClientWorkStation(String);

Property value

The IBM® Data Server Provider for .NET has limit of 255 characters for the ClientWorkStation property.

Database servers enforce different limitation in the length of the value and can truncate it. Note the following conditions:

DB2® for z/OS® Version 11 servers in new function mode (NFM) support a length of up to 255 characters.
DB2 for z/OS Version 10 and earlier servers support a length of up to 18 characters.
DB2 for i V6R1 and later servers support a length of up to 255 characters.

To ensure that the data is converted correctly when transmitted to DB2 for z/OS Version 9 and earlier servers, use only the characters A-Z and 0-9 and the underscore (_) or period (.).

If you do not specify the ClientWorkStation property, the default value that consists of the host name is used. If you do not configure the host name or you encounter an error during the host name retrieval, an empty string ("") value for the ClientWorkStation property is sent to the server.

The ClientWorkStation property value in the DB2Connection class is stored in the DB2 special register (CURRENT CLIENT_WRKSTNNAME).

The ClientWorkStation property must be set before the start of a transaction. Changes to the ClientWorkStation property after the start of a transaction do not take effect until the start of the next transaction.

You can obtain the default value that is set by the client on the DB2 for z/OS server when the following conditions are met:

You have not explicitly set the client workstation name registry value.
The enableDefaultClientInfo IBM data server driver configuration keyword is set to True.

The default value is the host name of the client.