Returns current filter settings, or sets the filter setting for a connection. The command can filter either the Replication Agent thread or the DSI thread status.
filter connection for replication_server_name [{rep agent | dsi} [={on | off}]]
Specifies the name of the connection to filter.
The name of the Replication Server to filter.
Specifies the part of the connection to filter.
Sets filtering for the connection to either on or off.
Returns the list of filter set for “inventory_pds.vendor” connection in prs1:
filter inventory_pds.vendor for prs1
Hides the status of the DSI thread for the connection “inventory_pds.vendor” in prs1:
filter inventory_pds.vendor dsi for prs1 dsi = on
Turns rep agent filtering off for the connection “inventory_pds.item” in prs1:
filter inventory_pds.item for prs1 rep agent = off
When a filter is turned on, the connection status is displayed as “Hidden.” The status of the connection is not rolled up into the status of the Replication Server.
If the rep agent filter is turned on, the RMS does not report the status of the Replication Agent thread or RepAgent thread in the Adaptive Server Enterprise, Replication Agent, or the Replication Server.
When you invoke the filter command with no options specified, it returns a list of specified connections.
filter returns the following result set:
Column |
Description |
---|---|
RepServer |
The name of the Replication Server |
Connection |
The name of the connection |
DSI |
The filtering value of DSI |
rep agent |
The filtering value of rep agent |
The filter command returns the following result set, if you have turned filtering on or off for the connection:
Column |
Description |
---|---|
Action |
The name of the action |
Result |
The result of the execution |