Parameters are available to specify the use of vendor products for backup and restore through these interfaces:
The Control Center is the GUI interface for database administration shipped with DB2. Information on invoking the Control Center is contained in the Command Reference.
Its use is documented through help panels provided with the interface. These should be reviewed to gain an understanding of the backup and restore tools that are part of the Control Center.
The following parameters are used to specify the use of vendor device
support:
| To Specify | Control Center 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 file name | 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 file name | not supported | not supported |
| Transfer buffer size | buffer-size | buffer-size |
Two API function calls are provided to support backup and restore: sqlubkp for backup (see sqlubkp - Backup Database), and sqlurst for restore (see sqlurestore - 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 sqlubkp and sqlurst) |
|---|---|
| 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 file name | In structure sqlu_media_list, specify a media-type of SQLU_OTHER_MEDIA, and then in structure sqlu_vendor, specify the file name using filename. |
| Transfer buffer size | BufferSize |