urphy's Law states that if something can
go wrong, it will
. It is comforting to know that you can guard against at least some calamities. In the case of IBM® DB2® Universal Database, the mere notion of your database data being deleted or somehow corrupted might cause some sleepless nights. Thankfully, DB2 has built-in features for performing backups of your precious data. This 10-Minute Solution explains and demonstrates these features, which give you at least one less thing to worry about.
Requirements: The instructions in this 10-Minute Solution assume that you have a user on your machine named db2admin with a password of db2admin and the appropriate privileges: SYSADM, SYSCTRL, and SYSMAINT.
How do I ensure that the critical data stored in my DB2 database isn't lost forever when data loss or corruption occurs?
Use DB2's built-in backup and recovery features to recover critical data from loss or corruption.