sybase AC GUI Reference

This article describes the Admin Console interface and fields to configure the sybase (Sybase Monitoring) probe.
uimpga-ga
This article describes the Admin Console interface and fields to configure the sybase (Sybase Monitoring) probe.
 
Contents
 
 
 
sybase Node
The sybase node contains the configuration details specific to sybase probe. This node lets you view the probe information and configure the general properties of the sybase probe. You can also view a list of all alarm messages available in this probe.
 
Navigation:
 sybase
Set or modify the following values as required:
  •  
    sybase > Probe Information 
    This section provides information about the probe name, probe version, start time of the probe, and the probe vendor.
  •  
    sybase > General
    This section lets you configure the setup properties of the sybase probe.
    •  
      Alarm Severity Filter
      : sets a filter on severity levels that can become potential alarms. The sybase probe can check the Sybase databases. Some events that are generated are vital and key to the performance and availability of the database. For example, as a database administrator, you want to pass important events on to the operations center or help-desk, so that the event can trigger emails. The 
      Alarm severity filter
       considers the events matching or exceeding the selected severity level alarms. If you select major, then only the messages with severity level as major and above are considered as alarms. You can select from the following options:
        • clear
        • information
        • warning
        • minor
        • major
        • critical
      Default: information 
    •  
      Log Size in KB
      : specifies the maximum size of the probe log file.
      Default: 100
    •  
      Log Level
      : specifies the level of details that are written to the log file. Log as little as possible during normal operation to minimize disk consumption, and increase the amount of detail when debugging.
      Default: 0 - Normal
  •  
    sybase > Message pool
    This section displays a list of alarm messages available in the sybase probe. However, you cannot edit the existing messages or add any new ones.
    • Text: identifies the message text.
    • i18n_Token: identifies the predefined alarms retrieved from the database.
  •  
    sybase > Options icon > Create New Connection
    This section lets you create connections corresponding to instances that the probe monitors. Specify the user ID, password, and server name for connecting to the instance.
    •  
      Connection Name
      : specifies a unique name of the connection.
    •  
      Advance Monitoring
      : enables you to perform advance monitoring from the probe.
      Default: Not selected
    •  
      Monitoring Option
      : allows you to specify the monitoring object as server or table.  The 
      Monitoring Option
       field is enabled when you select the 
      Advanced monitoring
       check box. You can select from the following options:
      • Monitoring Server
      • Monitoring Tables
      • In advanced mode, the probe allows you to monitor Sybase server and tables. In basic mode, the probe monitors only the server.
      • The Monitoring Server is not a part of the Adaptive Server Enterprise v15.7. Hence, advanced monitoring using Monitoring Server is not supported for Linux 64-bit systems.
    •  
      Description: 
      specifies additional information about the connection.
    •  
      Encryption
      : encrypts the authentication between the probe and the Sybase database server. The probe supports RSA encryption and is supported only on Linux and Solaris.
    •  
      User ID: 
      specifies the authorized user identification code to the server.
    •  
      Password: 
      specifies the valid password associated with the User ID.
    •  
      Server Name
      : specifies the server name as defined in the interface files.
       The interface files contains information about Adaptive Server and Open Server applications. For example, you can get the server name from the interface files to establish the connection.
    •  
      Monitoring Server
      : specifies the monitoring server name. This field appears when you select 
      Monitoring server
       in the 
      Monitoring option
       field. 
    •  
      Retry attempts
      : specifies the number of attempts that the probe tries to connect in case of connection failure.
      Default: 0
    •  
      Retry delay
      : specifies the time the sybase probe waits between two connection attempts.
      Default: 1
    •  
      Retry Delay (Units)
      : specifies the unit for measuring the value of retry delay.
      Default: sec
    •  
      Timeout
      : specifies the time before considering a connection failure.
      Default: 5
    •  
      Timeout (Units)
      : specifies the unit for measuring the timeout.
      Default: sec
Checkpoints Node
The 
Checkpoints
 node lets you create a checkpoint to monitor the Sybase database. The default checkpoints are visible in this node, and you can also create custom checkpoints.
 
