It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,686
×7,316
×4,663
×3,952
×118
×83

question asked: Jan 13 '14, 12:58 p.m.
question was seen: 7,070 times
last updated: Jan 14 '14, 8:07 a.m.

Related questions

FAQ - How this Forum works

Need Instructions for migrating CLM database from DB2 on AIX to DB2 on Linux

0
Saurabh Malhotra (152●3●16●17) | asked Jan 13 '14, 12:58 p.m.
The instructions in the infocenter are for migrating from one database vendor to a different vendor:  http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_migrate_dbs.html&scope=null

Are these the same steps that one should follow when staying with DB2 but moving from AIX to Linux?

Would a regular database backup / restore also work? if not, what kind of issues might it cause?

Thanks!
Comments
Daniel Vaganek commented Jan 14 '14, 8:07 a.m.

Thank you Saurabh and Kevin!  Are there any documented steps to do this type of migration? 

Accepted answer

3
permanent link
Kevin Ramer (4.5k●8●178●197) | answered Jan 13 '14, 3:15 p.m.
edited Jan 13 '14, 3:20 p.m.
DB2 Backup/restore between platforms will not work -- this a DB2 thing.  Alternately, db2move utility to export/import the database might work.   As a last resort the repotools-xxx -export to export from current DB2 platform followed by repotools-xxx -import should work albeit at the expense of many, many hours.  Said another way:  Were I performing this I would try the db2move export on aix, copy data files, db2move import on linux side.  And only resort to the repotools if the move fails.

repotools-xxx should be according to the CLM application being exported.  repotools-jazz, repotools-ccm, repotools-qm, etc.




Saurabh Malhotra selected this answer as the correct answer
Comments
Saurabh Malhotra commented Jan 14 '14, 7:09 a.m.

Thanks Kevin! 

Saurabh Malhotra commented Jan 14 '14, 7:14 a.m.

Actually could you explain a bit further as to why the DB2 Backup/restore won't work? Are there differences in DB2 on AIX vs Linux?

1
Kevin Ramer commented Jan 14 '14, 7:55 a.m.

Saurabh,
I don't know the real "why" as it was probably a design choice by DB2 development.  I'm sure there are technical reasons (e.g. tablespace container implementation, byte order, etc).  That backup files aren't cross-platform compatable is why the db2move utility exists.


Your answer

Register or to post your answer.