Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Moving RTC DB2 database from Linux to Z/OS

Questions
Tags
Users
Badges
Spencer Murata
FORUM MODERATOR / JAZZ DEVELOPER (2.3k●11●59●71) Apr 08 '13, 3:23 p.m.
 I am looking to move my RTC database from DB2 Linux to DB2 Z/OS.  What is the best way to go about this?

0 votes

2 answers
7,695 views
0 votes

2 answers

Permanent link
Spencer Murata
FORUM MODERATOR / JAZZ DEVELOPER (2.3k●11●59●71) Apr 08 '13, 3:26 p.m.
 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

0 votes

Comments
Kevin Ramer
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.

Permanent link
Andre Gusmao
(80●26●40) May 26 '14, 11:27 a.m.
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?

0 votes

Comments
Kevin Ramer
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.




Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER May 27 '14, 9:55 a.m.

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
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.
https://jazz.net/forum/questions/138425/need-instructions-for-migrating-clm-database-from-db2-on-aix-to-db2-on-linux
 

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 2,358
× 119
× 84
× 82
× 69

Question asked: Apr 08 '13, 3:23 p.m.

Question was seen: 7,695 times

Last updated: May 27 '14, 10:09 a.m.

Confirmation Cancel Confirm