Backups on DB2 LUW
Backups can be processed in several ways and destinations.
|offine - no applications should be connected everybody should be offline except the backup utility||to file Storage (e.g. a backup folder)|
|online - applications are allowed, updates vduring backup should be taken care of||to Tivoli Storage (if any installed)|
Only users in group db2iadm1 will be allowed to run a backup. It is recommended to use the instance owner db2inst1 for this purpose.Depending on the environment and the DB Server structure (HADR, nonHADR, encryption, etc) a different set of commands will be used to run a successful backup.
A backup file is dedicated to be used on the OS it is produced. In case you want to move your data from AIX to a Windows based DB Server it won't work. This is due to the internal structure of a backup file produced on a specific operating system.
A simple backup of a given database may look like this (the example database is named "HHDB":
$ db2 backup database HHDB compress
This command will start with some defaults:
- The backup file will be created in the current directory. (Be sure you are in the correct folder)
- It will be an offline backup
- If it is taken on AIX it will be limited DB2 systems on AIX (Again: You can't migrate via backup, please keep in mind)
- It will contain archive logs (only if archive logging is activated in the configuration of the database)
- The restored database will be in ROLLFORWARD PENDING state
- Without ROLLFORWARD there will be no CONNECT possible
For a complete list of possible parameters and defaults in the current DB2 LUW version, please consult the Command Reference link below.
In order to check the backup file you created you may us the helpful command:
$ db2ckbkp -H <name_of backup_file>
This will provide information about the backup time, file format, structure and much more to stdout. (Use -H to suppress a complete walkthrough in the backup file, you would be bored.)For any problem you may experience: have a search on Amber Crook's Blog (see links below). I never had a problem that was not covered, interpreted and solved by Amber. She is a true coach and a source of wisdom when it comes to DB2 challenges. Follow her in social media, you will be impressed.