Navigation: 
sybase > Checkpoints
  •  
    Checkpoint > Options (icon) > Create New Checkpoint
    This section allows you to create a checkpoint.
    •  
      Name
      : specifies the name of the checkpoint.
    •  
      Connection Name
      : specifies the name of the connection.
    •  
      Query File
      : defines the query file name where you want the query to be stored.
    •  
      Query
      : defines the query for creating the checkpoint.
    •  
      Interval Modus
      : subtracts the variable value from the value generated at the end of the interval.
      Default: Not selected
<Checkpoint Name> Node
The 
checkpoint name
 node lets you configure the checkpoint attributes such as general properties and exclude patterns. 
 
Navigation: 
sybase > Checkpoints > 
checkpoint name
 
Set or modify the following values as required:
  •  
     
    checkpoint name
     > General
    This section lets you configure the general setup parameters of the checkpoint of sybase probe.
    •  
      Checkpoint Name
      : specifies the name of the checkpoint.
    •  
      Description
      : specifies additional information about the checkpoint.
    •  
      Active
      : activates the checkpoint for monitoring.
    •  
      Condition
      : specifies the conditional operator to evaluate the threshold values.
    •  
      Check Interval
      : specifies the time interval at which the Sybase server or tables are scanned. 
       Reduce this interval to generate alarms frequently. A shorter interval can also increase the system load.
    •  
      Check Interval (Units)
      : specifies the check interval unit. You can select any of the following units:
      • sec
      • min
      • hrs
    •  
      Samples:
       specifies the number of samples to calculate an average value, which is compared with the specified alarm threshold. The probe generates an alarm when the average value of any sample breaches the threshold. The probe behavior for the following 
      Samples
       value is described as follows: 
      • 0: Sampling is done based on the number of samples defined in the template. If no number is specified in the template, no sampling is done. 
      • 1: No sampling is done. 
      • 3: The probe performs the following: 
        • uses the first sample value in the first interval 
        • uses the average of samples 1 and 2 in the second interval 
        • uses the average of samples 1, 2, and 3 in the third interval 
      Default: 1
    •  
      Clear Severity
      : enables you to select the severity used for message issued when the threshold is not breached. You can select from the following options:
      • clear
      • information
      • warning
      • minor
      • major
      • critical
      Default: clear
    •  
      Clear Message
      : specifies the message name used for clear alarm.
  •  
     
    checkpoint name
     > Query Configuration
    This section lets you configure the query, which fetches the value for configuring the checkpoint.
    •  
      Condition
      : specifies the condition for configuring the query.
    •  
      Query File
      : defines the file name where the query is stored.
    •  
      Query
      : defines the query statement.
    •  
      Interval Modus
      : subtracts the variable value from the value generated at the end of the interval.
     This section appears only for the custom checkpoints.
  •  
     
    checkpoint name
     > Row Identifier 
    This section lets you pick the rows as variables to set an alarm message and suppression key. If the query returns more than one row, the sybase probe needs a unique identification for each row.
     This section appears only for the custom checkpoints.
     
     
    checkpoint name
     > Message Variable
    This section lets you select the columns as variables used in creating QoS.
     
     
    •  
      Data Type
      : specifies the data type of the variable used in creating the QoS.
    •  
      Column Use
      : specifies the column use of the variable.
     This section appears only for the custom checkpoints.
  •  
     
    checkpoint name
     > Use Exclude Configuration
    This section lets you enable or disable the exclude list.
  •  
     
    checkpoint name
     > Exclude List
    This section lets you add an exclude list, which defines objects that you do not want to monitor on the checkpoint.
    •  
      Exclude Pattern
      : defines a regular expression based on which the exclude functionality works.
Monitors Node
The 
Monitors
 node lets you view and define the QoS and thresholds for monitoring the checkpoint.
 
