Sybase Query monitors

 Availability (%)  

 Availability of the monitored database. If connection and data transfer are successful, system returns 100%, otherwise it returns 0.  

 Connect Time (ms)  

 Time required by the database server to process login requests.  

 Response Time (ms)  

 Time required by the database server to execute a user-defined query (such as Select, Insert, Update) and respond. Response time includes time of login request (start) and time of response to query (end).  

 Value (#)

 Value returned as response after executing the user query.

Input fields on the Configuration tab   

Instance Name  

 Specify a name for the monitor instance. This is displayed on folders, graphs, lists, etc. 

 Tag  

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.

Source Agent  

 Select the name/IP address of the Infrastructure Management agent to host the new monitor instance.

Target Device  

 Specify the name/IP address of the machine hosting the Sybase. Infrastructure Management recommends that the target IP and the IP address of the device where the monitor is being created be the same. For detailed steps on obtaining basic database specifications, see Additional configuration and setup issues. Specifying Host Name will not resolve to IP address and DNS lookup will be done in every statistics poll.

 Port  

 Specify the TCP Control port. Default port is 4100. For detailed steps on obtaining the port number, see Additional configuration and setup issues. The default port 4100 corresponds to Sybase ASE (Adaptive Server Enterprise). For Sybase ASA (Adaptive Server Anywhere), default port is 2638. Please change accordingly.

Database Name

Specify name of the database to be queried using the SQL statement. For detailed steps on obtaining basic database specifications, see Additional configuration and setup issues. Example, storm_marketing1, where marketing1 is the name of the host machine.

User ID

Specify the user ID to access the database. Ensure that the user has appropriate access rights. For detailed information on how to create a user ID with password, see Additional configuration and setup issues.

Password

Specify the password corresponding to the user name.

SQL Statement

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).

System-populated fields

Monitor Version

Version of the installed Infrastructure Management monitor.

Control tab

Collect Data

Select/clear check box to enable/disable data collection for the monitored component. By default, data collection is enabled (check box selected).

Retry Count

Specify the number of consecutive unsuccessful attempts for recording Zero availability for the poll. Default is 3.

Retry Delay

Specify the time interval between two consecutive attempts of a single poll. Default is 20 seconds.

Statistics Poll Interval

Specify the time interval between two consecutive Statistical data polls. Default is 5 minutes.

Statistics Poll Timeout

Specify the time-out period for each poll of statistical data. If no data is available at the end of this interval, system records zero availability and proceeds with the next scheduled poll. Default is 20 seconds.

Group tab

Group Membership

This enables you to add a device and its monitors to one or more groups. Optionally, you may associate the device with a group. A group is used to logically organize the devices and monitors by department, geographic area, or service. Assigning a device to a group also enables the system administrator to restrict or allow access to certain devices. To associate the device with a group, select the group name here.

Obtaining basic database specifications  

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.

 Creating database users and defining passwords  

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:

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

 Skip validation  

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.

 Monitor configuration  

No additional configuration requirements for this monitor. Maintain the default configuration of Infrastructure Management.

 External setup  

No external setup requirements for this monitor.

 External dependencies  

No external dependencies for this monitor.

Infrastructure Management agent dependencies

Infrastructure Management agent installation on the monitored host is not mandatory. Monitor instance can be created on any Infrastructure Management agent.

 Response Time  

Minor  

15  

Above  

500  

Y

ALL  

Availability  

Critical  

0

Below  

100

N

ALL  

 Response Time  

 Event Only  

 10  

 Below  

 0  

 0  

 0  

 5  

 1  

 Hourly  

 Response Time  

 Event Only  

 10  

 Above  

 0  

 50  

 20  

 5  

 0  

 Hourly  

 Availability  

 Event Only  

 10  

 Above  

 0  

 0  

 0  

 5  

 1  

 Hourly  

 Availability  

 Event Only  

 10  

 Below  

 0  

 50  

 0  

 5  

 0  

 Hourly  

 Connect Time  

 Event Only  

 10  

 Below  

 0  

 0  

 0  

 5  

 1  

 Hourly  

Connect Time

Event Only

10

Above

0

50

10

5

0

Hourly