Store DB2 data files and files other than data files on separate disks or in separate slices.
Note the following when performing this function:
Database
Back up using the BACKUP DATABASE command of DB2.
db2 => backup database DB name to target; |
[Database structure]
Drive/directory : The drive or directory specified by the CREATE DATABASE command
DB2 instance name : The owner name of a DB2 instance
Partition number of a database
Database ID
Default log directory of a database
Catalog table space
Temporarily table space
User table space
User table space
The user table space should be created on a RAW device rather than at file system level.
In the case of table space, the table space container is also a part of the backup, and hence please use the provided sample shell scripts.
The backup operation is performed using AdvancedCopy Manager.
The table spaces targeted for backup should be selected within the AdvancedCopy Manger's backup unit.
For example, if the unit of backup of AdvancedCopy Manger is a LUN, then 1 table space should lie on 1 LUN.
After the DB2 database has stopped, restore the database, and restart it. To recover the database to its latest state, use DB2's recovery function.
Note
When performing the restore, please use the following order
Database
User table space