473,700 Members | 2,838 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Question about DB2 UDB 8.2 and 32-bit and 64-bit instances

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
learned today that I need to have a 64-bit instance. So, can I create
a 64-bit instance "next to" the 32-bit instance I've got running now or
must I nuke my 32-bit instance and then create a 64-bit instance?

Thanks in advance for your help!

Peace...

Tom

Jan 6 '06 #1
4 3846
to*******@gmail .com wrote:
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
learned today that I need to have a 64-bit instance. So, can I create
a 64-bit instance "next to" the 32-bit instance I've got running now or
must I nuke my 32-bit instance and then create a 64-bit instance?

Thanks in advance for your help!

Peace...

Tom


You can safely create 64-bit and 32-bit instances in parallel on the
same system.

pick a user that you want to be the owner of that instance (it has to be
a different user than the one who owns the 32bit instance), say,
dbinst64, and run the following command as root:

db2icrt -u dbinst64 -w 64 dbinst64

(this assumes that you want the fenced user to be identical to the
instance owner. If you want to keep them separate, pick another user for
the fenced userID (this also has to be distinct from the fenced userID
of the 32bit instance) and use that username for the -u flag

Hope this helps.

-- stefan
Jan 6 '06 #2
Sweet! Thanks!

Peace...

Tom

Jan 6 '06 #3
to*******@gmail .com wrote:
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'm glad to hear it :-) Personally, I'm still kinda curious as to why those
problems were happening in the first place, so if you can have your
sysadmin tell me any information that would be helpful in replicating your
OS authentication system on our HP machines, I would like to kick it around
our HP guys to see if we can replicate it. That said, it's always nice
that the workarounds work, too!
I created a 32-bit instance and that's running just fine. However, I
learned today that I need to have a 64-bit instance. So, can I create
a 64-bit instance "next to" the 32-bit instance I've got running now or
must I nuke my 32-bit instance and then create a 64-bit instance?


Most definitely. You have two choices: create a new instance, or modify
your existing instance. The former is easy since you've already done this
once before: using db2icrt (with the "-w 64" flag) or db2isetup (select the
"64-bit" option on the applicable panel). The latter is just as easy:
using db2iupdt with the "-w 64" flag.

With the former, you will have two instances going - one 32-bit, one 64-bit.
On one hand, you can play natively with each (64-bit apps don't run in
32-bit instances, while 32-bit apps can be made to run in 64-bit instances,
but are much easier to run in 32-bit instances). On the other, they take
up more memory (both RAM and on disk). So you may decide to convert your
32-bit instance to 64-bit.

Doing so means that all your configuration and data will be seamlessly moved
to support 64-bit. It's also not a "do or die" scenario - you can later
decide you don't like 64-bit for your instance, move it back (db2iupdt -w
32 <instancename>) , and create a brand new 64-bit instance. The only real
downside is trying to get your 32-bit applications to work in the 64-bit
instance. It can be done - some parts easier than others. Fenced mode
procedures, for example, are supposedly trivial to migrate: from what I
hear, there's no work involved at all (although there's a small performance
penalty). Unfenced procedures need to be manually moved to become fenced
procedures (64-bit engine can't load and run a 32-bit unfenced procedure).
Other applications may need to have the SHLIB_PATH tweaked to load
libraries from sqllib/lib32 since sqllib/lib will have 64-bit libraries in
it.

With separate instances, you can have your 32-bit apps running in the 32-bit
instance and talking to your 64-bit server running in the 64-bit instance
with pretty much no problem.

Just things to think about. I don't think either way is a negative - just
different.
Jan 6 '06 #4
Darin McBride wrote:

I'm glad to hear it :-) Personally, I'm still kinda curious as to why those
problems were happening in the first place, so if you can have your
sysadmin tell me any information that would be helpful in replicating your
OS authentication system on our HP machines, I would like to kick it around
our HP guys to see if we can replicate it. That said, it's always nice
that the workarounds work, too!
Well, I'm technically the sysadmin for the box so I would be the person
to work with on this. I was asked by the other IBM person working on
the problem about remote access possibility to our server, which we
don't have in place.

If it's worth it, we can discuss other options. I'll send you e-mail.
:)
With the former, you will have two instances going - one 32-bit, one 64-bit.
On one hand, you can play natively with each (64-bit apps don't run in
32-bit instances, while 32-bit apps can be made to run in 64-bit instances,
but are much easier to run in 32-bit instances). On the other, they take
up more memory (both RAM and on disk). So you may decide to convert your
32-bit instance to 64-bit.
I believe we ended up having two instances running, one 32-bit and one
64-bit. TODAY, I just got my 32-bit app updating my 64-bit database,
so I'm happy once again. :)
Other applications may need to have the SHLIB_PATH tweaked to load
libraries from sqllib/lib32 since sqllib/lib will have 64-bit libraries in
it.


