Foglight for Sybase 5.7.5.40 - User and Reference Guide

Setting Connection Details

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.

NOTE: You do not need to create any new OS users. The Sybase RS agent only requires the database login to function correctly.

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: It is recommended that the Sybase_RS Agent be deployed on the server where the Replication Server is running. If the Sybase_RS Agent is deployed on a remote server then the user needs to enter the Sybase Home directory for the remote server where the Sybase_RS Agent is deployed.

3	Enter the name of the Replication Server to be monitored, in the Replication Server Name box.

4	Enter a login name that provides access to the replication server, in the Replication Server Login Name box.

NOTE: The login needs to be a user of the replication server with no special permissions.

5	Enter the current password associated with the Replication Server login name, in the Replication Server Login Password box.

6	Enter the RSSD login name in the RSSD Login box.

NOTE: The login needs to be a database user in the rssd database and a member of rs_systabgroup.

7	Enter the current RSSD password associated with the RSSD login name, in the RSSD Password box.

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.

9	Enter the current primary ASE password associated with the primary ASE login name, in the Primary ASE (RepAgent) Login Password box.

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.

11	Enter the current replicate ASE password associated with the replicate ASE login name in the Replicate ASE Latency) Login Password box.

12	Enter the number of times you want the Sybase_RS Agent to attempt to connect to the Sybase Replication Server, in the Maximum Connection Retries box.

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.

13	Enter number of seconds allowed for an individual connection attempt, in the Connection Timeout box.

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

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.

3	Enter the sample frequency (in seconds) to monitor the availability data, in the Availability Sample Frequency (seconds) box.

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.

5	Enter the sample frequency (in seconds) to monitor the performance data, in the Performance Sample Frequency (seconds) box.

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.

8	Add an entry to the list by clicking Add new row.

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.

11	Enter the sample frequency (in minutes) to monitor the space trend data, in the Space Trend Sample Frequency (minutes) box.

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.

14	Add an entry to the list by clicking Add new row.

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

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.

NOTE: The Latency Exclusion List is not auto discovered when the agent is started. You must enter the Replicate ASE/database that you do not wish to monitor in the exclude list. If you do not want to monitor latency for a warm standby server, then you must enter the warm standby server in the Latency Exclude List in the agent property.

2	Click Edit.

A secondary property list appears.

3	Add an entry to the list by clicking Add new row.

Fill in the dialog box fields.

a	Replicate ASE—Enter the Replicate ASE to exclude.

b	Replicate Database—Enter the Replicate Database to exclude.

c	Exclude radio button—Select 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.

7	Add an entry to the list by clicking Add new row.

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.

11	Add an entry to the list by clicking Add new row.

Fill in the dialog box fields.

a	Log Message Type—Allows 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 Pattern—Indicates the regular expression pattern used to match the log message.

c	Include Message—If selected, it includes the particular Log Message Type (E, F, or W).

d	Exclude Message—If 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

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.

3	Add an entry to the list by clicking Add new row.

Fill in the dialog box fields.

a	Table—The table to limit the rows returned.

b	Maximum Rows Returned—Enter 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.