Is there a way to automate IBM AIX DB2 (LUW) 11.1 migration to Red Hat Linux cloud

[saechira]

Hi Team

Can anyone please advise if automation is feasible for DB2 data migration from AIX to Red hat Linux ? Due to Little and Big Indian compatibility issues , migration of huge databases ( TB) is a potential problem, demanding high implementation time.  Also, any reference to DB2 migration documentation that could help us understand the challenges/measures involved is highly appreciated. Thank you in advance

[HKarim]

Hi, there is an IDUG Presentation from Dale McInnis (IBM Toronto Lab) with title "Migrating DB2 from AIX to X86 Linux".  As you mentioned, it's a big endian to little endian Migration, Backup and Restore doesn't work. There are 3 different approach to do that. DB2Move, DB2 High Performance Unload, or using a Q-Replication. Depenging on which approach, you can automate the whole setup with shell or ansible. AFAIK there is no ready-to-use-solution for that.