Configuring Sybase IQ

This topic provides information about configuring Sybase IQ.

On the Add Monitor Types dialog, with the Monitoring Profile set to Sybase Monitoring, and the Monitor Type set to Sybase IQ, provide the following details:

Field	Description
Sybase Configuration Information
Environment Name	Enter a unique display name for the Sybase IQ database environment. A container will be created with the environment name. This environment will hold all the Sybase IQ instances. Warning Note You should not provide any special characters such as "*\ /?":<>**" in the environment name field.
Host	Enter the host name or IP number of the system where the Sybase IQ instance is running.
Port	Enter the port number of the Sybase IQ instance.
Sybase account credentials
User Name	Enter the user name that is used to connect to Sybase IQ.
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 IQ 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 Warning The availability of Sybase IQ will be always monitored by default irrespective of the custom data you select for monitoring.
Custom SQL query configuration
Warning 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 names	Enter the Sybase IQ database names, separated by comma, on which the above mentioned SQL will run. If you leave this field, then all Sybase IQ databases will be added.
SQL query	Enter the SQL query.
Collection time (min)	Select the collection cycle time, in minutes for the Sybase IQ 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 IQ 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 configurations details.
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.

Configuring Sybase IQ

BMC PATROL for Sybase 20.02

On this page