Online Documentation for SQL Manager for DB2

Setting DB name and backup mode


This step of the wizard allows you to specify the database name, backup mode (location type) and backup directory.

 

Backup Database - Setting DB name and backup mode

 

 

Database

Use the drop-down list to select the database to backup.

 

Location type

Use the drop-down list to select the preferable location where a backup image will be created:

 

Local device

Select this mode to backup the database to the local machine.

 

Tivoli Storage Manager

Select this mode to backup the database to TSM server (using Tivoli Storage Manager output).

 

Vendor library

Select this mode if you wish to run the backup operation with the name of the shared library specified (DLL on Windows operating systems) containing the vendor backup and restore I/O functions to be used.

 

XBSA

Select this mode if you wish to run the backup operation with the XBSA interface used. Backup Services APIs (XBSA) is an open application programming interface for applications or facilities that need data storage management for backup or archiving purposes.

 

Backup directory or device names

Type in or use the ellipsis EllipsisButton button to specify the full path to the directory for backup files using the Browse dialog. Here you can enter a list of directory or tape device names. This target directory or device must exist on the database server.

 

Vendor DDL

The name of the shared library (DLL on Windows operating systems) containing the vendor backup and restore I/O functions to be used. It can contain the full path. If the full path is not defined the default path on which the user exit program resides will be used.

 

Click the Next button to proceed to the Setting backup options step of the wizard.