Yep, this is exactly what I needed to do in addition to re-link with
the "+s" linker option.

Thanks again for all of your help! :)

Peace...

Tom

Jan 13 '06 #5

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

Similar topics

6
1253
by: Rated R1 | last post by:
I have a form that is calculating a labor cost based on some combo boxes. Now there are 75 different styles that I am basing it on and I have it working no problem so that I dont need any help with it. However, there is one style choice where we drill holes in it, and charge 15 cents per hole. Is there a code that I can add to an after event that will take the # from a dropdown box (say I make a box for 28 holes, 32, 33, 38, etc) and...
5
2091
by: syntax | last post by:
hi here is my test code include<stdio.h> #include<stdlib.h> int main() {
35
2720
by: David Cleaver | last post by:
Hello all, I was wondering if there were some sort of limitations on the "if" statement? I'm writing a program which needs to check a bunch of conditions all at the same time (basically). And I'm pretty sure the rest of the program is working just fine. The only thing I could think might be wrong is that the if statement can only hold so many values in itself? Let me show what I'm doing: if (table001]>>5]&b&0x1f] != 0 &&
5
2519
by: Carlos Guzmán Álvarez | last post by:
Hello: I'm trying to execute a function of a unmanaged dll using PInvoke, i have definied the function as: public static extern int isc_dsql_prepare( int status_vector, ref int trans_handle, ref int stmt_handle,
7
1262
by: Joe Fallon | last post by:
I have a WinForm that is a Base class. It has many controls on it and a lot of generic code behind. When I inherit the form I override 5 methods and now each child form has the same look and feel and functionality. This part all works fine. (I learned this morning that if you override a method that also has an Event Handler then you should NOT include the event handler a 2nd time. I had a devil of a time figuring out why a block of code...
13
1925
by: christian.bongiorno | last post by:
I need to format a string and I would like to do it in 1 line char buff; I need something LIKE: sprintf(buff,"",value); // space pad up to 32 chars with the caveat it CANNOT be null terminated. I am sure there is a way -- I just don't know it
4
3298
by: Peter Proost | last post by:
Hi group, it's been a long time since the last time I've been here but I have a question. I'm working with timespan.parse for calculating a duration, I have to add strings which are in the following format 15:36:12 ==Hours, minutes, seconds but sometimes there is a string like 55:26:32 ==which is correct cause the production machine was busy for 55 hours, but the timespan.parse crashes on this value because it expects 2.7:26:32. I've...
5
2139
by: Lakesider | last post by:
Hi NG, I have a question about data: I have travel-times from A to B like this from | to | sec. A B 17 A B 18 A B 30 A B 32
10
1392
by: Topi Linkala | last post by:
Question 3.15: Why does the code double degC, degF; degC = 5 / 9 * (degF - 32); keep giving me 0?
17
3382
by: Richard Harter | last post by:
On Tue, 04 Nov 2008 16:43:49 -0500, Eric Sosman <Eric.Sosman@sun.comwrote: I may address the rest of your comments later (for which, thank you very much) but this seems to be a serious point of confusion so let me expand. What we can have is the following sequence of events: At time A we create bobble X. Space will be allocated for X as
0
8709
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, 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...
0
8638
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9202
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, 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...
0
9058
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 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...
0
8909
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 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...
0
7791
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, 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...
0
4395
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...
0
4649
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2018
bsmnconsultancy
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.