Accessing a Database While in Recovery

Occurs when a Replication Server attempts to use an Adaptive Server database that is in the process of recovery.

Symptom

These messages are recorded in the Replication Server error log:
E. 2006/06/13 10:53:36. ERROR #1028 DSI(western.west1) - /dsiexec.c(306)
Message from server: Message: 921, State: 1, Severity: 14 -- ‘Database
‘west1’ has not been recovered yet - please wait and try again.’.
I. 2006/06/13 10:53:36. Message from server: Message: 5701, State: 1,
Severity: 10 - - ‘Changed database context to ‘master’.’.
E. 2006/06/13 10:53:36. ERROR #5051 DSI(western.west1) - /dsiexec.c(314)
Received errors from database ‘western.west1’. See logged ct-lib and data
server messages for more information.

Explanation

A Replication Server cannot connect to an Adaptive Server database that is recovering. The database is not accessible until it has recovered. Replication Server automatically attempts to connect to databases (to which connections have been created) when it:
  • starts up

  • resumes a connection

  • replicates new transactions after a closed connection.

Solution

The connection resumes automatically after the database has recovered.