Enabling online backup of the Db2 databases
By default, the Cloud APM Db2® databases are configured for offline backup, which means database activity must be stopped before you run a backup. You can enable an online backup of the Db2 databases to run in the background. While the online backup is running, applications can continue to access the database so no downtime occurs.
About this task
Several backup options are available for Cloud APM Db2 databases, so the solution that is included in this task might require modification for specific environments.
To enable online backup, modify the database configuration. This example
specifies a configuration for full
backup. Full backup requires substantial disk space and takes more time because the entire database
is being backed up each time. Db2 provides a
means for incremental backup that has several options.
- For more information about configuring incremental backup, see Incremental backup and recovery and Restoring from incremental backup images.
- For descriptions of the Db2 configuration parameters that are used in this task, see DB2® database configuration parameters.
- If you need to access any other Db2 documentation, see IBM® Db2 10.5 for Linux®, Unix and Windows topic collection on IBM Knowledge Center.
You can use the following Db2 configuration parameters for online backup configuration. All these parameters are optional
except the LOGARCHMETH1 parameter, which is mandatory.
- LOGARCHMETH1
- This mandatory parameter specifies the media type. Change the drive that is specified on this property to an appropriate directory.
- AUTO_DEL_REC_OBJ
- This optional parameter specifies whether database log files, backup images, and load copy images must be deleted when their associated recovery history file entry is pruned.
- REC_HIS_RETENTN
- This optional parameter specifies the number of days that historical information about backups is retained.
- NUM_DB_BACKUPS
- This optional parameter specifies the number of full database backups to retain for a database.
- LOGARCHCOMPR1
- This optional parameter specifies whether the log files that are written to the primary archive destination for logs are compressed.
Tip: The following procedure enables log files to
be archived on the disk permanently. You can prune the history and log files with some Db2 commands. For more information, see PRUNE HISTORY/LOGFILE.