our company has decided to migrate database:
- from source Db2 Enterprise Server Edition v11.1 fixpack 5 on Linux/System-z (this is still Linux/Unix/Windows type of database despite running on System-z mainfraime)
- to Db2 Enterprise Edition v11.1 fixpack 5 on x86_64 (Intel/AMD).
Linux/System-z is big endian system and Linux/x86_64 is little endian system. There is no backup/restore option between bin/little endian Linux system.
The other option that I have read a lot about is combination of: db2look/db2move and a plenty of manual tasks. This seems pretty dangerous operation, because one little mistake and something may go terrible wrong when applications start using database on target system.
On PostgreSQL system there is build-in pg_dump tool. With this tool one single command dumps whole database (all objects: create database, create table, triggers, foreign keys, primary keys, etc including all of the data) into one single huge file, that can be easily transferred to target system and then one single command is executed on target system to get the database up and running. There are no manual interventions, tricks, procedures etc. Just two commands, one on source and one on target system. Is there something similar on Db2?
Is there any other way to move database between two Linux/endian systems except db2look/db2move? Some sophisticated tool or something?