Logging the number of user licenses

The syblicenseslog system table is created in the master database when you install or upgrade Adaptive Server. The License Use Monitor updates the columns in syblicenseslog at the end of each 24-hour period, as shown in Table 10-13.

Table 10-13: Columns in syblicenseslog table

Column

Description

status

-1 – Housekeeper unable to monitor licenses.

0 – Number of licenses not exceeded.

1 – Number of licensees exceeded.

logtime

Date and time the log information was inserted.

maxlicenses

Maximum number of licenses used during the previous 24 hours.

syblicenseslog looks similar to this:

status logdate                    maxlicenses
------ -------------------------- -----------
     0        Jul 17 1998 11:43AM         123
     0        Jul 18 1998 11:47AM         147
     1        Jul 19 1998 11:51AM         154
     0        Jul 20 1998 11:55AM         142
       0        Jul 21 1998 11:58AM          138
       0        Jul 21 1998  3:14PM          133

In this example, the number of user licenses used exceeded the limit on July 19, 1998.

If Adaptive Server is shut down, License Manager updates syblicenseslog with the current maximum number of licenses used. Adaptive Server starts a new 24-hour monitoring period when it is restarted.

The second row for July 21, 1998 was caused by a shutdown and restart of the server.