Configuring database server property tracking

Configure your database server to track the values of numeric database server properties.

Context

Only database server properties with numeric values can be tracked.

Procedure

Choose one or both of the following options:

Option	Action
Specify database server properties to be tracked for the database server	When starting the database server, use the -phl and -phs database server options to turn on history tracking for a list of specified database server properties and to specify the maximum amount of memory to use for tracking property history. For example, run the following command: `dbsrv17 -n myserver -phl ProcessCPUSystem, ProcessCPUUser -phs 250K` If the database server is already running, then use the sa_server_option system procedure to configure property tracking for the database server. For example, execute the following statement: `CALL sa_server_option( 'PropertyHistoryList,ProcessCPUSystem,ProcessCPUUser,PropertyHistorySize,250K' );`
Specify database server properties to be tracked for the database	Use the sa_db_option system procedure to configure property tracking of database server properties for the database. For example, execute the following statement: `CALL sa_db_option( 'PropertyHistoryList,ProcessCPUSystem,ProcessCPUUser' );`

Option

Action

Specify database server properties to be tracked for the database server

When starting the database server, use the -phl and -phs database server options to turn on history tracking for a list of specified database server properties and to specify the maximum amount of memory to use for tracking property history. For example, run the following command:
dbsrv17 -n myserver -phl ProcessCPUSystem, ProcessCPUUser -phs 250K
If the database server is already running, then use the sa_server_option system procedure to configure property tracking for the database server. For example, execute the following statement:
CALL sa_server_option( 'PropertyHistoryList,ProcessCPUSystem,ProcessCPUUser,PropertyHistorySize,250K' );

Specify database server properties to be tracked for the database

Use the sa_db_option system procedure to configure property tracking of database server properties for the database. For example, execute the following statement:

CALL sa_db_option( 'PropertyHistoryList,ProcessCPUSystem,ProcessCPUUser' );

Results

The values of the specified database server properties are tracked for either the specified amount of time or until the specified maximum amount of memory has been reached.