473,471 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to use db2iupdt -w 64 to update my instance from 32bit to 64bit?

11 New Member
I use db2iupdt -w 64 to update my instance from 32bit to 64bit, and my database under this instance should do nothing.

I do not know what is the detail about db2iupdt -w command ,what does it do? and why my database should do nothing.

Could you give some advices? thanks a lot.
Mar 6 '11 #1
2 3886
vijay2082
112 New Member
Hi Victor,

use below information for upgrating your instance to 64 bit.

Can you be a bit more clear on the phrase "and my database under this instance should do nothing" ?
Ideally this should mean that your database won't be accessible during the whole upgrade process. Also check on 64 bit application supports.

1) Migrating DB2 32-bit servers to 64-bit systems (Linux and UNIX)
http://publib.boulder.ibm.com/infoce...c/t0009804.htm

2) Upgrading your 32-bit DB2 instances to 64-bit instances (Windows)
DB2(R) 32-bit and 64-bit instances cannot exist on the same system. Any 32-bit instances will be removed when you install any DB2 Version 9 64-bit database product.

You cannot install a 64-bit DB2 Version 9 copy on a system with multiple 32-bit DB2 Version 9 copies.

Procedure
If you have more than one 32-bit DB2 Version 9 copy on your system and want to upgrade to 64-bit, perform the following steps:

Move all your 32-bit instances over to one DB2 copy using the db2iupdt command
Uninstall the 32-bit DB2 copies, except for the one where you have moved all your 32-bit instances over to
Install DB2 Version 9 64-bit which will upgrade your 32-bit DB2 Version 9 instances to 64-bit DB2 Version 9 instances.
Mar 6 '11 #2
victor deng
11 New Member
thanks very much,vijay.
I really want to know what`s the detail things about db2iupdt / db2imigr / migrate db.
Here is my understanding:db2iupdt -w 64 relink some files in sqllib directory to lib64&bin64 under db2 installation directory.
And db2imigr relink these files to new db2 installation directory.

And migrate db command generates new packages using new db2 version.
Mar 26 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mohammed Mazid | last post by:
Can anyone please help me on how to move to the next and previous question? Here is a snippet of my code: Private Sub cmdNext_Click() End Sub Private Sub cmdPrevious_Click() showrecord
3
by: Stevey | last post by:
I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>
3
by: Ekqvist Marko | last post by:
Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...
4
by: tommydkat | last post by:
Well, I've finally gotten UDB 8.2 FixPak 3 up and running on my HP-UX 11i system, thanks to Mr McBride and IBM support. :) I created a 32-bit instance and that's running just fine. However, I...
7
by: tommydkat | last post by:
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...
56
by: spibou | last post by:
In the statement "a *= expression" is expression assumed to be parenthesized ? For example if I write "a *= b+c" is this the same as "a = a * (b+c)" or "a = a * b+c" ?
0
by: jcvila | last post by:
I have 7 DB2 Connect gateways (all AIX) and I've been successfully able to update all but 1 to FP11. It's currently V8 FP8 and I can't seem to complete the install with db2iupdt for FP10,11 or 12. ...
7
by: scottgamble | last post by:
My company is making the switch to DB2 from Oracle. I have been working with Oracle for the last 10 years or so and still very very new to DB2. One question that has come up recently within our...
7
by: Philip Nelson | last post by:
I know that on DB2 V8.2 (on Linux) it wasn't possible to "upgrade" without reinstalling. But on V9.1, can I initially install Workgroup, and then if we need additional functionality can we buy...
6
semanticnotion
by: semanticnotion | last post by:
Hi sir i want to transform the data of one table into another through foreign key but the following error come to my browser Here is my code and data base structure. CREATE TABLE IF NOT...
0
marktang
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,...
0
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...
0
Oralloy
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,...
0
jinu1996
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...
0
tracyyun
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...
0
agi2029
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,...
1
isladogs
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...
0
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...
0
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...

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.