medium_label 
Use
You display the information stored on a data carrier about the backup.
See also:
Glossary, 
Backup
IDs
Prerequisites
● You have the server authorization Backup.
● You have opened a database session (see db_connect).
● The database instance is in the ONLINE or ADMIN operational state.
Syntax
medium_label <medium_name>
<medium_name> |
Name of backup
template from which information is to be read |
Reply
OK
Returncode <value>
Date [<value>]
Time [<value>]
Server [<value>]
Database [<value>]
Kernel Version [<value>]
Pages Transferred [<value>]
Pages Left [<value>]
Volumes [<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>]
Database ID [<value>]
Max Used Data Page [<value>]
You should in particular analyze the
Returncode reply field, which contains a numeric value
supplied by the kernel.
See also: Messages
Values for the Reply Fields
Field |
Description |
Returncode |
Return code of the Database Manager If the value is 0, the DBM command has been executed successfully. For any other value
see: |
Date |
Date |
Time |
Time |
Server |
Name of the database computer |
Database |
Name of the database instance |
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 backup templates 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 |
Time stamp for first page of log backup |
DB Stamp 2 Date |
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 |
Max Used Data Page |
Highest page number assigned (indication of minimum database size when backup is imported) |
In the event of errors, see Reply Format.