The ClientAcctStr keyword is used
to set the client accounting string that is sent to a database. Applications
that do not set the accounting string can use the ClientAcctStr keyword
to provide the client accounting string information.
- db2cli.ini keyword syntax:
- ClientAcctStr = accounting string
- Default setting:
- None
- Applicable when:
- Connected to a database with an IBM® Data
Server product.
- Equivalent environment or connection attribute:
- SQL_ATTR_INFO_ACCTSTR
- Usage notes:
- The CLI driver
has limit of 255 characters for the ClientAcctStr keyword.
Database
servers enforce different limitation in the length of the value and
can truncate it. Note the following conditions:
- DB2® for z/OS® Version
11 servers in new function mode (NFM) support a length of up to 255
characters for the CURRENT CLIENT_ACCTNG special register.
- DB2 for z/OS servers
remove trailing spaces that are specified in the ClientAcctStr keyword
value.
- DB2 for z/OS Version
10 and earlier servers support a length of up to 200 characters.
- CLI applications
can set the ClientAcctStr 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 (.).
For connection to DB2 for z/OS servers,
the ClientAcctStr keyword is replayed upon connection
failover when the automatic client reroute (ACR) feature and the workload
balance (WLB) feature are enabled.