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

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.

Jul 10 '06 #1

Subscribe Post Reply

1615

The Maxx

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.

Jul 10 '06 #2

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.

Jul 10 '06 #3

Serge Rielau

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/

Jul 10 '06 #4

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/

Jul 13 '06 #5

Serge Rielau

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/

Jul 14 '06 #6

Similar topics

Building Imaging-1.1.4 on Solaris 9

by: Mark Nelson | last post by:

Hi I'm trying to build Imaging 1.1.4 in Solaris 9, I get passwd the first step i.e the building of libImging. However when I execute a python setup.py build I get the following error - gcc...

Python

Issues migrating from Solaris to RedHat 9?

by: Tom Loredo | last post by:

Hi folks- I'm about to move from a Solaris 8/SPARC environment to a Dell running RedHat 9. Are there any issues I need to be aware of in bringing my Python code over (mostly scientific...

Python

Problem when migrating DB from v7 to v8

by: Deacon | last post by:

Dear all, I am using DB2 for AIX, I have the following problem when migrating my DB from DB2 v7.2 to v8.1 I orginally have a table with a CLOB field with logged and not compact properties. We...

DB2 Database

Migrating from Solaris to Linux

by: Markus Enders | last post by:

Hi everybody, currently we use DB2 7.1 on several Solaris machines. Now we are planning, to migrate to SUSE Linux (newest version). I wonder, if we can keep our DB2 version 7.1, or if we need to...

DB2 Database

Migrating from DB2 UDB 6.x on Solaris to UDB 7.2 on Linux

by: Cam Chapman | last post by:

Does anyone have any experience migrating a DB2 database off UDB 6.1 (Solaris) to 7.2 (Linux)? The database does not already exist on the Linux box. Have created a DB2 instance fine. DB2...

DB2 Database

db2 8.1 for solaris 64 bit for AMD

by: Mary Lei | last post by:

Does anyone know the link to obtain the tarball for db2 8.1 for solaris running on AMD 64 bit ? This is the entire db2 installation on a new system that does not have db2. Thanks.

DB2 Database

Migrating DB2 UDB ESE v8.1/8.2 from Solaris to AIX

by: tojigneshshah | last post by:

What is the best way to migrate entire database from one operating system of Unix (ie:Solaris 7) to another Unix opearting system (ie:AIX 5.2)? Thanks in advance. Myjish.

DB2 Database

migrating c++ application from solaris to aix

by: clue | last post by:

hi all, We are in the process of porting a c++ application from solaris to aix, Roguewave(tools.h++) is used as the third party software , we are using xlc compiler and facing many issues. If...

C / C++

trouble building Python 2.5.1 on solaris 10

by: mg | last post by:

When make gets to the _ctypes section, I am getting the following in my output: building '_ctypes' extension creating build/temp.solaris-2.10-i86pc-2.5/home/ecuser/Python-2.5.1/ Modules/_ctypes...

Python

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp