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 for z/OS servers, IBM Informix database server, or Db2 for IBM 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.
CLI applications can set the ProgamID keyword on Db2 for IBM i V6R1 and later servers. Db2 for IBM 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.