Migrating DB2 UDB on Solaris 8 to DB2 UDB on Z/OS 7

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vj - 10 Jul 2006 17:16 GMT

I am currently facing a situation on migrating our DB2 UDB 8 Database
which sits on our AIX server to be migrated to DB2 UDB on mainframes
which is a version of 7.

I was not able to find any manuals on IBM site in relation to the
migration process from DB2 UDB on AIX to DB2 UDB on Z/OS. I am not sure
whether this might be a common situation anywhere else.

Could you please advise me on the issues which we needs to be taken
care or is there any guidelines which needs to be followed.

Thanks.

Vijay.

Reply to this Message

The Maxx - 10 Jul 2006 17:45 GMT

I know the db2relocate tool, but I'm not sure if that will do to down
grade the ambient.
Another posibilities is a restore redirect, but again could be some
issues about downgrade the your system.
Finally if you don't find anything relevant you could alwas use the
export/imort to plain files.

Regards,

Max

> I am currently facing a situation on migrating our DB2 UDB 8 Database
> which sits on our AIX server to be migrated to DB2 UDB on mainframes
[quoted text clipped - 10 lines]
>
> Vijay.

Reply to this Message

vj - 10 Jul 2006 18:09 GMT

I am more concerned on the impacts to Data Definition on the
Database(i.e Difference in Support for Data Types, Stored Procedures,
SQLs etc).

> I know the db2relocate tool, but I'm not sure if that will do to down
> grade the ambient.
[quoted text clipped - 20 lines]
> >
> > Vijay.

Reply to this Message

Serge Rielau - 10 Jul 2006 23:54 GMT

> I am more concerned on the impacts to Data Definition on the
> Database(i.e Difference in Support for Data Types, Stored Procedures,
> SQLs etc).

Data types shouldn't be an issue unless you are one of the rare kind
using OO (structured types, ref types, typed tables).
I'm not sure whether V7 had BIGINT.
If you use LOBs remember to add a ROWID column to the zOS tables.
That's about it on the data type side.
SQL procedures (I'm taking a guess here):
As long as you don't use nested BEGIN you should be OK.
SQL wise I'm not sure if DB2 V7 for zOS has scalar subqueries.
Also UNION in a nested query and such fancy stuff may get tight.
No OLAP support.
Hmmm.. that's what comes to mind.
If you went to DB2 V8 for zOS much better SQL wise..

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

vj - 13 Jul 2006 22:38 GMT

Thanks a Lot !!! I think this Input would definitely guide me in the
Data Migration Process.
Are you aware of any documents available online which would explain the
same in details.

Thanks again.

> > I am more concerned on the impacts to Data Definition on the
> > Database(i.e Difference in Support for Data Types, Stored Procedures,
[quoted text clipped - 22 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Serge Rielau - 14 Jul 2006 16:12 GMT

http://www-128.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sql
ref.html

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message