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.

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
vj wrote:
> 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.

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).


The Maxx wrote:
> 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
> vj wrote:
> > 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.

vj wrote:
> 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


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

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.

Serge Rielau wrote:
> vj wrote:
> > 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
>
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
>
> IOD Conference
> http://www.ibm.com/software/data/ond...ness/conf2006/

http://www-128.ibm.com/developerwork...206sqlref.html
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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