db2move between AIX DB2 V7 and SUSE 10 DB2 V9

[d***@us.ibm.com]

Hello,<br />
<br />
We want to migrate a (SAP) database from AIX DB2 V7 to SUSE 10 DB2 V9.<br />
We are thinking about using the db2move to do this.<br />
Is this possible? We know its possible from AIX to SUSE, but we don't know about from V7 to V9.<br />
The database has size from about 400GB. And probably something like 30000 tables. It’s also a migrate from big endian naar little endian.<br />
<br />
Regards<br />
Peter

[Kelly Schlamb]

Hi,<br />
<br />
I'd actually suggest contacting SAP to see what they recommend. They may already have some experience with doing this type of thing and can offer you their own supported way (from an SAP point of view) of doing the move.<br />
<br />
Regards,<br />
Kelly

[d***@us.ibm.com]

Well the recommand us to the R3LOAD tool, but this tool is running a weekend with no result. The database is 400GB big, its not small, but it is not that big that he will need more than 3 days for a export?

[Knut Stolze]

Post by d***@us.ibm.com
Well the recommand us to the R3LOAD tool, but this tool is running a
weekend with no result. The database is 400GB big, its not small, but it
is not that big that he will need more than 3 days for a export?

SAP recommends indeed that you backup your database through the application
(SAP R/3) and don't do this at the database level. You should give it a
try on your test system to see how long the full process would take.

Something else to consider may be unicode support (if you don't have it
already). Then your only option is to go through R/3. Maybe you could do
both together and, thus, reduce the overall impact?

[Mark A]

Post by d***@us.ibm.com
Hello,<br />
<br />
We want to migrate a (SAP) database from AIX DB2 V7 to SUSE 10 DB2 V9.<br />
We are thinking about using the db2move to do this.<br />
Is this possible? We know its possible from AIX to SUSE, but we don't know
about from V7 to V9.<br />
The database has size from about 400GB. And probably something like 30000
tables. It's also a migrate from big endian naar little endian.<br />
<br />
Regards<br />
Peter

Please use text format in your newsreader. It is poor etiquette to use
anything else, since 99% of people can only see text and we don't like to
see your html tags.

You can use db2move with no problem since it exports in IXF format. I have
moved databases from AIX (big endian) to Linux (little endian) many times.

If you have any LOB's be sure to use the appropriate db2look options to
export/import them to/from a separate 001 file. If you don't use the proper
LOB file options these columns may be truncated at 32K.

Obviously (I hope) you have already built the schema with db2look, since the
replace_create option does not create all the objects in the original
schema. I don't know of any DB2 V7 language elements that will not work in
V9, but you will find out when you create the new schema before the db2move.

[Will Honea]

Post by Mark A

Post by d***@us.ibm.com
Hello,<br />
<br />
We want to migrate a (SAP) database from AIX DB2 V7 to SUSE 10 DB2 V9.<br />
We are thinking about using the db2move to do this.<br />
Is this possible? We know its possible from AIX to SUSE, but we don't
know about from V7 to V9.<br />
The database has size from about 400GB. And probably something like 30000
tables. It's also a migrate from big endian naar little endian.<br />
<br />
Regards<br />
Peter

Please use text format in your newsreader. It is poor etiquette to use
anything else, since 99% of people can only see text and we don't like to
see your html tags.
You can use db2move with no problem since it exports in IXF format. I have
moved databases from AIX (big endian) to Linux (little endian) many times.
If you have any LOB's be sure to use the appropriate db2look options to
export/import them to/from a separate 001 file. If you don't use the
proper LOB file options these columns may be truncated at 32K.
Obviously (I hope) you have already built the schema with db2look, since
the replace_create option does not create all the objects in the original
schema. I don't know of any DB2 V7 language elements that will not work in
V9, but you will find out when you create the new schema before the db2move.

One thing I found when I went 7.2->9.1 was that views are not transferred by
db2look. This may have been the specific version (OS/2) I was moving from,
but I did have to re-create my views and with that many tables I would bet
you have a few of them <G>.

[Mark A]

Post by Will Honea
One thing I found when I went 7.2->9.1 was that views are not transferred by
db2look. This may have been the specific version (OS/2) I was moving from,
but I did have to re-create my views and with that many tables I would bet
you have a few of them <G>.
--
Will Honea

It may be have been a bug in db2look, of which several existed in V7. Might
be a good idea to upgrade to the latest V7 fixpack before running db2look.

[Will Honea]

Post by Mark A

Post by Will Honea
One thing I found when I went 7.2->9.1 was that views are not transferred by
db2look. This may have been the specific version (OS/2) I was moving from,
but I did have to re-create my views and with that many tables I would
bet you have a few of them <G>.
--
Will Honea

It may be have been a bug in db2look, of which several existed in V7.
Might be a good idea to upgrade to the latest V7 fixpack before running
db2look.

The server was as up-to-date as possible but yes, it could easily have been
a version problem. The OS/2 version was dropped as of V8, but I've seen
this on at least one other LUW version when we migrated a test copy from
V7.2 on windows. Not a big deal and relatively simple to work around,
especially if you test it first and are prepared for it but it can cause
some head scratching if it catches you unaware. AIR, the V7 tollbox has at
least one screen where you can get a cut and paste copy of the DDL needed
to re-create the view. The rest of the move was pretty much a case of
punch the button and wait for it to finish.

One workaround that worked here was to install V8 on a third-party machine,
catalog the V7 databases, and run db2move from the remote V8 client. The
V9 client doesn't play nice with V7, at least the OS/2 version, best I can
tell but it might work against the AIX V7.

[d***@us.ibm.com]

Hello,<br />
<br />
The most important question is; Is it possible for this migration to use db2move?<br />
<br />
Regards<br />
Peter

[Mark A]

Post by d***@us.ibm.com
Hello,<br />
<br />
The most important question is; Is it possible for this migration to use db2move?<br />
<br />
Regards<br />
Peter

Yes.