Backup Software / Support / User Manual v8 / Technologies / Plug-ins / Data Source and Storage / DB2 Plug-in

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:

For Windows 7, click Start -> Computer -> Properties -> Advanced System Settings -> Environment Variables.

Advanced System Settings screen in Windows 7

Environment variables list in Windows 7

Changing the value of PATH variable in Windows 7

For Windows XP, click Start -> Control Panel -> System and go to the Advanced tab. Find the option Environment variables, and change variables LIB and PATH as described above.

For Windows Server 2008 you must be eligible to change system variables before you try. Go to Control panel -> System and Security -> System and then jump to Advanced tab for original 2008 version, or click the “Advanced system settings” on Windows Server 2008R2. Then change variables LIB and PATH as described above.

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.