ProgramName IBM data server driver configuration keyword
Sets the default client application name to a user-defined name, which is used to identify the application at the server during monitoring.
- Equivalent CLI keyword
- ProgramName
- Equivalent IBM® data server provider for .NET connection string keyword
- ProgramName
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="ProgramName" value="<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:
The ProgramName keyword is used to identify the application by a user-defined string, instead of by the default identifier that the data server assigns. The ProgramName keyword is used to specify the identifier as either a string up to 20 bytes in length or the string PID.
If the ProgramName keyword is set to PID for an application, the application's name consists of the prefix along with the application's process ID and the current active connection handle, as follows:
<prefix><pid>:<connectionHandle#>. The PID setting is useful when you are monitoring application servers that run multiple applications with numerous connections to the same database.When the ProgramName keyword is set to PID, the application prefix is replaced with the value that corresponds to the type of application. For example, "OLEDB" for OLE DB applications, and "ADONET" for .NET applications.