DB Migrate from AS/400 DB2 to SUSE Linux x8664 DB2 UDB
Database migration from AS/400 DB2 to SUSE Linux 10.2 x8664 DB2
1) We have DB2 on AS/400 mainframes. The schema has no foreign keys & check constraints. But
there are DEFAULT, PK, UK & Indexes.
2) Same schema bar a few tables will be created using converted to Linux specific DDL. Hence,
the column mapping will be little complex. Transformations are unlikely.
3) What are the best ways that data can be migrated from AS/400 DB2 to Linux DB2?
4) Consider both cases i.e. it is a one time migration OR there maybe repeated incremental
migrations.
5) Both existing/source database in AS/400 and new/target database in Linux are/will be OLTP
ones & for some period both will be running with existing/new application connecting to them.
6) Will DB2 on AS/400 be much different than DB2 UDB on Linux? Are there any features that may
affect any route of migration?
7) In Linux, we can have shell scripts embedding DB2 scripts with error handling and scheduling
to do the job smoothly. What can there if migration is run/scheduled/controlled from AS/400?
This is unlikely though since AS/400 DB2 will be production one.
8) How will DB2Connect client/gateway i.e. server play a role in migration?
9) Can we use nicknames i.e. distributed computing to do migration? What are the pros & cons
involved?
10) There are 215 tables in all, 5 having 60-70 lakh records, 5 having 30-40 lakh records, 15
having 5-10 lakh records and most having less than 1 lakh records?
11) Client is unlikely to go for any migration/ETL tools except if existing DTS &
SSIS(SQL Server).
12) Please post links if required.
1) We have DB2 on AS/400 mainframes. The schema has no foreign keys & check constraints. But
there are DEFAULT, PK, UK & Indexes.
2) Same schema bar a few tables will be created using converted to Linux specific DDL. Hence,
the column mapping will be little complex. Transformations are unlikely.
3) What are the best ways that data can be migrated from AS/400 DB2 to Linux DB2?
4) Consider both cases i.e. it is a one time migration OR there maybe repeated incremental
migrations.
5) Both existing/source database in AS/400 and new/target database in Linux are/will be OLTP
ones & for some period both will be running with existing/new application connecting to them.
6) Will DB2 on AS/400 be much different than DB2 UDB on Linux? Are there any features that may
affect any route of migration?
7) In Linux, we can have shell scripts embedding DB2 scripts with error handling and scheduling
to do the job smoothly. What can there if migration is run/scheduled/controlled from AS/400?
This is unlikely though since AS/400 DB2 will be production one.
8) How will DB2Connect client/gateway i.e. server play a role in migration?
9) Can we use nicknames i.e. distributed computing to do migration? What are the pros & cons
involved?
10) There are 215 tables in all, 5 having 60-70 lakh records, 5 having 30-40 lakh records, 15
having 5-10 lakh records and most having less than 1 lakh records?
11) Client is unlikely to go for any migration/ETL tools except if existing DTS &
SSIS(SQL Server).
12) Please post links if required.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oops.
Hi Momi.... Didn't mean to repeat your answers.
Kent
ASKER
Thanks, momi & kent. One last point which I did not copy paste in the first place from text editor.
Does AS/400 DB2 also has to be 64 bit if the OS itself is? I am asking since existing target Linux is 64 bit i.e. x8664 i.e. will 32 bit data from 32 bit OS + DB2 go into target 32 bit OS + DB2 & same is the case with 64 bit or there is a bit conversion possible just as DB2Connect converts z-series & i-series mainframes EBCDIC Encoding to Unix, Linux & Windows ASCII Encoding and the other way round as well.
Does AS/400 DB2 also has to be 64 bit if the OS itself is? I am asking since existing target Linux is 64 bit i.e. x8664 i.e. will 32 bit data from 32 bit OS + DB2 go into target 32 bit OS + DB2 & same is the case with 64 bit or there is a bit conversion possible just as DB2Connect converts z-series & i-series mainframes EBCDIC Encoding to Unix, Linux & Windows ASCII Encoding and the other way round as well.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
3) Federated computing(different RDBMS) & distributed computing(same RDBMS) in our case can be used to migrate data as insert into <schema>.table select * from <nickname> OR insert into <nickname> select * from <schema>.<table>. But can we export from a nickname and load into a nickname?
6) Will DB2 on AS/400 be much different than DB2 UDB on Linux? Are there any features that may
affect any route of migration? The first you answered but not the second.
7) In Linux, we can have shell scripts embedding DB2 scripts with error handling and scheduling
to do the job smoothly. What can there if migration is run/scheduled/controlled from AS/400? Question remains unanswered.
12) How can .IXF files let us say be transferred from AS/400 to Linux and LInux to AS/400?