Page History
...
See About metric properties for Action settings.
Anchor | ||||
---|---|---|---|---|
|
An environment that is monitored by Alerts may generate alerts at any time. Sitting in front of the screen waiting for a metric to go critical may be strenuous and time consuming. Instead, you can set Alerts to inform you about any alert, or to run your repair utility to fix certain problems.
...
Old / New | Critical | Near-Critical | Normal | Not sampled |
---|---|---|---|---|
Critical | Do not issue | Issue | Issue | Issue |
Near-Critical | Issue | Do not issue | Issue | Issue |
Normal | Issue | Issue | Do not issue | Issue |
Not Sampled | Issue | Issue | Do not issue | Do not issue |
Anchor | ||||
---|---|---|---|---|
|
Use the Email Action Type to set the email address of the recipient and the message text that will be sent when an alert is raised by the specified metric.
...
- From the Actions tab on the Metric Properties dialog, select the email option on the Action Type list box.
- Select the email action you want to edit.
- Click Delete.
Anchor | ||||
---|---|---|---|---|
|
Use the Message Action Type to set the text message that will be displayed on every screen with an open Alerts user interface, when an alert is raised by the specified metric. The message text can also include dynamic parameters.
...
- From the Actions tab on the Metric Properties dialog, select the message option on the Action Type list box.
- Select the message action you want to edit.
- Click Delete.
Anchor | ||||
---|---|---|---|---|
|
Use the Program Action Type to set your program to be ran as an action when an alert is raised by the specified metric.
...
- From the Actions tab on the Metric Properties dialog, select the program option on the Action Type list box.
- Select the program action you want to edit.
- Click Delete.
Anchor | ||||
---|---|---|---|---|
|
Use the SNMP Action Type to set alerts to be reported to an SNMP based management tool that you may have, such as CA Unicenter® and HP OpenView.
...
- From the Actions tab, select the SNMP option on the Action Type list box.
- To apply SNMP traps, check Send an SNMP trap whenever the metric alert level changes.
- To test your definitions, click Test.
- To save your definitions, choose whether to save them either for the selected instance, or for all the environments’ instances. Then click Save and Close.
Anchor | ||||
---|---|---|---|---|
|
Use the MOM Action Type to set alerts to be reported to the MOM server whenever the metric alert level changes.
...
To enable this option, first create a Management Information Bases (MIB) file. The MIB file maps the Alerts database entities, such as the various environments, various instances, and the metrics relevant for each of the instances. Because different sites have different environments, instances, and so on, you must adjust the Alerts MIB file to each site.
Creating an MIB file
Alerts FocalPoint creates the MIB file and displays its status (success or failure) on the standard output. The newly created MIB file name is InformForAlertsMib.mib and is stored in the following directory:
...
On a Linux or UNIX server. <i3_root>/products/pulse/pulsefocal/bin/ createalertsmib.sh
Enabling the Get operation
To use your MIB browser to open the MIB file that you have created and browse the different metrics, you must set the Get parameters on both your SNMP manager and Alerts. The examples provided along with the following instructions relate to the CA Unicenter MIB browser, which is an SNMP management application.
...
- Technology representation
- Identifying environments and instances in the MIB
- Identifying metrics in the MIB
- Identifying property fields in the MIB
- MIB structure
Technology representation
The MIB tree shows the technologies of the Precise environment as the numbers 1 - 15. The table below shows how each number in a MIB tree is mapped to a technology.
...
MIB number | Mapped to ... |
---|---|
1 | Oracle |
2 | Sybase |
3 | MS-SQL |
4 | Tuxedo |
5 | Web |
6 | J2EE |
7 | SAP |
8 | Oracle Applications |
9 | Microsoft .NET |
10 | RESERVED |
11 | EMC Storage |
12 | Other |
13 | OS |
14 | Precise status |
15 | WebSphere MQ |
16 | Sybase Replication Server |
17 | DB2 |
Identifying environments and instances in the MIB
Alerts displays environments and instances by their names (environment_name, instance_name
), while the MIB presents them by their identifiers (environment_id, instance_id
).
...
- Retrieve a mapping table that maps the environment and instance names to their identifiers by running the following SQL statement in the Alerts schema:
select
INCE_ID INSTANCE_ID, INCE_NAME
INSTANCE_NAME, INEN_ID
ENVIRONMENT_ID, INEN_NAME
ENVIRONMENT_NAME
from
PS_INCE_INSTANCE_INSTANCE, PS_INII_INSTANCE_APPTIER
INSTANCE_APPTIER, PS_INAP_APP_TIER APPTIER,
PS_INEN_ENVIRONMENT ENVIRONMENT
where
INCE_ID = INII_INCE_ID AND
INAP_ID = INII_INAP_ID AND
INAP_INEN_ID = INEN_ID AND
INCE_DELETED = ‘F’ AND
INII_DELETED = ‘F’ AND
INAP_DELETED = ‘F’ AND
INEN_DELETED = ‘F’ AND
Identifying metrics in the MIB
Alerts displays metrics by their names (metric_name
), while the MIB presents them by their identifiers (metric_id
).
...
- Retrieve a mapping table that maps between the metric names and their identifiers by running the following SQL statement in the Alerts schema:
select indicator_id,indicator_name, from pulse_indicators order by indicator_name;
Available property fields in the MIB
The table below describes the available property fields for a metric.
...
No. | Field | Description | Applies to |
---|---|---|---|
0 | Value | Specifies the metric's value. Same as the dynamic parameter: Displayed in the Value metrics tab only. In case of a parent metric, only the sub-metrics show this field. | Get |
1 | Status | Specifies the metric's status. Possible values: Critical, Near-critical, Normal, and Unsampled. In the MIB browser, Downtime and Disabled statuses appear also as Unsampled status. | Get |
2 | SampleRate | Specifies the sampling rate in minutes. Same as the dynamic parameter: In case of a parent metric, only the parent shows this field. | Get |
3 | NearCrThr | Specifies the metric's Near-critical threshold. Same as the dynamic parameter: In case of a parent metric, only the sub-metrics show this field. | Get |
4 | CriticalThr | Specifies the metric's Critical threshold. Same as the dynamic parameter: In case of a parent metric, only the sub-metrics show this field. | Get |
5 | Enabled | Specifies whether or not the metric is enabled (values: yes or no). | Get |
6 | SampleTime | Specifies the metric's last sampling time. Same as the dynamic parameter: | Get |
7 | MetricName | Specifies the metric's name. Same as the dynamic parameter: | Get |
8 | InstanceName | Specifies the instance's name. Same as the dynamic parameter: | Get |
9 | ItemsTable | Specifies the list of items returned by the metric sampling. Same as the dynamic parameter: Displayed in the list of items of the metrics list. For parent metrics, the list contains also the sub-metrics. | Get |
10 | Technology | Specifies the Technology name. Same as the dynamic parameter: | Get |
11 | Machine | Specifies the Machine name. Same as the dynamic parameter: | Get |
12 | AppTier | Specifies the AppTier name. Same as the dynamic parameter: | Get |
13 | Environment | Specifies the Environment name. Same as the dynamic parameter: | Get |
14 | MetricID | Specifies the Metric ID name. | Get |
15 | Returned value | Specifies the Returned value name. Same as the dynamic parameter: | Get |
16 | Thresholds | Specifies the Thresholds name. Same as the dynamic parameter : | Get |
MIB structure
The Alerts MIB structure complies with the Alerts SNMP Object Identifier (OID) structure. The OID of the Alerts Get requests for a specified metric is:
...
Alerts supports both SNMP message versions, SNMPv1 and SNMPv2. Alerts sends traps when a change occurs in a metric severity level, that is, when the metric state is changed between the following states: Critical, Near-Critical, Normal, and Unsampled.
Alerts trap message
The following is an example of an Alerts'SNMP trap message:
...
To activate and deactivate the Alerts integration with the MOM server, go to Setting a MOM server for actions on the MOM tab.
Setting anonymous access to a MOM server
Before integrating Alerts with the MOM server in AdminPoint, anonymous access to the MOM Web console must be set.
...
To simulate a run of customized metric, use a command line shell and type from the Precise root directory:
For Windows operating systems .\products\pulse\userprograms\MYPROG.bat
.
For UNIX or Linux operating systems ./products/pulse/userprograms/MYPROG.sh
.
...
Info |
---|
It is recommended to test your scripts in your environment before running them through Alerts. For UNIX scripts, verify that the script has rx security permissions. |
Windows script examples
The examples for Windows scripts, whose file names end with _example, are listed in the following tables. These files can be found also in any server where InformPoint is installed, in the directory:
...
Script file | Script lines | Description |
---|---|---|
table_example.bat | @ECHO OFF | This script returns a list of items including their values for each sample. A tab character (not space) separates between the item name and the item value. |
UNIX/Linux shell script examples
The examples for UNIX/Linux shell scripts, which their file names end with _example, are listed in the following tables. These files can be found also in any server where InformPoint is installed, in the directory:
...
In addition, the stored procedure can be defined only in Oracle or SQL Server AppTier instances. To create Oracle stored procedure metrics, you must install the Precise for Oracle FocalPoint with at least one instance. To create MS-SQL stored procedure metrics, you must install the Precise for SQL Server FocalPoint with at least one instance.
Creating MS-SQL stored procedures
When creating a stored procedure in MS-SQL, apply the following guidelines:
...
- Apply the following format:
CREATE PROCEDURE user_def @@var1 type1, ...., @@var-n type-n
AS
- Custom query
GO - Use the following format within the call from the customized metric (the code should be entered in the Program box when adding a new Customized Metric):
user_database..user_def val1, ...., val-n
Example of an MS-SQL stored procedure
The following stored procedure enables Alerts to send an email when the number of rows in a table called SALES.ITEMS reaches an amount that you set in the Thresholds tab.
...
- Connect to the database schema of the Precise for SQL Server.
- Run the function
user_def
in the user_database as follows:
user_database..user_def sampling_rate , sampling_period
Creating Oracle stored procedures
When creating a stored procedure in Oracle, apply the following guidelines:
...
You can use any package or function name, and an unlimited number of parameters (including NONE).
Example of an Oracle stored procedure
The following stored procedure enables Alerts to send an email when the number of rows in a table called ITEMS, which belongs to a user called SALES, reaches an amount that you set in the Thresholds tab.
...