db2move between AIX DB2 V7 and SUSE 10 DB2 V9

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 />

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 />

<dwforums@us.ibm.com> wrote in message 
news:805632697.1195747670853.JavaMail.wassrvr@ltsgwas009.sby.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. 

Mark A wrote:

> <dwforums@us.ibm.com> wrote in message
> news:805632697.1195747670853.JavaMail.wassrvr@ltsgwas009.sby.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>.

--