The Sybase monitor does the following:
- determines if the database is responding on the standard port
- sends Sybase/Transact-SQL scripts to the database for processing
The Transact-SQL scripts can be very basic SQL statements, such as:
sphelp_db sampledb1; exit (select 1);
The scripts can also be more complex statements that involve functions and other data processing.
Configuring Sybase Monitors
To configure Sybase monitors, do the following:
- In the Sybase monitor template, complete the monitor information fields.
- To learn how to configure monitor information fields, see Monitor Identification.
- Complete the following fields:
The number of the port number on which the database is listening. The default is 5000.
- Port Check (Optional)
Select this option to open a socket connection that determines whether the database is listening on the defined port.
The user name that is required to login to the database.
The password that is required to login to the database.
The name of the Sybase database to which you want to connect.
Click the Script checkbox and then type or copy the script that you want Uptime Infrastructure Monitor to against the database into this text box. Use this option if you do not have access to the file system on the Monitoring Station or if your script is short or does not regularly change.
Click the Script File check box and then enter the full path on the Monitoring Station to the script that this monitor runs against the database.
If you configured your database to allow logins without a user name and password and you specify the script file but no login information, the script fails and an error message appears on the Global Scan dashboard. The script runs if you have configured your database to allow logins without a user name and password.
- Match (Regular Expression)
Enter a regular expression that you want to match against the string returned from the database. If the string matches, the status is OK. Otherwise, the status is Critical.
- Response Time
Enter the Warning and Critical Response Time thresholds. For more information, see Configuring Warning and Critical Thresholds.
- Click the Save for Graphing checkbox to save the data for a metric to the DataStore, which can be used to generate a report or graph.
- Complete the following settings:
- Timing Settings (see Adding Monitor Timing Settings Information for more information)
- Alert Settings (see Monitor Alert Settings for more information)
- Monitoring Period settings (see Monitor Timing Settings for more information)
- Alert Profile settings (see Alert Profiles for more information)
- Action Profile settings (see Action Profiles for more information)
- Click Finish.