The OpenEdge license you purchase determines how many units are allowed to run your OpenEdge products. You are responsible for making sure users comply with your license agreement. OpenEdge provides reporting capabilities to help you ensure compliance with your license agreement.

About the OpenEdge database license file

OpenEdge also creates a separate license file that records license-related information about OpenEdge database users. If the log file does not already exist, the broker creates it and places it in the same directory as the database (.db) file. The broker creates the file in the format databasename.lic, where databasename is the name of the database to which the user connects.

Note: If OpenEdge encounters an error while trying to open or write to the database license file, the error is recorded in the database .lg file and no more entries are written to the license (.lic) file.

Read the database license file

Use a text editor to display the license file contents. The contents appear in the following order:

  1. Current date
  2. Current time
  3. Number of licensed users specified by the configuration file (if -1, unlimited number of users are licensed)
  4. Current number of total connections
  5. Maximum number of total connections
  6. Minimum number of total connections
  7. Current number of interactive connections
  8. Maximum number of interactive connections for the past hour
  9. Minimum number of interactive connections for the past hour
  10. Current number of batch connections
  11. Maximum number of batch connections for the past hour
  12. Minimum number of batch connections for the past hour

For example, the following sample file entry illustrates the log format:


4/26/08 9:00 25 18 23 11 17 20 11 1 5 0

When OpenEdge writes to the license file, the maximum and minimum values are reset for the next hour.

Maintain the database license file

The database or system administrator should consider archiving database license files periodically. In one year, a license file accumulates 8,760 entries. These entries occupy about 440,000 bytes of disk space.

Since the license file must be closed before the administrator archives it, the administrator must first shut down the database. At that point, the license file can be either archived immediately or renamed and archived later.

Create a usage report

To produce a report of database license-related information about current OpenEdge database users, run the licrpt.p procedure file. The report generator input data appears:

Enter Date Range:      To:        Enter Start Time (hours 0 to 23):
Enter Stop Time (hours 0 to 24):
Enter time division (in hours, or 0 for complete range):     
Database Name:

This is a sample output from the licrpt.p procedure file:

                         Database Connection Counts
--------------------------------------------------------------------------
| Date   Period  LcnUsers MaxTot Excptns MinTot AveTot MaxBat MinBat AvBat
|
|------- ------- -------- ------ ------- ------ ------ ------ ------ -----
|
| 4/11/06 8-17      100     20       0      0    10.      0      0     0.
|
| 4/13/06 8-17      100     20       0     18    19.      0      0     0.
|
| 4/16/06 8-17      100     23       0     17    20.      0      0     0.
|
| 4/20/06 8-17      100     33       0     17    25.      0      0     0.
|
| 4/24/06 8-17      100     32       0     26    29.      0      0     0.
|
| 4/26/06 8-17      100     26       0     17    22.      0      0     0.