backup_state 

Use

You display the current status of the backup operation.

You can also execute this DBM command while a backup operation is in progress. To do this, you open a second command prompt and log on there as well to the database instance on which the backup operation is running.

See also:

Database Administration Tutorial, Displaying the Status of the Backup

Concepts of the Database Systems, Backing Up Data, Backing Up Log Entries

Prerequisites

●     You have the server authorization Backup.

●     You have started a backup (see: backup_start.

Syntax

backup_state

Reply

OK

Returncode              <value>

Date                    [<value>]

Time                    [<value>]

Server                  [<value>]

Database                [<value>]

Kernel Version          [<value>]

Pages Transferred       [<value>]

Pages Left              [<value>]

Volume Count            [<value>]

Medianame               [<value>]

Location                [<value>]

Errortext               [<value>]

Label                   [<value>]

Is Consistent           [<value>]

First LOG Page          [<value>]

Last LOG Page           [<value>]

DB Stamp 1 Date         [<value>]

DB Stamp 1 Time         [<value>]

DB Stamp 2 Date         [<value>]

DB Stamp 2 Time         [<value>]

Page Count              [<value>]

Devices Used            [<value>]

Values for the Reply Fields

Field	Description
Date	Date
Time	Start time for backup
Server	Name of the database computer
Database	Name of database instance
Kernel Version	Version of 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
Label	Backup ID
Is Consistent	For data backup only: backup is internally consistent
First LOG Page	For data backup: first page of log backup to be imported For log backup: first page saved in log
Last LOG Page	For log backup only: last page saved in log
DB Stamp 1 Date DB Stamp 1 Time	Time stamp for first page of log backup
DB Stamp 2 Date DB Stamp 2 Time	Time stamp for last page of 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