Chapter 1: System Tables

syblicenseslog

master database only

Description

syblicenseslog contains one row for each update of the maximum number of licenses used in Adaptive Server per 24-hour period. syblicenseslog is updated every 24 hours. If Adaptive Server is shut down at any time, License Use Manager logs the number of licenses currently being used in syblicenseslog before the shutdown is complete. The 24-hour period restarts when you start Adaptive Server.

syblicenseslog is not a system table. Its type is “U” and its object ID is greater than 255.

Columns

The columns for syblicenseslogs are:

Name	Datatype	Description
status	smallint	Status of the maximum number of licenses used; one of the following: 0 = number of licenses not exceeded 1 = number of licenses is exceeded -1 = housekeeper is unable to monitor number of licenses
logtime	datetime	Date and time the log was written
maxlicenses	int	Maximum number of licenses used during the 24-hour period

Name

Datatype

Description

status

smallint

Status of the maximum number of licenses used; one of the following:

0 = number of licenses not exceeded
1 = number of licenses is exceeded
-1 = housekeeper is unable to monitor number of licenses

logtime

datetime

Date and time the log was written

maxlicenses

int

Maximum number of licenses used during the 24-hour period

View this book as PDF