Monitor an Extract Recovery
If Extract abends when a long-running transaction is open, it can seem to take a long time to recover when it is started again. To recover its processing state, Extract must search back through the online and archived logs (if necessary) to find the first log record for that long-running transaction. The farther back in time that the transaction started, the longer the recovery takes, in general, and Extract can appear to be stalled.
To confirm that Extract is recovering properly, use the
SEND EXTRACT
command with the STATUS
option. One of the following status notations
appears, and you can follow the progress as Extract changes its log read position over
the course of the recovery.
-
In recovery[1]
-
Extract is recovering to its checkpoint in the transaction log. This implies that it is reading from either the BR checkpoint files and then archived/online logs, or reading from Recovery Checkpoint in archived/online log.