Command to View Database Subscription Status Information
Use check database subscription to view the status of a database subscription defined at the replicate server.
Syntax
check database subscription [<sub_name>, <replicate_data_server>, <replicate_database> [{pending | materializing | valid | error | user]}Parameters
- <sub_name>
- The name of the subscription.
- <replicate_data_server>
- The name of the replicate data server.
- <replicate_database>
- The name of the replicate database.
- pending
- Displays a list of tables that are pending materialization.
- materializing
- Displays a list of tables that are undergoing materialization.
- valid
- Displays a list of tables that have completed materialization.
- error
- Displays all the tables that failed materialization.
- user
- Verifies whether the materialization user is valid at the primary database and also displays the user name.
Example
This example displays all the database subscriptions defined at the replicate server.check database subscription
Example
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>
Example
This example displays all the tables that are in pending materialization.check database subscription <subname>, <rds>, <rdb>, pending
Example
This example displays all the table that have completed materialization.check database subscription, <rds>, <rdb>, valid
Example
This example displays all the tables that have failed materialization.check database subscription, <rds>, <rdb>, error
Example
This exampl verifies whether the materialization user is valid at the primary database and also displays the user name.check database subscription, <rds>, <rdb>, user
Usage
- 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.