Parameters are available to specify the use of vendor products for backup and restore through these interfaces:
The Database Director is the GUI interface for database administration shipped with DB2. Information on invoking the Database Director is contained in the Command Reference.
Its use is documented through help panels provided with the director. These should be reviewed to gain an understanding of the backup and restore tools that are part of the director.
The following parameters are used to specify the use of vendor device
support:
| To Specify | Database Director Input Variables (for both Backup and Restore) |
|---|---|
| Use of vendor device and library name | Select Use Library, and specify the library name (on UNIX based systems) or the DLL name (on OS/2 or the Windows operating system). |
| Number of sessions | Sessions |
| Vendor options | not supported |
| Vendor filename | not supported |
| Transfer buffer size | For backup: Size of each Buffer For restore: not applicable. |
The Command Line Processor (CLP) is the non-GUI tool shipped with DB2 that can be utilized for database administration and other tasks. The BACKUP DATABASE and RESTORE DATABASE CLP commands are documented in the Command Reference.
The specification of vendor device support is handled by the following
parameters:
| To Specify | Command Line Processor Parameter | |
|---|---|---|
| for Backup | for Restore | |
| Use of vendor device and Library name | library-name | shared-library |
| Number of sessions | num-sessions | num-sessions |
| Vendor options | not supported | not supported |
| Vendor filename | not supported | not supported |
| Transfer buffer size | buffer-size | buffer-size |
Two API function calls are provided to support backup and restore: sqlubkup for backup (see sqlubkp - Backup Database), and sqlursto for restore (see sqlurst - Restore Database).
A number of parameters on these API calls support the invocation and
passing of data to the vendor device support functions:
| To Specify | API Parameter (for both sqlubkup and sqlursto) |
|---|---|
| Use of vendor device and library name | In structure sqlu_media_list specify a media-type of SQLU_OTHER_MEDIA and then in structure sqlu_vendor specify the shared library or DLL in shr_lib. |
| Number of sessions | In structure sqlu_media_list specify sessions. |
| Vendor options | PVendorOptions |
| Vendor filename | In structure sqlu_media_list specify a media-type of SQLU_OTHER_MEDIA and then in structure sqlu_vendor specify the filename using filename. |
| Transfer buffer size | BufferSize |