Configuring Sybase SQL Anywhere


This topic provides information about configuring Sybase SQL Anywhere.

On the Add Monitor Types window, with the Monitoring Profile set to Sybase Monitoring, and the Monitor Type set to Sybase SQL Anywhere, provide the following details:

Field

Description

Sybase Configuration Information

Environment Name

Enter a unique display name for the Sybase SQL Anywhere database environment. A container is created with the environment name. This environment holds all the Sybase SQL Anywhere instances.

Note

Do not enter any special characters, such as "\ */?":<>" in the field.

Host

Enter the host name or IP number of the system where the Sybase SQL Anywhere instance is running.

If you are monitoring the SQL Anywhere database of BMC TrueSight Infrastructure Management, enter <TrueSight Infrastructure Management host name>.

Port

Enter the port number of the Sybase SQL Anywhere instance.

If you are monitoring the SQL Anywhere database of BMC TrueSight Infrastructure Management, enter 2638 in this field.

Sybase account credentials

User Name

Enter the user name that is used to connect to Sybase SQL Anywhere.

If you are monitoring the SQL Anywhere database of BMC TrueSight Infrastructure Management, enter dba in this field. For password, contact the BMC Support team.

Password

Enter the password for the user name. 

Confirm Password

Re-enter the password for confirmation.

Collection details

Custom collection details

Select any of the following collection details for monitoring the Sybase SQL AnyWhere instance.

  • Availability—Select this option to check the availability of instances, connections and databases.
  • Full data—Select this option to collect all the monitored groups.
  • Custom data—Select this option to collect only the monitored groups selected from the custom data module types.

Valid when collection level is custom data 

Custom data

Click this button to select one or more options to customize data:

  • Databases
  • Capacity
  • Performance

The availability of Sybase SQL AnyWhere will be always monitored by default irrespective of the custom data you select for monitoring.


Custom SQL query configuration

Note

 The custom SQL query configuration is valid only if you enable either the Custom data, Databases in the Custom collection details field or select Full data in the Custom collection details field.

SQL name

Enter the name of the SQL query.

Database name

Enter the Sybase SQL Anywhere database names, separated by comma, on which the above mentioned SQL will run.

If you leave this field, then all Sybase SQL Anywhere databases will be added.

SQL query

Enter the SQL query.

Collection time

Select the collection cycle time in minutes for the Sybase SQL Anywhere SQL query. The default value is 1 minute.

Add to List

Click this option for confirming the configuration information that you provided and adding the SQL query to the list of configured SQL queries.

Modify Selection

Select one of the items that you added to the list in the preceding step, and click this button to modify details.

Remove from List

Click this button to remove the configured SQL query name from the list of SQL queries.

List - SQL query details

A list of all configured SQL queries will be displayed here.

KM Administration

Device mapping

Select this check box to enable the device mapping on the BMC ProactiveNet Performance Management user console.

By default, this option is enabled

Logging

Select the check box to turn the logging on or off for the Sybase SQL Anywhere environment you want to configure. By default, the data collection logging is turned off.

 

Add to List

Click to add this environment configuration to the list of configured environment configurationsdetails.

Modify Selection

Select one of the items that you added to the list in the preceding step, and click this button to modify details.

Remove from List

Select one of the items that you added to the list in the preceding step, and click this button to remove the details.

List - Sybase Configuration

A list of all configured environment configurations will be displayed here.

 

Reset

Click this option to clear off your configuration details and revert to default settings.

Add

Click this option to add this monitoring configuration. This information is displayed on the Monitor Configuration page.

After you click this option, you can continue to add more objects for monitoring.

Close

Click this option to exit without saving any changes.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*