DB2 Connect User's Guide

Setting the Accounting String

The default accounting string is set by the DB2 Connect workstation's dft_account_str configuration parameter. This default mechanism is useful for database clients that do not have the capability to forward an accounting string to DB2 Connect (for example, applications developed prior to Version 2 products).

There are two ways for client applications to override the default accounting string set at the DB2 Connect server:

Using the Set Accounting String API: sqlesact()
The SQLESACT() API is called before the application connects to a database. You should use this method because:
- Calling an API does not incur the cost of reading a registry value.
- You do not need to call this API again unless you want to use a new accounting string for future connect requests. If you are using the registry value, you need to end the application process, redefine DB2ACCOUNT, and then restart the process.
Refer to the Administrative API Reference for details on using this API.
Using the DB2ACCOUNT registry value at the client workstation.
If the sqlesact() API is not called prior to the first database connect request, the DB2ACCOUNT registry value is read. The accounting string is used for all subsequent database connect requests.

Note:

When defining the accounting string, you should observe the following rules:

Use the characters A-Z, 0-9, or '_' (underscore).
Limit the accounting string to 199 bytes--longer strings are truncated.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]