DB2 Plug-in

DB2 (IBM DB2) is a family of database servers developed by IBM. It provides stable relation-based database engine suitable for many commercial software, including business databases, web services etc.

Preparing your system for DB2 backup

To make your DB2 engine accessible for Handy Backup, you must specify first the environment variable providing the correct path to your DB2 SQL libraries. By default, this way is C:\Program Files\IBM\SQLLIB\lib, but it can be varied depending on installation considerations and settings.

All you must to do is to find environment variables called LIB and PATH on your Windows. Then write a character “;” at the end of each value string. After that, add the path C:\Program Files\IBM\SQLLIB\lib; for both strings. To find and edit environment variables, please perform the next actions depending on your system:

Advanced System Settings screen

Advanced System Settings screen in Windows 7

Environment variables list in Windows 7

Environment variables list in Windows 7

Changing the value of Path variable

Changing the value of PATH variable in Windows 7

 

 

 

 

After the variables are changed, you can back up or restore your DB2 data freely using DB2 plug-in. If you still have any troubles seeing DB2 plug-in operating, try to restart the computer; after the system loading up again, problems will be surely fixed.

Performing DB2 Backup

To make a backup, do the following:

  1. Select the Backup task in New Task Wizard.
  2. Select DB2 option on step 2 of New Task Wizard.

Now you will see the folder structure of DB2.

Select DB2
 

3. Choose the folders of DB2 for backup. You can select all the folders or only one/several of them. When you are ready, click OK.

Select DB2 data

4. Select destination for Backup.

Select option for backup destination, then click Next.

Select destination for Backup
 

Restoring

To restore DB2 from the backup, follow this instruction.

Read more about IBM DB2 Backup features.

 

User Manual contents

Who uses Handy Backup?