Background documentationmedium_getall Locate this document in the navigation structure

 

You display the list of all defined backup templates.

Prerequisites

You have the server authorization Backup or DBInfoRead.

Structure

medium_getall

Result

OK

<medium_name> <location> <type> <backup_type> <size> <block_size> <overwrite> <autoldr> <oscmd> <date_created> <date_modified> <tool_type>

<medium_name> <location> <type> <backup_type> <size> <block_size> <overwrite> <autoldr> <oscmd> <date_created> <date_modified> <tool_type>

...

Values for the Reply Fields

Value

Description

<medium_name>

Name of the backup template

Can comprise a group name and a member name, separated by a slash.

<location>

Name of the device/file with which it can be addressed through operating system functions

<type>

Type of backup template

Possible values are:

TAPE | FILE | NO-REWIND | PIPE | AUTOLOADER | UNKNOWN

<backup_type>

Type of backup for which the backup template is to be used

Possible values are:

DATA | PAGES | LOG

<size>

Maximum number of pages that can be written to the data carrier

<block_size>

Number of pages transferred when the data carrier is accessed

<overwrite>

Indicates whether the data carrier can be overwritten (for the FILE template type only).

Possible values are: NO | YES

<autoldr>

Indicates whether the device changes the data carrier automatically.

Possible values are: YES | NO

<oscmd>

Operating system command to be executed before backup_save_replace or backup_restore_replace.

<date_created>

Date and time at which the backup template was created

<date_modified>

Date and time at which the backup template was last changed

<tool_type>

Type of the backup tool

Possible values are: NONE | BACK | NSR | TSM

NONE: No backup tool is used.

BACK: Backint for Oracle

NSR: NetWorker

TSM: TSM by IBM/Tivoli

In the event of errors, see Reply Format.

More Information

Database Administration, Backup Templates and Data Carriers