After you have started a backup, you can display its status 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.
You have started a complete backup to a tape. You now want to display the backup status.
You can find the prerequisites under Database Manager CLI, backup_state
In the following example, explanations of the output are displayed in bold and marked as comments with the number sign (#).
Open a new command line window.
Call the Database Manager CLI in session mode, log on as operator OLEG with the password MONDAY, and connect to the database instance DEMODB.
>dbmcli –u OLEG,MONDAY –d DEMODB
dbmcli on DEMODB>
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
# The values for Pages Transferred and Pages Left 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
Execute the DBM command for displaying the backup status 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
# The values for Pages Transferred and Pages Left 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
Execute the DBM command for displaying the backup status 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
# The values for Pages Transferred and Pages Left 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
Execute the DBM command for displaying the backup status again:
dbmcli on DEMODB>backup_state
OK
Returncode 0
Date
Time
Server
Database
Kernel Version
Pages Transferred 0
Pages Left 0
# The values for Pages Transferred and Pages Left 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