Use check database subscription command to view the status of a database subscription defined at the replicate server.
check database subscription [<sub_name>, <replicate_data_server>, <replicate_database> [{pending | materializing | valid | error | user]}
The name of the subscription.
The name of the replicate data server.
The name of the replicate database.
Displays a list of the tables that are pending materialization.
Displays a list of the tables that are undergoing materialization.
Displays a list of the tables that have completed materialization.
Displays all the tables that failed materialization.
Verifies whether the materialization user is valid at the primary database and also displays the user name.
This example displays all the database subscriptions defined at the replicate server.
check database subscription
This example displays the details about the subname subscription defined at the replicate server, that is, the subscription status, the percentage of tables that have the pending, materializing, valid, or error states, and the materialization user.
check database subscription subname, rds, rdb
This example displays all the tables that are in pending materialization state.
check database subscription <subname>, <rds>, <rdb>, pending
This example displays all the tables that have completed materialization.
check database subscription <subname>, <rds>, <rdb>, valid
This example displays all the tables that have failed materialization.
check database subscription <subname>, <rds>, <rdb>, error
This example verifies whether the materialization user is valid at the primary database and also displays the user name.
check database subscription subname, rds, rdb, user
Use check database subscription to find the status of a subscription during subscription materialization or after subscription materialization.
Execute check subscription at the Replication Server that manages the database where the replicate data is to be stored or the Replication Server that manages the replicate database.