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.
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.
