recover_state 
Use this command to display information about the current status of the database recovery.
You can execute this command while a recovery operation is in progress. To do this, open a second command prompt and log on there again to the database on which the recovery operation is running.
Prerequisites
You have the server permission Recovery.
You have executed the DBM command for recovering the database (see recover_start).
Structure
recover_state
Result
OK
Returncode <value>
...
Value |
Description |
|---|---|
Date |
Date |
Time |
Start time of the backup |
Server |
Name of the database computer |
Database |
Name of the database |
Kernel Version |
Version of the database kernel |
Pages Transferred |
Number of pages transferred |
Pages Left |
Number of pages still to be transferred |
Volumes |
Number of data carriers used |
Medianame |
Name of the backup template |
Location |
File or device name |
Errortext |
Error message text See also: Messages documentation |
Label |
Backup ID |
Is Consistent |
Only for data backup: Backup is internally consistent |
First LOG Page |
For data backup: First page of the log backup to be read For log backup: First page saved in the log area |
Last LOG Page |
For log backup only: Last page saved in the log area |
DB Stamp 1 Date DB Stamp 1 Time |
Time stamp for the first page of the log backup |
DB Stamp 2 Date DB Stamp 2 Time |
Time stamp for the last page of the log backup |
Page Count |
Total number of pages backed up |
Devices Used |
Number of backup devices used |
Database ID |
Database ID used to identify data and log backups that belong together |
In the event of errors, see Reply Format.
More Information
Database Administration, Restoring Databases