Db2 LUW Migration Windows to Linux

Jorg Lueke

Db2 LUW Migration Windows to Linux


We have a goal of migrating from a windows server to Db2 11 on RHEL 8. 

The main apparent issue is that DB2MOVE does not support spatial data and there is spatial data. The os change means a restore from a backup will not work. Has someone handled such a data move with a modicum of efficiency? 

Db2 Dba, Sysprog, Architect

https://www.linkedin.com/in/jorg-lueke-8b391b4/

Bill Gallagher

[External] Db2 LUW Migration Windows to Linux
(in response to Jorg Lueke)
Are you sure that restore from backup won’t work? I’m reading that RHEL 8 is little endian (at least on Power systems), as is Windows.

https://www.itjungle.com/2019/06/10/the-transition-to-rhel-8-begins-on-power-systems/

Bill Gallagher | Senior Systems Engineer, DBA

[cid:[login to unmask email]

[cid:[login to unmask email] http://www.facebook.com/travelers [cid:[login to unmask email] http://www.youtube.com/user/TravelersInsurance [cid:[login to unmask email] http://twitter.com/Travelers [cid:[login to unmask email] http://us.linkedin.com/company/travelers [cid:[login to unmask email] http://www.instagram.com/travelersinsurance [cid:[login to unmask email] https://www.pinterest.com/travelers

From: Jorg Lueke <[login to unmask email]>
Sent: Tuesday, June 16, 2020 11:58 AM
To: [login to unmask email]
Subject: [External] [DB2-L] - Db2 LUW Migration Windows to Linux

***External Sender - Please Exercise Caution***


We have a goal of migrating from a windows server to Db2 11 on RHEL 8.

The main apparent issue is that DB2MOVE does not support spatial data and there is spatial data. The os change means a restore from a backup will not work. Has someone handled such a data move with a modicum of efficiency?

Db2 Dba, Sysprog, Architect

https://www.linkedin.com/in/jorg-lueke-8b391b4/

-----End Original Message-----
________________________________
This message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited.

TRVDiscDefault::1201
Attachments

  • image001.png (5.6k)
  • image002.png (1.9k)
  • image003.png (1.8k)
  • image004.png (1.9k)
  • image005.png (1.8k)
  • image006.png (1.9k)
  • image007.png (2.1k)

Jorg Lueke

RE: Db2 LUW Migration Windows to Linux
(in response to Jorg Lueke)


This is RHEL on Intel Xeon. But it looks like Windows is considered its own family

 

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0005960.html

Db2 Dba, Sysprog, Architect

https://www.linkedin.com/in/jorg-lueke-8b391b4/

Greg Palgrave

RE: Db2 LUW Migration Windows to Linux
(in response to Jorg Lueke)

Hi Jorg,

You could perhaps look into setting up a Federated server connection from the Linux server to the Windows server, and then use a LOAD FROM CURSOR to get the data into the Linux server. I'm not sure if the spatial data can be loaded like this or needs any special handling, as I've not used it.

https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.admin.dm.doc/doc/c0005437.html

 

 

Cheers

Greg


In Reply to Jorg Lueke:


We have a goal of migrating from a windows server to Db2 11 on RHEL 8. 

The main apparent issue is that DB2MOVE does not support spatial data and there is spatial data. The os change means a restore from a backup will not work. Has someone handled such a data move with a modicum of efficiency? 

Db2 Dba, Sysprog, Architect

https://www.linkedin.com/in/jorg-lueke-8b391b4/

Jorg Lueke

RE: Db2 LUW Migration Windows to Linux
(in response to Greg Palgrave)

Thanks Greg. I've thought of that, the issue is that it isn't a very large system 10GB but it has a ton of tables. Nothing's ever easy is it :)

Greg Palgrave

RE: Db2 LUW Migration Windows to Linux
(in response to Jorg Lueke)

Hi Jorg,

Script it on the Linux side, loop through the tables - here's one example I found (but I wouldn't put the password in the script source):

https://www.epilis.gr/en/blog/2016/01/03/data-copy-between-databases-ibm-db2/

You could use a select query to build the list of tables, instead of typing them all in.

Perhaps spilt it into multiple jobs for tables A-F, G-L etc.

Hope you find a solution!


Cheers

Greg


In Reply to Jorg Lueke:

Thanks Greg. I've thought of that, the issue is that it isn't a very large system 10GB but it has a ton of tables. Nothing's ever easy is it :)