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.
Download Handy Backup and enjoy simple and efficient DB2 database backup. See download details...
Support for DB2 backup via ODBC is available in Handy Backup Professional edition, or can be added as an additional plug-in to Handy Backup Standard.
See order information on other editions of Handy Backup...
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!
Handy Backup Works Very Well for Database Backups
I love HB and it works very well for me and my referrals. It has a range of great features for database backup, highly recommended.
Handy Backup is certified for Windows Vista! Handy Backup is suitable for MySQL backup Handy Backup can run in Linux under Wine
My Documents backup - one click backup of the 'My documents' folder including pics, videos, music, text files Website backup - most reliable solution to protect your business's web representation Disk Image Backup - back up your hard drive by creating a hard drive image and saving it to the storage medium MySQL backup - simple, comprehensive backup of the MySQL database tables ODBC Database Backup - back up any ODBC compatible databases including MySQL, Oracle, FoxPro, Interbase, MSSQL, DB2, MS Access, Postgre SQL etc.
Backup to DVD-R - record your backups to DVD-R with our in-built DVD burning tool Backup to CD-R - record your backups to CD-R using data encryption and compression with one click Backup USB - back up your data to any USB connected device such as USB flash key Backup to FTP - transfer your backups to remote FTP server for more data security Backup from FTP - back up data stored on a remote FTP server to your local computer or any removable storage medium
Backup with ZIP compression - backup with 10 levels of Zip compression saves storage space DVD backup verification - makes sure your data are restorable from DVD copy you made Synchronizing files and folders - one click synchronization of files and folders across multiple locations including remote FTP servers