Navigation: 
sybase > Checkpoints > 
checkpoint name
 > Monitors
  •  
    Monitors > Quality of Service
    This section allows you to configure the QoS for the checkpoint.
    •  
      Unit
      : defines the QoS unit.
    •  
      Abbreviation
      : defines the QoS abbreviation.
    •  
      Metric:
       defines the column that is fetched from the query.
    •  
      Max value
      : specifies the maximum value of the QoS.
  •  
    Monitors > Threshold
    This section lets you configure the threshold values for a checkpoint.
    •  
      Threshold Object Name
      : displays the monitoring object name. The probe uses the 
      Threshold Object Name
       as default for a checkpoint. Some special checkpoints have a second threshold called count (for example, locked_users).
    •  
      Threshold Value
      : specifies the value used for threshold evaluation.
      Default: 0.00
    •  
      Severity
      : specifies the severity of alarm message to be used for the threshold.
    •  
      Message
      : specifies the message name used.
    •  
      Message Text
      : specifies text of the message, containing variables that are replaced during run time. If the message text is changed from a profile list, you must create new message.
Connection-<Connection Name> Node
The Connection-
connection name 
node displays properties of the connection setup. 
 
Navigation: 
sybase > Connection-
connection name
 
  •  
    Connection-
    connection name
     > Connection Setup
    This section displays the attributes of the connection setup, such as connection name, User ID, password, server name and monitoring server.
    The field descriptions are the same as described in 
    Create New Connection
     section in the sybase node.
<Connection Name> Node
The 
connection name
 node lets you view and modify the connection setup properties.
 
Navigation: 
sybase > Connection-
connection name > connection name
 
Set or modify the following values as required:
  •  
     
    connection name
     > Edit Connection
    This section lets you display the properties of the connection setup.
    The field descriptions are the same as described in 
    Create New Connection
     section in the sybase node.
  •  
     
    connection name
     > Options icon > Create new profile
    This section lets you create a profile, which enables to execute the checkpoints for a particular connection.
<Profile Name> Node
The 
profile name
 node lets you modify the profile parameters. 
 
Navigation: 
sybase > Connection-
connection name
 > 
profile name
 
Set or modify the following values as required:
  •  
     
    profile name > 
    Edit Profile
    This section lets you modify the parameters of the profile.
    •  
      Heartbeat
      : specifies the interval at which all profile checkpoint schedules are tested and executed.
      Default: 5 
      This number is a common denominator to all used check interval values. The higher the value of heartbeat, the lower is the profile overhead.
    •  
      Heartbeat (Units)
      : specifies the heartbeat unit.
      Default: sec
    •  
      Connection
      : specifies the connection used in the profile. The drop-down list displays the list of connections that you have defined to connect to the Sybase server.
    •  
      Check Interval
      : specifies the time interval at which the Sybase server or tables are scanned. Reduce this interval to generate alarms frequently.Default: 5 minutes 
    •  
      Check Interval (Units)
      : specifies the unit for the check interval.
      Default: sec
    •  
      Clear message
      : specifies the message for the timeout clear alarm.
      Default: timeout_clear_1
    •  
      SQL Timeout
      : specifies the SQL query timeout. If the query reaches the SQL timeout, the checkpoint processing is terminated. The next checkpoint starts and an alarm is generated.
      Default: 30
    •  
      SQL Timeout (Units)
      : specifies the unit for the SQL Timeout.
      Default: sec
    •  
      Message
      : specifies the message name used for SQL timeout alarm.
      Default: Sql_timeout_1
    •  
      Profile Timeout
      : specifies the maximum processing time for all checkpoints in the profile. If this timeout is reached, the interval processing is finished and the probe waits for next heartbeat to evaluate any checkpoint schedules. Alarm message is issued.
      Default: 15
    •  
      Profile Timeout (Units)
      : specifies the profile timeout unit.
      Default: min
    •  
      Message
      : specifies the profile timeout message.
      Default: p_timeout_1
    •  
      Timeout Severity
      : defines the severity for timeout messages.
      Default: major
    •  
      Alarm Source
      : overrides the source name of the alarm on the Unified Service Management (USM). If you do not specify a value, robot IP address is used.
    •  
      Use Alarm source as QoS source: 
      enables you to use alarm source for QoS. If you select the checkbox without specifying the alarm source, then QoS source will be the robot name.