473,594 Members | 2,739 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Question about database migration from UDB 7.1 to 8.2 (FP3) on HP-UX

Hi! I need to migrate a UDB 7.1 32-bit database on one HP-UX system to
a 8.3 (FP3) 64-bit database on a new HP-UX system.

I found this newsgroup post which indicates this not possible using
backup/restore utilities:


Is this still the case with UDB 8.2? I can't backup the database in
UDB 7.1 and restore it in UDB 8.2?



Jan 9 '06 #1
7 1611
Hi tommy,

If at all ur 32 bit Database is of version 8 then only u can do like
that (using backup and restore).

You can migrate ur Database by using the db2look and db2move utility
ie.. the method of regenereating the DDL and then u can create in ur
migrated database. then u can load the data using db2move utility.


Jan 10 '06 #2
Basically you will do this:

1 - Take an offline backup of your v7 database
2 - Create a 32 bit instance on your v8
3 - Restore the offline backup into the v8 database
4 - Update your instance to 64bit (db2iupdt -w 64 instance_name)
5 - Reorg all indexes with the convert option (this will convert all
the old indexes from type1 to type2).

You cannot use an online backup because the logs are not compatible
between v7 and v8, and you cannot restore directly to a 64bit instance,
you have to restore to a 32 bit then update it.

Make sure you convert the indexes to type-2 so you can take advantage
of the performance features of type-2

Good luck,


Jan 10 '06 #3
to*******@gmail .com wrote:
Hi! I need to migrate a UDB 7.1 32-bit database on one HP-UX system to
a 8.3 (FP3) 64-bit database on a new HP-UX system.

I found this newsgroup post which indicates this not possible using
backup/restore utilities:

Is this still the case with UDB 8.2? I can't backup the database in
UDB 7.1 and restore it in UDB 8.2?


Thanks for the link to the old thread. That comes in very handy when trying
to figure out what the question is ;-)

The way to migrate your v7 database to v8 is to keep the bits the same. The
best way to do this, I think, is to change your v8 instance to 32-bit (use
db2iupdt with the "-w 32" flag), restore the database, then convert your v8
instance back to 64-bit (using db2iupdt with the "-w 64" flag).

I would imagine that if you wanted to do all this without taking down your
existing 64-bit instance, you probably could create a new 32-bit instance,
restore, optionally convert that instance to 64-bit, backup again (the new
backup will be a v8 backup which is not dependant on wordsize), and then
restore that to your production instance.

Hope that helps.
Jan 10 '06 #4
Thanks for the help, guys!



Jan 11 '06 #5
One more quick question, if I have an application that updates the DB2
database will I need to relink that application once the database is
migrated to the 64-bit DB2 V8.2 instance? The application was updating
the 32-bit DB2 V7 database.



Jan 13 '06 #6
You will need the version 8 runtime client installed on the application

The runtime client should keep your old catalog intact, so you may not
have to re-catalog your database on the application server

Jan 13 '06 #7
Thanks for the info. I found another thread in this newsgroup that
addressed the issue I asked about above and found this technote:


That technote contains all the info I need so I think I'm set (at least
until I get to thep point of actually trying it out. :)).

These threads were very helpful:


Thanks again for the help!


Jan 13 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: J Goldman | last post by:
I'm looking for documentation pointers to learn what I need to put together a distributed database system. I've read through "Oracle 9i Database Administrator's Guide: Distributed Database Concepts" and Oracle Database Concepts: Introduction to the Oracle Server: Distributed Databases Overview", but I don't see how to do what I want. I would like to set up a distributed database system with location transparency and a shared schema...
by: cwhite | last post by:
Hi I have another drop list question. I have a table like this: computer dell computer ibm computer hp
by: Patrick Finnegan | last post by:
Running UDB V7 FP10a and 8.1 .4 on Windows 2000. Did full offline backups of three V7 databases. Restored two databases to V8 instance successfully. Third restore ended with: SQL2517W The restored database was migrated to the current release. Migration returned sqlcode "1088" and tokens "C:\IBM\SQLLIB\bnd\db2schema.bnd".
by: Jean-Marc Blaise | last post by:
Dear all, Can we use the FP4a 32 bit version for Aix 4.3.3 on an AIX 5 32 bit system ? The pb is the size of AIX5 FP4a exceeds now the size of a normal cdrom: AIX5 FP3: 665 Mo FP4a: 710 Mo AIX4 FP3: 586 Mo FP4a: 624 Mo Regards,
by: Jep | last post by:
Any help or advice appreciated. We have just installed and configured a new DB2 v.8.1 with latest FixPack. Just a few days later it dies and now we have a DB that is totally unusable. - - - - It went all wrong one morning when connecting gave us this msg:
by: Dave | last post by:
We are trying to migrate a MS SQL server app to DB2 8.1 Linux platform. Our database has got about 300+tables with total size - 150 GB We are using MS SQL's BCP utility to extract data from MS SQL's tables and loading into DB2 using DB2's LOAD utility. There are tons of colums of floating point types (singe precion & double precision types) in the database and when extracted using BCP, it generates data only upto 17 digits....
by: Harry Boswell | last post by:
I'm needing to connect to this DB2 database from Oracle, and when I try to connect, I get a message saying I'm using a UDB 8 client against a UDB 07.02.0007 database. I've searched IBM's website for a while looking for a version 7 client, and haven't found one. I'm also confused by the term "Fixpack" - these seem to be updates to the client, but I never find the base install. Can somebody give me a link to the version 7 client? ...
by: banyanhost | last post by:
Hello: I have a question regarding my copy of DB2 Enterprise Edition 7.1 My business acquires used software fairly often. And we came across a copy of DB2 Enterprise Edition 7.1 and i want to know if you can tell me what type of license this will allow us to use the product as. Here is what the license card says:
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the simplest example of my situation (real world would be more complex). Say you have two versions of your application. A release version and a development version. After a month of developing you are ready to release a new version. There have...
by: dunleav1 | last post by:
How can I be sure that DB2_LINUXAIO is working properly in DB 9 FP3? The parameter db2_linuxaio was depreciated from the base version to FP3 and my performance tests have shown a decrease in performance between the versions. DB2 9 FP3 on windows compared to windows seems to be about 40% faster in my first test. I have a few more to run... DB's are configured that same in Windows and Linux. My tests connect via jdbc and use the Db2...
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: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
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: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.