Displaying the Backup Status

Use

After you have started a backup, you can display the status of the backup using the Database Manager.

In addition to the open command line window in which you started the backup operation, open a second command line window in which you log on to the same database instance.

To read the prerequisites, see Database Manager CLI, backup_state

Scenario

You have started a complete backup to a tape. You now want to display the backup status.

Procedure

In the following example, explanations of the output are in bold print and marked as comments with the number sign (#).

...

       1.      Open a new command line window.

       2.      Call the Database Manager CLI in session mode and log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB:

>dbmcli –u OLEG,MONDAY –d DEMODB

dbmcli on DEMODB>

       3.      Execute the DBM command for displaying the backup status:

dbmcli on DEMODB>backup_state

OK

Returncode              0

Date                    20051101

Time                    00113310

Server                  GENUA

Database                DEMODB

Kernel Version          Kernel    7.6.00   Build 018-003-000-000

Pages Transferred       0

Pages Left              0

# These output values tell you that the database system has started the backup and is trying to access the tape.

Volumes

Medianame

Location

Errortext

Label

Is Consistent

First LOG Page

Last LOG Page

DB Stamp 1 Date

DB Stamp 1 Time

DB Stamp 2 Date

DB Stamp 2 Time

Page Count              0

Devices Used            1

Database ID             GENUA:DEMODB_20051014_142158

Max Used Data Page      0

Converter Page Count

Redo Transactions Read  0

Redo Transactions Done  0

       4.      Execute the DBM command for displaying the backup status once again:

dbmcli on DEMODB>backup_state

OK

Returncode              0

Date                    20051101

Time                    00113310

Server                  GENUA

Database                DEMODB

Kernel Version          Kernel    7.6.00   Build 018-003-000-000

Pages Transferred       216

Pages Left              3559

# These output values tell you that the database system is writing the data to the tape.

Volumes

Medianame

Location

Errortext

Label

Is Consistent

First LOG Page

Last LOG Page

DB Stamp 1 Date

DB Stamp 1 Time

DB Stamp 2 Date

DB Stamp 2 Time

Page Count              3775

Devices Used            1

Database ID             GENUA:DEMODB_20051014_142158

Max Used Data Page      0

Converter Page Count    11

Redo Transactions Read  0

Redo Transactions Done  0

       5.      Execute the DBM command for displaying the backup status once again:

dbmcli on DEMODB>backup_state

OK

Returncode              0

Date                    20051101

Time                    00113310

Server                  GENUA

Database                DEMODB

Kernel Version          Kernel    7.6.00   Build 018-003-000-000

Pages Transferred       3800

Pages Left              0

# These output values tell you that the database system has finished writing data to the tape and is rewinding the tape.

Volumes                 1

Medianame

Location

Errortext

Label

Is Consistent

First LOG Page

Last LOG Page

DB Stamp 1 Date

DB Stamp 1 Time

DB Stamp 2 Date

DB Stamp 2 Time

Page Count              3800

Devices Used            1

Database ID             GENUA:DEMODB_20051014_142158

Max Used Data Page      0

Converter Page Count    11

Redo Transactions Read  0

Redo Transactions Done  0

       6.      Execute the DBM command for displaying the backup status once again:

dbmcli on DEMODB>backup_state

OK

Returncode              0

Date

Time

Server

Database

Kernel Version

Pages Transferred       0

Pages Left              0

# These output values tell you that the backup operation has finished.

Volumes

Medianame

Location

Errortext

Label

Is Consistent

First LOG Page

Last LOG Page

DB Stamp 1 Date

DB Stamp 1 Time

DB Stamp 2 Date

DB Stamp 2 Time

Page Count              0

Devices Used

Database ID

Max Used Data Page

Converter Page Count

Redo Transactions Read  0

Redo Transactions Done  0