Any idea on taking backup DB2 db to azure cloud

Question

i have a DB2 database in Azure.

im not sure on how to backup the db2 to Azure

Any advice is appreciated thanks .

Answer 1

Hi there Shakir

thanks for posting on QandA platform

I found a similar thread and ave a look at it and let us know if it helps

https://learn.microsoft.com/en-us/answers/questions/1651071/how-to-backup-db2-database-on-azure-cloud

If This helps kindly accept the answer thanks much.

Answer 2

You may want to consider a VM level backup using Azure Recovery Services Vault.

You can also consider to put that installation on high availability configuration and backup databases having as destination the stand by server. You can find instructions here.

You can also consider using 3rd party tools to backup your DB2 databases like Veeam. Veeam supports backups to resources on Azure platform as explained here.

Answer 3

Hi Shakir •,

Welcome to Microsoft Q&A forum.

As I understand, you want to know on how on taking backup DB2 db to azure cloud.

You can perform DB2 on Azure configuration by following the standard IBM documentation:

https://www.ibm.com/docs/en/db2/11.5?topic=azure-planning-your-db2-configuration

Also refer to https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/db2-to-sql-database-guide?view=azuresql for migration of IBM DB2 to Azure SQL Database.

SQL Server Migration Assistant (SSMA) for DB2 is a comprehensive environment that helps you quickly migrate DB2 databases to SQL Server or Azure SQL Database. By using SSMA for DB2, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server or Azure SQL Database, and then migrate data to SQL Server or Azure SQL Database. You can't migrate SYS and SYSTEM DB2 schemas.

Let us know if above mentioned information helped.

If not, please let us know more on the requirement so that we can assist.

Thanks