DB2 Version 9.7 for Linux, UNIX, and Windows

ProgramID CLI/ODBC configuration keyword

Sets the user-defined character string, that associates an application with a connection. When you set the ProgramID keyword, DB2® for z/OS® or IBM® Informix® database server associates this keyword with any statements that are inserted into the dynamic SQL statement cache.

db2cli.ini keyword syntax:: ProgramID = <string>
Default setting:: None
Equivalent connection attribute:: SQL_ATTR_INFO_PROGRAMID
Usage notes:: Restriction: This keyword is supported only for CLI applications accessing DB2 Universal Database for z/OS Version 8 and later, IBM Informix database server, or DB2 for i servers.
When monitoring a CLI application, you can use the ProgramID keyword to identify a statement that was inserted into the dynamic SQL statement cache. You can use the ProgamID keyword to specify an identifier, as a string of up to 80 bytes for connection to DB2 for z/OS, or IBM Informix database server server at the connection and statement level.
In IBM DB2 Version 9.7 Fix Pack 6 and later, CLI applications can set the ProgamID keyword on DB2 for i V6R1 and later servers. DB2 for i servers support up to a length of 255 characters.
If you set the ProgamID keyword, the SQLGetConnectAttr() and SQLGetStatementAttr() APIs return the specified ProgamID keyword value.