Moving RTC DB2 database from Linux to Z/OS
I am looking to move my RTC database from DB2 Linux to DB2 Z/OS. What is the best way to go about this?
|
2 answers
Considering that the migration is from DB2 Linux to DB2 zOS, is it really required to do the export and import through repotools? Isn't repotools required only when moving from one database vendor to another?
I am planning to use the standard DB2 backup and restore procedures instead of using repotools. Should I reconsider it? Is there any negative sides in my approach?
Comments
Kevin Ramer
commented May 27 '14, 8:46 a.m.
Well, I've no DB2 on Z/OS experience, but I'm certain that one cannot restore db2 backup files across operating systems that I've used I.e. no windows backup restore to Linux; linux <> AIX, etc.
Andre, you have to check the DB vendors documentation in general. DB2 does for example not support just backup/restore for 32->64 bit and big endian->little endian, as far as I know. There is documentation abut when this is supported. Changing architectures is often a problem.
Andre Gusmao
commented May 27 '14, 10:09 a.m.
Thanks Kevin and Ralph. I found another post that makes it very clear that DB2 standard backup/restore do not work across different platforms. He suggests the use of DB2 utility db2move, and in last case, repotools.
|
The general steps for migrating databases is in the help here:
https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_migrate_dbs.html&scope=null
For Z/OS it is very important to ensure that when the tar file is transferred from the Linux system to the Z/OS system that the file is transferred via the binary format. Otherwise the tar file will become corrupted and will not be importable via the RTC repotool import.
~Spencer
Comments
Kevin Ramer
commented Apr 08 '13, 3:51 p.m.
Transfers of tar files in general should be done with ftp binary. But if you have scp (why not) you'll never have to worry about that again.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.