Transition command actions

The following table describes the action taken by the dsrutil db-name -C transition command when it is executed for databases in varying states.

Table 1. Transition command actions
Database type Database state Online or offline Description of transition performed
Source Database is newly enabled Offline An error occurs because the database is newly enabled.
Source Database is newly enabled Online An error occurs because the database is online and has never been replicated.
Source Database has been replicated Offline The database is transitioned as instructed in the repl.properties file.
Source Database has been replicated Online In order to transition a source database in this state, the Replication server must be communicating with the Replication agent to convey a transition and failover request to the Replication agent. Database brokers stay online during the transition.
Target Database has been replicated Offline In order to transition a target database in this state, the database cannot be newly transitioned.
Target Database has been replicated Online In order to transition a target database in this state, the following conditions must be met:
  • The Replication agent cannot be communicating with the Replication server.
  • The Replication agent must be in pretransition.
  • To reduce the data loss, Progress highly recommends that you apply all source AI extents to the target database by using dsrutil db-name -C applyExtent.

    You should explicitly perform this step, possibly multiple times depending on the number of source AI extents.

    Database brokers stay online during the transition.
Normal — Online An error occurs because the database is not enabled for replication.