A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: System Tables

syblicenseslog

The syblicenseslog table is a system table of ASE. Technically speaking, syblicenseslog is not a real system table, but contains license information. This license information is used and updated when ASE is being shut down. As syblicenseslog is not a system table, its object type is "U", i.e. a user object and its object id is larger than 255. The table syblicenseslog is stored in the master database.

Columns of the syblicenseslog Table

Column: status

The column status is of the datatype smallint. Status represents the maximum number of licenses in use. Possible values for status are:
0: The maximum number of licenses available has not been exceeded.
1: The maximum number of available licenses has exceeded.
-1: The housekeeper is not able to determine the current status.

Column: logtime

The column logtime is of the datatype datetime. It contains the time and date of the logged information.

Column: maxlicenses

The column maxlicenses is of the datatype int. It contains the maximum number of licenses used in the last 24 hours.