Quick Beginnings

Counting Concurrent Users

DB2 Enterprise Edition allows an unlimited number of users to connect to the server.

DB2 Workgroup Edition and DB2 Connect Enterprise Edition products are priced per user. If you need to support more users than currently entitled, you must acquire entitlements for additional users. An entitlement for additional users does not require a new license key. It is up to you, the purchaser of the product, to ensure that you have sufficient entitlements for the number of users.

To assist you in tracking the number of concurrent users connecting to a DB2 Workgroup Edition server or a DB2 Connect Enterprise Edition server, DB2 uses the License Use Runtime client. It provides a way to monitor the number of concurrent users on your system, but it does not enforce the maximum limit; however, the runtime client will log an entry in the db2diag.log file each time the number of entitlements that you are licensed to is exceeded.

To update the number of concurrent users you are entitled to support, use the Nodelock Administration Tool (NAT):

This tool is available only on AIX operating systems.

1. Log in as root.

2. If you are using NAT Version 3.0, append directory "/var/ifor" to the PATH environment variable:

   For Bourne or Korn shell:

   PATH=$PATH:/var/ifor ; export PATH

   For C shell:

   setenv PATH "${PATH}:/var/ifor"

3. Use the /var/ifor/i4net command to invoke NAT.

4. Select the product that you want to monitor the number of concurrent users for.

5. Update the Concurrent licenses field.

Check the db2diag.log file (located in the INSTHOME/sqllib/db2dump directory, where INSTHOME is the home directory of the instance) to see if you have exceeded the maximum number of concurrent users that you are entitled to support. For example, an entry in the db2diag.log file might look like this:

 SQL8009W The number of concurrent users of the DB2 Server
          product has exceeded the defined entitlement of
          "5".  Concurrent user count is "6".    

For information on the db2diag.log file, refer to the Troubleshooting Guide .

To acquire additional entitlements, you must purchase additional licenses from IBM or an IBM dealer. After you acquire the additional entitlements, use the NAT tool to updated the number of concurrent users allowed.

[ DB2 List of Books | Search the DB2 Books ]