filter connection

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.

Syntax

filter connection for replication_server_name [{rep agent | dsi} [={on | off}]]

Parameters

connection – Specifies the name of the connection to filter.
replication_server_name – The name of the Replication Server to filter.
rep agent, dsi – Specifies the part of the connection to filter.
on, off – Sets filtering for the connection to either on or off.

Examples

Example 1 – Returns the list of filter set for “inventory_pds.vendor” connection in prs1:
```
filter inventory_pds.vendor for prs1
```
Example 2 – Hides the status of the DSI thread for the connection “inventory_pds.vendor” in prs1:
```
filter inventory_pds.vendor dsi for prs1 dsi = on
```
Example 3 – Turns rep agent filtering off for the connection “inventory_pds.item” in prs1:
```
filter inventory_pds.item for prs1 rep agent = off
```

Usage

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:

filter connection Result Set (List of Filtered Connections)
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:

filter connection Result Set (Filtering Turned On/Off)
Column

Description

Action

The name of the action

Result

The result of the execution

Column	Description
`Action`	The name of the action
`Result`	The result of the execution