DB2 Version 9.7 for Linux, UNIX, and Windows

ProgramName CLI/ODBC configuration keyword

Sets the default client application name to a user-defined name which is used to identify the application at the server when monitoring.

db2cli.ini keyword syntax:: ProgramName = <string> | PID
Default setting:: The application is identified by the client. By default, the first 20 bytes of the executable name is used.
Equivalent connection attribute:: SQL_ATTR_INFO_PROGRAMNAME
Usage notes:

When monitoring a CLI application, it may be useful to identify the application by a user-defined string, instead of by the default identifier that DB2® assigns. ProgramName allows the user to specify the identifier as either a string up to 20 bytes in length or the string "PID" (without the quotation marks).

If ProgramName is set to "PID" for a CLI application, the application's name will consist of the prefix "CLI" along with the application's process ID and the current active connection handle, as follows: CLI<pid>:<connectionHandle#>. The "PID" setting is useful when monitoring application servers that run multiple applications with numerous connections to the same database.

(When the ProgramName keyword is set to "PID" for other types of applications, the "CLI" prefix is replaced with the following values corresponding to the type of application: "JDBC" for JDBC applications, "OLEDB" for OLE DB applications, and "ADONET" for .NET applications.)