DB2 Backup via ODBC or DB2 API

DB2 is one of the leading Database Management Systems (DBMS) worldwide. It is widely used in different fields of industry ranging from small businesses to aerospace and defense. Performing regular DB2 database backups must be an essential element of your information and business safety policy.

Handy Backup provides two ways of backing up DB2 databases: using a general Database Backup plug-in which backs up database tables through the use of standard ODBC drivers, and a more advanced DB2 Backup plug-in which gives much more accurate results but requires Handy Backup (or Backup Network Workstation in Handy Backup Server scheme) to be installed on the server with DB2 database. This page describes the first approach. Follow the link to learn about DB2 backup plug-in and IBM's Ready for IBM DB2 Data Server Software certification logo...

The Database Backup plug-in in Handy Backup lets you set up DB2 backup tasks in just a couple of minutes and then repeat them automatically on a regular basis. Depending on your data protection strategy, you can set up DB2 backup tasks separately or as a part of a bigger task, e.g. combined DB2 and MS Exchange backup. Handy Backup can reliably back up your DB2 databases and save you from data loss or damage.

Features of DB2 backup

Handy Backup offers you the following attributes to back up your DB2 databases:

• Flexible backup scheduler – once you’ve set up a backup plan, you may no longer pay attention to the backup routine, as the program will do it all for you.


• Selective DB2 backup – the program allows you to back up all tables contained in the selected DB2 database or only selected ones.


• Wide access rights – ODBC interface lets you perform DB2 backup and restore procedures even from/to remote machines and without administrator’s rights.


• Backup verification – Handy Backup can automatically verify integrity of your DB2 copies when you backup to CD, DVD, HD DVD and Blu-Ray disks to avoid unexpected data corruption.

Backing up DB2 with Handy Backup

Handy Backup can completely automate all DB2 backups and has the following options to ease the process:

• Back up DB2 to remote locations – to increase safety of your backups, the program has an integrated interface for exchanging data with FTP and SFTP locations. You can also take advantage of our Remote Backup Service – and be 100% sure about your data.


• Backup compression – use multi-level ZIP compression to minimize the use of your storage space.


• Encrypt your DB2 backup – protect your business information from unauthorized access through encrypting it with an unbreakable 128-bit algorithm.


• E-mail notifications – with this option enabled, you will stay informed about backup results and possible errors simply by reading your mailbox.

Handy Backup allows you not only to create DB2 backups, but also to perform MySQL backup, Oracle backup, MSSQL backup, MS Access backup, PostgreSQL backup, FoxPro backup, Interbase backup and much more (see database backup restrictions).

To learn more about DB2 backup via ODBC, please refer to Database Backup in the User Manual.

For a full list of features of the program, please read Handy Backup features.

Handy Backup is an irreplaceable tool when it comes to DB2 backup!