In order to perform an online backups (ie no downtime) of IBM Connections DB2 databases, you will need to perform the following steps:
Note that databases configured this way cannot be restored to a higher version of DB2!
- Update DBs configuration to be ready for Online backups and to store only the latest backup in backup folder. Open a DB2 command window and issue following commands:
db2 update database configuration for BLOGS using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for DOGEAR using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for FILES using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for FORUM using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for HOMEPAGE using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for OPNACT using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for PEOPLEDB using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for SNCOMM using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
db2 update database configuration for WIKIS using LOGARCHMETH1 LOGRETAIN AUTO_DEL_REC_OBJ ON num_db_backups 1 rec_his_retentn 0
- To activate these new settings you have to stop and start your db instance:
db2stop
db2start
or use force flag if DB is locked
db2stop force
db2start
- Now backup your DBs to a folder (eg. D:\Backups):
db2 backup database BLOGS to D:\Backups
db2 backup database DOGEAR to D:\Backups
db2 backup database FILES to D:\Backups
db2 backup database FORUM to D:\Backups
db2 backup database HOMEPAGE to D:\Backups
db2 backup database OPNACT to D:\Backups
db2 backup database PEOPLEDB to D:\Backups
db2 backup database SNCOMM to D:\Backups
db2 backup database WIKIS to D:\Backups
- From now on do regular compressed backups of the DBs and include log files (do not forget to backup the folder with you backup agent):
db2 backup database BLOGS ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database DOGEAR ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database FILES ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database FORUM ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database HOMEPAGE ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database OPNACT ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database PEOPLEDB ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database SNCOMM ONLINE to Backups COMPRESS INCLUDE LOGS
db2 backup database WIKIS ONLINE to Backups COMPRESS INCLUDE LOGS