Hi All,

I am in the process of migrating an on prem DB2 database to GCP. The on prem DB2 server are windows and GCP Db2 servers are ubuntu 22.04. DB2 version is 11.5.9. Since the OS versions are different a simple backup and restore won't work. I am following the below guide to migrate (our application is Maximo)

How to move Maximo DB2 database between different platforms

The issue is the db2move export is taking a long time, as the current DB size is around 750GB? It is writing at 10-12GB per hour which is really slow and not a feasible approach for production migration. Any recommendations on how to tackle this migration and reduce the downtime required?

Abhinav

Try LOAD from CURSOR method - you will avoid writing intermediate files; did you try db2move export using pipes?

Hi All,

I am in the process of migrating an on prem DB2 database to GCP. The on prem DB2 server are windows and GCP Db2 servers are ubuntu 22.04. DB2 version is 11.5.9. Since the OS versions are different a simple backup and restore won't work. I am following the below guide to migrate (our application is Maximo)

How to move Maximo DB2 database between different platforms

The issue is the db2move export is taking a long time, as the current DB size is around 750GB? It is writing at 10-12GB per hour which is really slow and not a feasible approach for production migration. Any recommendations on how to tackle this migration and reduce the downtime required?

Abhinav

Hi Jan,

I am exploring that option, but it requires connectivity between the on prem and the gcp db2 servers correct? Also how fast is this as compared to db2move
I haven't tried the db2move using pipes will check it out?

Abhinav

Try LOAD from CURSOR method - you will avoid writing intermediate files; did you try db2move export using pipes?

Hi All,

I am in the process of migrating an on prem DB2 database to GCP. The on prem DB2 server are windows and GCP Db2 servers are ubuntu 22.04. DB2 version is 11.5.9. Since the OS versions are different a simple backup and restore won't work. I am following the below guide to migrate (our application is Maximo)

How to move Maximo DB2 database between different platforms

The issue is the db2move export is taking a long time, as the current DB size is around 750GB? It is writing at 10-12GB per hour which is really slow and not a feasible approach for production migration. Any recommendations on how to tackle this migration and reduce the downtime required?

Abhinav

Hi Jan,

I am exploring that option, but it requires connectivity between the on prem and the gcp db2 servers correct? Also how fast is this as compared to db2move
I haven't tried the db2move using pipes will check it out?

Abhinav

Try LOAD from CURSOR method - you will avoid writing intermediate files; did you try db2move export using pipes?

Hi All,

I am in the process of migrating an on prem DB2 database to GCP. The on prem DB2 server are windows and GCP Db2 servers are ubuntu 22.04. DB2 version is 11.5.9. Since the OS versions are different a simple backup and restore won't work. I am following the below guide to migrate (our application is Maximo)

How to move Maximo DB2 database between different platforms

The issue is the db2move export is taking a long time, as the current DB size is around 750GB? It is writing at 10-12GB per hour which is really slow and not a feasible approach for production migration. Any recommendations on how to tackle this migration and reduce the downtime required?

Abhinav

PS 

You really need connectivity between client and source and between client and target; you do not need connectivity directlyt between source and target.

Hi Jan,

I am exploring that option, but it requires connectivity between the on prem and the gcp db2 servers correct? Also how fast is this as compared to db2move
I haven't tried the db2move using pipes will check it out?

Abhinav

Try LOAD from CURSOR method - you will avoid writing intermediate files; did you try db2move export using pipes?

Hi All,

I am in the process of migrating an on prem DB2 database to GCP. The on prem DB2 server are windows and GCP Db2 servers are ubuntu 22.04. DB2 version is 11.5.9. Since the OS versions are different a simple backup and restore won't work. I am following the below guide to migrate (our application is Maximo)

How to move Maximo DB2 database between different platforms

The issue is the db2move export is taking a long time, as the current DB size is around 750GB? It is writing at 10-12GB per hour which is really slow and not a feasible approach for production migration. Any recommendations on how to tackle this migration and reduce the downtime required?

Abhinav

Hi Jan,

Thanks for the response

So just for clarification. If I have on prem machine A and GCP machine B, in order to use load from cursors or db2move using pipes I can provision a machine C on network, which should be able to connect to both GCP DB2 server and the on prem machine A correct?

Can you point me to some documentation or examples for this, that would be very helpful?

Abhinav

PS 

You really need connectivity between client and source and between client and target; you do not need connectivity directlyt between source and target.

Hi Jan,

I am exploring that option, but it requires connectivity between the on prem and the gcp db2 servers correct? Also how fast is this as compared to db2move
I haven't tried the db2move using pipes will check it out?

Abhinav

Try LOAD from CURSOR method - you will avoid writing intermediate files; did you try db2move export using pipes?

Hi All,

I am in the process of migrating an on prem DB2 database to GCP. The on prem DB2 server are windows and GCP Db2 servers are ubuntu 22.04. DB2 version is 11.5.9. Since the OS versions are different a simple backup and restore won't work. I am following the below guide to migrate (our application is Maximo)

How to move Maximo DB2 database between different platforms

The issue is the db2move export is taking a long time, as the current DB size is around 750GB? It is writing at 10-12GB per hour which is really slow and not a feasible approach for production migration. Any recommendations on how to tackle this migration and reduce the downtime required?

Abhinav