Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to use DB2 Express-C edition with my application. I have never used DB2 but now want to use the Express Edition in a production environment to learn more about it.

I want to know what are the various backup options available in the Express Edition. In case of a sudden Windows DB2 service failure, how to recover data files?

Is there a way to just copy data files from one PC and attach on another instance of DB2 running on another PC?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

Well, DB2 has a backup/restore system, and this allows to make full, incremental and delta backups. For more information about this, you can take a look at: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.ha.doc/doc/c0005945.html

However, if you want to do a clone of the database, by just copying the data files, you could use the split mirror feature. This feature will stop all IO writes to the database, and you just have to copy the tablespaces and database files into other disk and voila. For more information about spli mirroring: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.ha.doc/doc/t0006422.html This feature uses the "set write"command: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0009503.html

Other recent features in DB2 includes the possibility to merge backups, restore tables, and more characteristics that are part of the DB2 recovery expert: http://www-01.ibm.com/software/sw-library/en_US/detail/W269469I30015Y81.html

share|improve this answer

As a DB2 backup software for Windows and Linux you can use Handy Backup. It has hot backup and recovery - it backs up DB2 database data without stopping. Also you can choose full, incremental or differential DB2 backup, exactly what you need.

share|improve this answer
You should disclose any affiliation with the item you link to (if there is in fact any affiliation!). –  Max Vernon Oct 25 '13 at 15:12
How is this tool different than just being wrapper for the commands in the answer already provided (and accepted)? –  Ian Bjorhovde Oct 25 '13 at 16:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.