Background documentationmedium_labeloffline Locate this document in the navigation structure


With this command you can display information required to identify a backup that you want to use, for example, to restore the database.

You can indicate the backup from which information is to be displayed, either by the name of the backup template or by the specificaction of the data carrier.

To indicate the name of the backup template, a connection to the relevant database must exist (logged on with –d). The operational state of the database is irrelevant.

If you specify a data carrier, you can display the label of any backup, regardless of whether a connection to the database is available.


You have the server permission Backup.


medium_labeloffline <name> | <location_spec>

<name> :: = <medium_name> [<nnn>]

<location_spec> :: = <device | file> <media_spec>

<media_spec> :: = <type_spec> [<blocksize_spec>] | <blocksize_spec>

<type_spec> :: = [DEVICETYPE] <device_type>

<device_type> : = FILE | TAPE | PIPE

<blocksize_spec> :: = BLOCKSIZE <block_size>





Name of the backup template


Only for log backup and only for backup media of the FILE type:

Version number of the log backup on the data carrier

<device | file>

Data carrier


Number of pages transferred when the data carrier is accessed

Specify the block size used to create the backup.

If you do not enter any block size, the system default (8) will be used.


Data carrier type

Possible values are: FILE | TAPE | PIPE

FILE: file

TAPE: tape

PIPE: pipe

The system default is FILE.

In the event of errors, see Reply Format.



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>]

Database ID [<value>]

Max Used Data Page [<value>]

Values for the Reply Fields




Return code of Database Manager

If the value is 0, the DBM command has been executed successfully.

For any other value, see Messages.


Date of the backup


Start time of the backup


Name of the database computer


Name of the database

Kernel Version

Version of the database software

Pages Transferred

Number of pages transferred

Pages Left

Number of pages still to be transferred


Number of backup templates used


Name of the backup template


File or device name


Error message text


Backup ID

Is Consistent

Only for data backup:

Backup is internally consistent

First LOG Page

For data backup: first page of log backup to be read

For log backup: first page saved in log

Last LOG Page

Only for log backup:

Last page saved in log

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

Max Used Data Page

Highest page number assigned (indication for minimum database size when backup is imported)

More Information

Glossary, Backup ID