Validating All Publications (validatepubs) v6.2

The validatepubs command checks if any of the definitions of the tables subordinate to the given publication database definition have changed since the publication was created.

Synopsis

-validatepubs
  –repsvrfile pubsvrfile
  -pubdbid dbid
  -repgrouptype { m | s }

See Validating a Publication for additional information on validating publications.

Parameters

pubsvrfile

The file containing the publication server login information.

dbid

The publication database ID of the publication database definition under which all publication tables are to be validated.

-repgrouptype

Specify s if this command applies to a single-master replication system. Specify m if this command applies to a multi-master replication system.

Examples

In the following example, the Oracle publication database definition identified by publication database ID 1 is validated.

$ java -jar edb-repcli.jar -validatepubs \
>   -repsvrfile ~/pubsvrfile.prop \
>   -pubdbid 1 -repgrouptype s
Validating all available publications ...
The schema definitions for all the non snapshot-only publications tables are in sync
with the source.
The "validatepubs" feature is not available for the following snapshot-only publications:
-  salesemp