Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSGROUP system view Next Page

SYSHISTORY system view


Each row in the SYSHISTORY system view records a system operation on the database, such as a database start, a database calibration, and so on. The underlying system table for this view is ISYSHISTORY.

Columns
Column name Column type Column constraint
operation CHAR(128) NOT NULL
object_idUNSIGNED INTNOT NULL
sub_operationCHAR(128)NOT NULL
version CHAR(128) NOT NULL
platform CHAR(128) NOT NULL
first_time TIMESTAMP NOT NULL
last_time TIMESTAMP NOT NULL
details LONG VARCHAR

operation    The type of operation performed on the database file. The operation must be one of the following values:

object_id    For any operation other than DTT and LAST_DTT, the value in this column will be 0. For DTT and LAST_DTT operations, this is the file_id of the dbspace as defined in the SYSFILE system view.

sub_operation    For any operation other than DTT and LAST_DTT, the value in this column will be a set of empty single quotes ("). For DTT and LAST_DTT operations, this column contains the type of sub-operation performed on the dbspace. Values include:

version    The version and build number of the database server used to carry out the operation.

platform    The operating system on which the operation was carried out.

first_time    The date and time the database was first started on a particular operating system with a particular version of the software.

last_time    The most recent date and time the database was started on a particular operating system with a particular version of the software.

details    This column stores information such as command line options used to start the database server or the capability bits enabled for the database. This information is for use by technical support.

Constraints on underlying system table

PRIMARY KEY (operation, object_id, version, platform)