Progress
Installation and Configuration Guide
Version 9
for Windows


Using the Progress License File

Progress creates a license file that records license-related information about Progress 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 Progress encounters an error while trying to open or write to the license file, the error is recorded in the database .lg file and no more entries are written to the license (.lic) file.

Reading the 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
  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/01 9:00 25 18 23 11 17 20 11 1 5 0 

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

Maintaining the License File

The database or system administrator should consider archiving 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.

Creating a Usage Report

To produce a report of license-related information about current Progress database users, run the licrpt.p procedure file. The report generator input screen 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/01 8-17      100     20       0      0    10.      0      0     0.
|
| 4/13/01 8-17      100     20       0     18    19.      0      0     0.
|
| 4/16/01 8-17      100     23       0     17    20.      0      0     0.
|
| 4/20/01 8-17      100     33       0     17    25.      0      0     0.
|
| 4/24/01 8-17      100     32       0     26    29.      0      0     0.
|
| 4/26/01 8-17      100     26       0     17    22.      0      0     0. 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095