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. 5 1634
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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 -shared build/temp.solaris-2.9-sun4u-2.2/_imaging.o build/temp.solaris-2.9-s
un4u-2.2/decode.o build/temp.solaris-2.9-sun4u-2.2/encode.o build/temp.solaris-2
..9-sun4u-2.2/map.o build/temp.solaris-2.9-sun4u-2.2/display.o build/temp.solaris...
|
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 computation)? In particular, I know
earlier versions of RH shipped with an "old" Python installed as "python"
and that installation of more recent versions should not overwrite
"python" (e.g., install as "python2.3"). Is this still the case in RH9?
Any...
|
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 I use db2look to obtain the structure, the following is the
output:
CREATE TABLE "TEST"."TEST1" (
|
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 upgrade
to version 8. How are your experiences running DB2 in version 7.1 on Linux.
How difficult is the migration from Solaris to Linux concerning DB2? Are
there some pitfalls or can I simply install the DB2, create my database
(tables and...
|
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 installation went ok
(no fixpacks installed yet though!) and can create sample database and
query.
In my naiivity as a non dba reformed developer, I've dumped the
database on the solaris box and am trying to perform a restore on the
Linux box using the...
| |
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.
|
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.
|
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 anybody has faced a similar kind of problem and solved it , can you
please share with us ..
|
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
creating build/temp.solaris-2.10-i86pc-2.5/home/ecuser/Python-2.5.1/
Modules/_ctypes/libffi
creating build/temp.solaris-2.10-i86pc-2.5/home/ecuser/Python-2.5.1/
Modules/_ctypes/libffi/src
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |