QUERY REPLRULE (Query replication rules)

Use this command to display information about replication rules.

Issue this command on the server that acts as a source for replicated data.

Tip: Do not confuse replication rules with replication storage rules. Replication rules are associated with the traditional method of node replication. You define a replication rule on the command line by using the REPLICATE NODE command. Replication storage rules are associated with a newer replication method that is more flexible and granular. You define replication storage rules by using the DEFINE STGRULE command. The QUERY REPLRULE command applies to traditional replication rules.

Privilege class

Any administrator can issue this command.

Syntax

Parameters

rule_name

Specifies one or more replication rules that you want to display information about. This parameter is optional. You can use wildcard characters to specify one or more rules. If you do not specify this parameter, information about all rules is displayed in the query output. You can specify the following values:

ALL_DATA

Displays information about the ALL_DATA replication rule. This rule replicates backup, archive, or space-managed data. The data is replicated with a normal priority.

ACTIVE_DATA

Displays information about the ACTIVE_DATA replication rule. This rule replicates only active backup data. The data is replicated with a normal priority. This rule is not valid for archive or space-managed data.

Attention: If you specify ACTIVE_DATA and one or more of the following conditions are true, inactive backup data on the target replication server is deleted, and inactive backup data on the source replication server is not replicated.

When a server version earlier than version 7.1.1 is installed on either the source or target replication servers.
When you are using the REPLICATE NODE command with the FORCERECONCILE=YES parameter.
When you are running the initial replication of a file space after you configure replication, restore the database, or upgrade both the source and target replication servers from a server version earlier than 7.1.1.

If the previous conditions are not true, all new and changed files since the last replication are replicated, including inactive files, and files are deleted when they expire.

ALL_DATA_HIGH_PRIORITY

Displays information about the ALL_DATA_HIGH_PRIORITY rule. This rule replicates backup, archive, or space-managed data. The data is replicated with a normal priority. In a replication process, high-priority data is replicated before normal-priority data.

ACTIVE_DATA_HIGH_PRIORITY

Displays information about the ACTIVE_DATA_HIGH_PRIORITY rule.

This rule is the same as the ACTIVE_DATA replication rule except data is replicated with a high priority.

Example: Display information about a server replication rule

The name of the rule is ALL_DATA_HIGH_PRIORITY

query replrule all_data_high_priority

Replication Rule Name: ALL_DATA_HIGH_PRIORITY 
Target Replication Server: 
Active Only: No
Enabled: Yes

Field descriptions

Replication Rule Name

Specifies the name of the rule that was queried.

Target Replication Server

Specifies the name of the target replication server.

Active Only

Specifies whether the rule applies only to active backup data. The following values are possible:

Yes: Specifies that only active backup data is replicated for file spaces to which this rule is assigned.
No: Specifies that all backup data is replicated for file spaces to which this rule is assigned.

Enabled

Specifies whether the rule is enabled or disabled. The following values are possible:

Yes: Specifies that the rule is enabled for replication. Data in file spaces to which the rule is assigned is replicated.
No: Specifies that the rule is not enabled for replication. Data in file spaces to which the rule is assigned is not replicated.

Related commands

Table 1. Commands related to QUERY REPLRULE
Command	Description
QUERY REPLICATION	Displays information about node replication processes.
QUERY REPLNODE	Displays information about the replication status of a client node.
UPDATE REPLRULE	Enables or disables replication rules.