DB2 Version 9.7 for Linux, UNIX, and Windows

ClientWrkStnName CLI/ODBC configuration keyword

Allows a CLI application to set the client workstation name that is sent to a database through DB2 Connect™ or DB2® database products. Applications that do not specify the client workstation name by default can use this keyword to provide this information.

db2cli.ini keyword syntax:
ClientWrkStnName = workstation name
Default setting:
In DB2 Version 9.7 Fix pack 6 and later fix packs, if the ClientWrkStnName keyword is not specified, a default value that consists of the host name is used. The host name is obtained by calling the gethostname() function. If the host name is not configured or an error is encountered during the gethostname() function call, no value for theClientWrkStnName keyword is sent to the server.
Applicable when:
Connected to a database using DB2 Connect or DB2 for Linux, UNIX, and Windows
Equivalent environment or connection attribute:
SQL_ATTR_INFO_WRKSTNNAME
Usage notes:
 
Note the following conditions:
  • Some servers might not be able to handle the entire length of the value and might truncate it.
  • DB2 for z/OS® and OS/390® servers support a length of up to 18 characters.
  • In DB2 Version 9.7 Fix Pack 6 and later fix packs, CLI applications can set the ClientWrkStnName keyword on DB2 for i V6R1 and later servers. DB2 for i servers support a length of up to 255 characters.
  • To ensure that the data is converted correctly when transmitted to a host system, use only the characters A - Z and 0 - 9 and the underscore (_) or period (.).