This section describes the tasks to be performed to configure a Sybase server for detail monitoring.
Perform these steps only once in a Sybase cluster.
To configure Sybase for detail monitoring
# startserver -f ./$SYBASE/$SYBASE_ASE/install/RUN_server_name
# isql -Usa -SSYBASE_SERVER_NAME
Enter the administrator password when prompted to do so.
# use master # go
# sp_addlogin user_name, password # go
The detail monitor script should use this account to make transactions on the database.
# create database database_name # go
The detail monitor script should make transactions on this database.
# sp_dboption database_name, "trunc log on chkpt", true # go
# use database_name # go
# sp_adduser user_name # go
# setuser "user_name" # go
# create table table_name (lastupd datetime) # go
The detail monitor script should make transactions on this table.
If you use the SqlTest.pl for detail monitoring, make sure you create a table with a lastupd field of type datetime.
# insert into table_name (lastupd) values (getdate()) # go
# exit
More Information