This type of backup allows you to take a live backup, while users or processes are still connected to the database.
You do not need to schedule downtime for this task. Allow for sufficient space to hold backups and archived logs.
In this case we specify ONLINE
, which tells DB2 to perform an online backup:
[db2inst1@nodedb21 ~]$ db2 "BACKUP DATABASE POS ONLINE TO "/xchng/backups" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS UTIL_IMPACT_PRIORITY 20 INCLUDE LOGS WITHOUT PROMPTING" Backup successful. The timestamp for this backup image is : 20111125231539