Page tree

This topic provides information about configuring Sybase ASE by using Central Monitoring Administration.

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

FieldDescription
Sybase Configuration Information
Environment Name

Enter a unique display name for the Sybase ASE database environment. A container will be created with the environment name. This environment will hold all the Syabse ASE instances.

Note

You should not provide any special characters such as "\ */?":<>" in the environment name field.

HostEnter the host name or IP number of the system where the Sybase ASE instance is running.
PortEnter the port number of the Sybase ASE instance.
Sybase account credentials
User NameEnter the user name that is used to connect to Sybase ASE.
PasswordEnter the password for the user name. 
Confirm PasswordRe-enter the password for confirmation.
Databases for exclusion

Enter the Sybase ASE database names, separated by comma, that you want to exclude from monitoring.

By leaving this field empty, it will include all databases for monitoring

  • This field 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.
  • Input must not contain any character set. (no space and semicolon)
(Only for upgrade from 10.8 to 11.0 and later) Log monitoring

If you upgrade from BMC PATROL for Sybase 10.8 to 11.0 and later, and you had enables log monitoring, select this check box for monitoring the error log of Syabse Adaptive Server.

Notes

  • You cannot access and monitor the Adaptive Server error logs when you monitor a remote Adaptive Server. That is, this option is applicable only for local monitoring.

  • For monitoring Adaptive Server error log, you must install BMC PATROL for Log Management KM locally on your machine.

If you have installed BMC PATROL for Sybase 11.0 or later, to enable log monitoring, install and configure the BMC PATROL for Log Management KM.

Security details
Encrypt password
Use Encrypt passwordEnable this option to encrypt the ASE login password.
JCE provider

Specify the JCE provider

The asymmetric password encryption mechanism uses RSA encryption algorithms to encrypt the password being transmitted. To perform this RSA encryption, you must configure a Java Cryptography Extension (JCEprovider.

SSL
Enable SSLEnable this option for enable SSL.
Trust Store file pathSpecify the TrustStore file name for one way SSL and two way SSL connections.
Trust Store file passwordSpecify the TrustStore password for one way SSL and two way SSL connections.
Collection details
Custom collection details

Select any of the following collection details for monitoring the Sybase ASE 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
  • Disk
  • Network
  • Application queue
  • Datacache
  • Index
  • Kernel
  • Locks
  • Memory
  • Metadata
  • Parallel
  • Procedure cache
  • Recovery
  • Tasks
  • Transaction manager
  • Transaction
  • Worker process
  • Users
  • Replication Agent

The availability of Sybase ASE 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 nameEnter the name of the SQL query.
Database names

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

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

SQL queryEnter the SQL query.
Collection time (min)

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

Add to ListClick this option for confirming the configuration information that you provided and adding the SQL query to the list of configured SQL queries.
Modify SelectionSelect one of the items that you added to the list in the preceding step, and click this button to modify details.
Remove from ListClick this button to remove the configured SQL query name from the list of SQL queries.
List - SQL query detailsA 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

LoggingSelect the check box to turn the logging on or off for the Sybase ASE environment you want to configure. By default, the data collection logging is turned off.
Long running TX qualification (sec)Select the value for Long Running Trans parameter. The default value is 90 second.
 
Add to ListClick to add this environment configuration to the list of configured environment configurations details.
Modify SelectionSelect one of the items that you added to the list in the preceding step, and click this button to modify details.
Remove from ListSelect one of the items that you added to the list in the preceding step, and click this button to remove the details.
List - Sybase ConfigurationA list of all configured environment configurations will be displayed here.
 
ResetClick 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.

CloseClick this option to exit without saving any changes.


  • No labels