Sybase Query monitors

Specify a tag value to search or group the objects. You can enter multiple name-value pairs, text, or include both (name-value pair and text). This gives you the option to group objects in different forms. Click the + icon to select a default tag class. The Enter Tag Details screen opens. Select Tag Class from the drop-down list and enter a tag value. Click Add to append tag class and value. Click Finish.

• Editing a Tag Value on the Enter Tag Details screen: Select a tag value and click Edit. Make the necessary modifications in the Tag Value text box and click Set to add the changes.
• Deleting a Tag Value on the Enter Tag Details screen: Select a tag value and click Delete. Click Yes to delete the tag value.

Specify the query to execute on each poll.

The query defines the SQL statement for monitor operations. This query should use a simple read-only SQL statement such as SELECT (example, select count (*) from dual) or UPDATE. Complex queries like Joins and PL/SQL are not supported. The monitor expects an integer value from this query, so it is best to cast the returned value as an integer using the COUNT statement. The maximum data value that can be stored for this monitor is 2^31-1. You can also specify a file, which contains the SQL query using the following syntax:
file: <filepath> (example, file:c:\temp\test.sql in Windows or file:/tmp/test.sql in UNIX).

While creating the Sybase Query monitor, you must specify the name of the database to be queried using the SQL statement as an input attribute.

To obtain the database name:

1. Start interactive SQL and open the Connection window.
2. On the Identification tab of the window, specify the User ID and password to access the database.
3. To get the database name, go to Database and click Find. This may take some time.

A list with three columns is displayed. The database name, IP address, and port to be used as input attributes for creating the monitor can be taken from the list.

To create the Sybase Query monitor, you must specify the User ID and corresponding password to access the database. The user you specify must have appropriate access rights over the database. To create a user, run the following SQL statement:

GRANT CONNECT TO <USER ID> IDENTIFIED BY <PASSWORD>

To change the password associated with a user, run the following SQL statement:

GRANT CONNECT TO <USER ID> IDENTIFIED BY <NEW PASSWORD>

Monitors can be created even when the target application/device is not running. Agent must be upgraded to 7.1 for creation of monitor using skip validation. This monitor enables forceful creation when the monitored target is not reachable or specified inputs are wrong. Click Yes on the Skip Validation confirmation message to forcefully create a monitor. Clicking No will fail the monitor creation. Forcefully creating the monitor when target is not reachable or with invalid input(s) may cause Availability to be set to 0.

No additional configuration requirements for this monitor. Maintain the default configuration of BMC ProactiveNet.