Show TOC

check database subscriptionLocate this document in the navigation structure

Use check database subscription command 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 the tables that are pending materialization.

materializing

Displays a list of the tables that are undergoing materialization.

valid

Displays a list of the 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.

Examples
Displays all database subscriptions

This example displays all the database subscriptions defined at the replicate server.

check database subscription
Displays the details about a 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
Displays tables - pending materialization

This example displays all the tables that are in pending materialization state.

check database subscription <subname>, <rds>, <rdb>, pending
Displays tables - completed materialization

This example displays all the tables that have completed materialization.

check database subscription <subname>, <rds>, <rdb>, valid
Displays tables - failed materialization

This example displays all the tables that have failed materialization.

check database subscription <subname>, <rds>, <rdb>, error
Verifies the materialization user's validity at the primary database

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
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.