Remotely accessing and editing monitoring tables

In versions 15.0.2 and later, Sybase provides installmontables as a sample script that describes how to remotely access monitoring tables (you need not run the installmontables script on a server that is directly monitored for Adaptive Server version 15.0.2 and later to create the monitoring tables). Run installmontables to view the instructions for editing. For example:

isql -Usa -Psa_password -Sserver name -i $SYBASE/$SYBASE_ASE/scripts/ installmontables

---x---x-------------------------------------------------------------x---x---
It is no longer necessary to run this script to install the Monitoring Tables.Monitoring Tables are now installed by the installmaster script.
This installmontables script is provided as a sample that can be copied and modified to support remote access of Monitoring Tables. To do so you need to:
1) Replace all instances of @SERVER@ with the name of the remote ASE from which monitoring data is to be obtained. Note that each remote ASE to be monitored must be added to the local ASE's sysservers table using sp_addserver.
2) Create a database with the same name as the remote ASE. This database need only be of the minimum size as these tables do not store any data.
3) Remove this header (i.e. these first 21 lines).
4) Run the script against the local ASE using the isql utility as follows:
    isql -Usa -P<password> -S<server name> -i<script name>
5) Retrieve remote monitoring data. E.g. to obtain monEngine information for an ASE named REMASE you would execute the following SQL:
            use REMASE
            go
            select * from monEngine
            go