Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Foglight for Sybase 5.7.5.40 - User and Reference Guide

Using Foglight for Sybase
Exploring the Sybase Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference About us

Setting Connection Details

Previous Next



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.

To set the connection details:
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.

This is the maximum number of retries the Sybase_RS Agent attempts when it encounters an error with the Adaptive Server before the agent stops.

The default is three retries.

The connection aborts after waiting to connect for this time out value.

The default is five seconds.

14
Click Save.
15
Go to Setting Data Management Properties to set the sample frequency.

Setting Data Management Properties

Previous Next



Setting Data Management Properties

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

To set the data management properties:
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 default value is true.

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.

The default is 60 seconds.

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.

The default value is true.

The sample frequency, or collection rate, is the number of seconds between the end of a collection period and the start of the next. The Sybase_RS Agent sample frequency is controlled at the agent level.

The default is 300 seconds.

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.

A secondary property list appears.

Fill in the dialog box fields.

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.

The default value is false.

The sample frequency, or collection rate, is the number of minutes between the end of a collection period and the start of the next. The Sybase_RS Agent sample frequency is controlled at the agent level.

The default is 60 minutes. The minimum value that can be entered is 15 minutes.

12
Click the list from the Space Trend List that you want to update. Select a list for the space trend tables to monitor.

The default secondary list name is Space_Trend_List.

13
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

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

Previous Next



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.

To set the error message collection properties:
1
Click the list from the Latency Include/Exclude List that you want to update.
2
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

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.

A secondary property list appears.

Fill in the dialog box fields.

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.

The Log Filters list allows you to enter the log message type, search pattern, and whether to include or exclude. The Sybase_RS Agent records these messages in an event log.

The Sybase_RS Agent default log filter name is LogFileFilter.

10
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

a
Log Message TypeAllows you to specify the message type to be filtered.

Table 75. Log Message Types

Message Type Value

Message Type

Description

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

Previous Next



Setting Data Retrieval Properties

To set the 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 secondary property list appears.

Fill in the dialog box fields.

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.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation