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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties » Database server property tracking

Viewing all trackable database server property values

View the list of database server property values that can be tracked.

Context

Only database server properties with numeric values can be tracked.

You can find the PropNum of the database server property by running the sa_eng_properties system procedure or by calling the PROPERTY_NUMBER function.

Procedure

Execute the following statement:
SELECT * FROM sa_eng_properties()
WHERE PROPERTY_IS_TRACKABLE( PropNum ) = 1;

Results

The list of database server properties that can be tracked is returned.