Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Sybase

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:
  1. In the Sybase monitor template, complete the monitor information fields.
  2. To learn how to configure monitor information fields, see Monitor Identification.
  3. Complete the following fields:
    • Port
      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.
    • Username
      The user name that is required to login to the database.
    • Password
      The password that is required to login to the database.
    • Database
      The name of the Sybase database to which you want to connect.
    • Script
      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.
    • Script File
      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.

      Info

      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.
  4. 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.
  5. Complete the following settings:
  6. Click Finish.