The monitoring tables are not created by default, but must be created using the installmontables script. You can find this script in the $RAP30/RAPCache/ASE-15_0/scripts directory on UNIX or LINUX, or %RAP30\RAPCache\ASE-15_0\scripts directory on Windows.
Add the loopback server to sysservers:
sp_addserver loopback, NULL, <srvnetname>
Grant the mon_role
role
to sa_role
:
sp_role 'grant', mon_role, sa_role
Map the sa
login
as well as the login of the DBA with mon_role
:
sp_addexternlogin @server="loopback", @loginame="sa",@externname="sa"
Install the monitoring tables with the installmontables script (located in $RAP30/RAPCache/ASE-15_0/scripts):
$SYBASE/$SYBASE_OCS/bin/isql -Usa -P -i $SYBASE/$SYBASE_ASE/scripts/installmontables