Performing Full Backup

IBM Db2 supports the following types of full backups:

• Offline backup
• Online backup

Offline Backup

To back up database offline, do the following steps:

1. Offline backup requires downtime. During the downtime, the database is offline and inaccessible to applications. To prepare the database, do the following steps:

1. Find all the applications with existing connections to IBM Db2.

This command returns a list of all existing connections. To stop these connections, you can close the applications manually or you can disconnect all connections to all IBM Db2 databases with the following command:

2. Deactivate the database you want to back up offline with the following commands:

where <database_name> is a name of the database you want to deactivate.

2. Back up the database offline with the following command:

where <database_name> is a name of the database you want to back up.

3. Re-activate the database.

where <database_name> is a name of the database you want to deactivate.

Online Backup

To back up database online, do the following steps:

1. Before you back up database online, check if you set Veeam Plug-in to use the logarchmeth1 parameter.

If you have not configured the logarchmeth1 parameter during the Veeam Plug-in configuration, you can configure the parameter using DB2ConfigTool:

Alternatively, you can re-configure the database with the following command:

where <database_name> is a name of the database you want to back up.

2. Back up the database online with the following command:

where <database_name> is a name of the database you want to back up.

If you want to include logs in the backup, you can use the INCLUDE LOGS option with the BACKUP DATABASE command:

where <database_name> is a name of the database you want to back up.

To learn more about the INCLUDE LOGS option, see this IBM article.