Sybase ASA Intelliscope monitors

Number of users currently connected to the database and engaged in active transactions.

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

Actual data (in bytes) transferred to the database server during client/server communication.

Actual data (in bytes) transferred from the database server during client/server communication.

CPU time utilized by the monitored process expressed as percentage of the total CPU time.

Ratio of requests to read from memory serviced from the cache and the main memory. Number of requests to read from memory serviced from the cache expressed as a percentage of the total requests serviced by the main memory.

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

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.

Select the name/IP address of the BMC ProactiveNet agent to host the new monitor instance.

Specify the name/IP address of the machine hosting the Sybase ASA. BMC ProactiveNet 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.

Specify the TCP Control port. Default port is 2638. For detailed steps on how to obtain the port number, see Additional configuration and setup issues.

Specify name of the local/remote BMC ProactiveNet database. It is the name of the host machine concatenated with storm. Example, storm_marketing1: where marketing1 is the name of the host machine. For detailed steps on obtaining basic database specifications, see Additional configuration and setup issues.

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.

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

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

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

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

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.

Specify the time interval between two consecutive configuration data polls. Default is 24 hours (One day).

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

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.

While creating the Sybase ASA Intelliscope 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>