Chat now with support
Chat with Support

Foglight for Sybase 7.3.0 - User and Reference Guide

Using Foglight for SAP ASE
Exploring the SAP ASE Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference

Setting Connection Details

Use the Connection Details set of agent properties for a Sybase_RS Agent to designate the type of connection properties to use.

1
Go to the Connection Parameters set of properties.
2
Enter the location of the interfaces or the ini/sql.ini file, in the
Replication Server Home Directory ($SYBASE) box.
NOTE: The login needs to be a database user in the rssd database and a member of rs_systabgroup.
8
Enter the primary ASE login name in the Primary ASE (RepAgent) Login Name box.
NOTE: The login needs to be a database user in the Primary database.
This login should also have the
replication_role assigned to it in order to execute the sp_help_rep_agent command.
If you have a warm standby server for the Primary ASE, and you want to monitor the warm standby server, ensure you create the primary login name inside the warm standby server.
10
Enter the replicate ASE login name in the Replicate ASE (Latency) Login Name box.
NOTE: The login needs to be a database user in the Replicate database with select permission on rs_lastcommit in the Replicate databases.
If you have a warm standby server for the Replicate ASE, and you want to monitor the warm standby server, ensure you create the replicate login name inside the warm standby server.
14
Click Save.
15
Go to Setting Data Management Properties to set the sample frequency.

Setting Data Management Properties

Use the Data Management set of agent properties to set the sample frequency.

1
Ignore the Purge Data After box. This field is not functional.
2
Click the Monitor Availability Data radio button, True or False, to turn the data filtering on or off. When this field is set to true, the agent monitors Replication Server availability.
The Availability Sample Frequency is the rate at which the agent tests for the RepServer connectivity, up/down status, etc. The Sybase_RS Agent sample frequency is controlled at the agent level.
4
Click the Monitor Performance Data radio button, True or False, to turn the monitoring of performance data on or off. When this field is set to true, the agent monitors the Replication Server performance data.
6
Click the list from the Performance List that you want to update. Select a list for the Performance Foglight Tables to monitor.
The default list name is Performance_List.
7
Click Edit.
9
Click the dialog box Save to save your entries and close the dialog box.
10
Click the Monitor Space Trend Data radio button, True or False, to monitor the Replication Server space trend data. When this field is set to true, the agent monitors the Replication Server space trend data.
12
Click the list from the Space Trend List that you want to update. Select a list for the space trend tables to monitor.
13
Click Edit.
15
Click the dialog box Save to save your entries and close the dialog box.
16
Click Save.
17
Go to Setting Configuration Properties to filter system error messages.

Setting Configuration Properties

Use the Configuration set of agent properties to filter the collection of system error messages by including or excluding collection.

The Sybase_RS Agent collects specific system error messages, which are defined in the Message Trap List, and then stored in the RepServer Error Log.

1
Click the list from the Latency Include/Exclude List that you want to update.
2
Click Edit.
a
Replicate ASEEnter the Replicate ASE to exclude.
b
Replicate DatabaseEnter the Replicate Database to exclude.
c
Exclude radio buttonSelect true to exclude the Replicate ASE.
d
Critical Threshold Limit (s)Enter the preferred threshold limit for latency
4
Click the dialog box Save to save your entries and close the dialog box.
5
Click the list from the Primary ASE Exclude List that you want to update.
6
Click Edit.
8
Click the dialog box Save to save your entries and close the dialog box.
9
Click the list from the Message Trap List that you want to update.
10
Click Edit.
a
Log Message TypeAllows you to specify the message type to be filtered.

F

Fatal Error

This is a serious error which could cause the Replication Server to exit.

N

Internal Error

These errors are caused by anomalies in the Replication Server software.

E

Error

An error that does not prevent further processing, such as a site that is unavailable.

W

Warning

These are warnings about a condition that has not yet caused an error, but may require attention.

H

Thread Died

A Replication Server thread has unexpectedly shut down

b
Search PatternIndicates the regular expression pattern used to match the log message.
c
Include MessageIf selected, it includes the particular Log Message Type (E, F, or W).
d
Exclude MessageIf selected, it excludes the particular Log Message Type (E, F, or W).
12
Click the dialog box Save to save your entries and close the dialog box.
13
Click Save.
14
Go to Setting Data Retrieval Properties to set the maximum number of rows returned.

Setting Data Retrieval Properties

1
Click the maximum rows list from the Max Row List that you want to update.
The default list name is Max_Row_List. This list can be renamed to better describe the changes made.
2
Click Edit.
a
TableThe table to limit the rows returned.
b
Maximum Rows ReturnedEnter the maximum rows to return.
The maximum value for rows returned is 100.
4
Click the dialog box Save button to save your entries and close the dialog box.
5
Click Save.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating