Hi,
Is it worth to use 64-bit DB2 instances on a 32-bit kernel, in terms of:
- performance
- configuration (go beyond the 256 Mb segment for private mem, 1.75 Gb for
Bufferpools)
- other ?
I've seen NIS is not supported, downlevel (64 to 32 bit ?) is not supported
....
The "Should I be using DB2 64-bit?" tech note seems confusing: http://www-1.ibm.com/support/docview...=utf-8&lang=en
It states some restrictions
- You can install 64-bit DB2 UDB Version 8 on 32-bit operating systems only
on AIX, HP-UX and Solaris Operating Environments. ==>You will not be able to
create or run 64-bit instances. You can only create and run 32-bit
instances. <== Really ?
The db2setup (8.2 / Aix) asked for 32-bit or 64-bit instance creation. It
seems db2iupdt -w 64 works fine, and the instance is functionning, but is it
worth ?
Thanks for your help,
Jean-Marc 12 6340
Jean-Marc,
I believe what the technote is trying to say is you can install the
64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but
once you install the DB2 binaries, you must create DB2 instances in
order to operate a DB2 database. I believe it is saying that you cannot
create 64-bit instances under a 32-bit OS. If you didn't receive an
error in attempting to do so, I guess you are in uncharted territory,
and risk not being able to get support from IBM. I'm not sure that
there's any advantage to using a 64-bit instance under a 32-bit OS, even
if you are able to get it to work and it even if it IS supported.
Larry Edelstein
Jean-Marc Blaise wrote: Hi,
Is it worth to use 64-bit DB2 instances on a 32-bit kernel, in terms of: - performance - configuration (go beyond the 256 Mb segment for private mem, 1.75 Gb for Bufferpools) - other ?
I've seen NIS is not supported, downlevel (64 to 32 bit ?) is not supported ....
The "Should I be using DB2 64-bit?" tech note seems confusing: http://www-1.ibm.com/support/docview...=utf-8&lang=en
It states some restrictions - You can install 64-bit DB2 UDB Version 8 on 32-bit operating systems only on AIX, HP-UX and Solaris Operating Environments. ==>You will not be able to create or run 64-bit instances. You can only create and run 32-bit instances. <== Really ?
The db2setup (8.2 / Aix) asked for 32-bit or 64-bit instance creation. It seems db2iupdt -w 64 works fine, and the instance is functionning, but is it worth ?
Thanks for your help,
Jean-Marc
Larry E wrote: Jean-Marc,
I believe what the technote is trying to say is you can install the 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but once you install the DB2 binaries, you must create DB2 instances in order to operate a DB2 database. I believe it is saying that you cannot create 64-bit instances under a 32-bit OS. If you didn't receive an error in attempting to do so, I guess you are in uncharted territory, and risk not being able to get support from IBM. I'm not sure that there's any advantage to using a 64-bit instance under a 32-bit OS, even if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works.
However, I don't think it's officially supported. I'm not sure if this
is explicitly unsupported, or simply implicitly unsupported by the fact
that the combination is not documented to be supported.
"Darin McBride" <dm******@naboo .to.org.no.spam .for.me> a écrit dans le
message de news:T0ZLd.2504 07$Xk.6730@pd7t w3no... Larry E wrote:
Jean-Marc,
I believe what the technote is trying to say is you can install the 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but once you install the DB2 binaries, you must create DB2 instances in order to operate a DB2 database. I believe it is saying that you cannot create 64-bit instances under a 32-bit OS. If you didn't receive an error in attempting to do so, I guess you are in uncharted territory, and risk not being able to get support from IBM. I'm not sure that there's any advantage to using a 64-bit instance under a 32-bit OS, even if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works. However, I don't think it's officially supported. I'm not sure if this is explicitly unsupported, or simply implicitly unsupported by the fact that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the db2setup
propose to create a 64-bit instance ? I think a 'bootinfo -K' can be done to
check if we are 32 or 64 bit kernel, and in case of 32-bit, it should NOT
propose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation " on a 32-bit kernel,
but there must be a reason somewhere as AIX does support it.
Best regards,
Jean-Marc
"Jean-Marc Blaise" <no****@nowhere .com> a écrit dans le message de
news:42******** **************@ news.wanadoo.fr ... "Darin McBride" <dm******@naboo .to.org.no.spam .for.me> a écrit dans le message de news:T0ZLd.2504 07$Xk.6730@pd7t w3no... Larry E wrote:
Jean-Marc,
I believe what the technote is trying to say is you can install the 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but once you install the DB2 binaries, you must create DB2 instances in order to operate a DB2 database. I believe it is saying that you
cannot create 64-bit instances under a 32-bit OS. If you didn't receive an error in attempting to do so, I guess you are in uncharted territory, and risk not being able to get support from IBM. I'm not sure that there's any advantage to using a 64-bit instance under a 32-bit OS,
even if you are able to get it to work and it even if it IS supported. My understanding is that AIX is a special case in that it works. However, I don't think it's officially supported. I'm not sure if this is explicitly unsupported, or simply implicitly unsupported by the fact that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the
db2setup propose to create a 64-bit instance ? I think a 'bootinfo -K' can be done
to check if we are 32 or 64 bit kernel, and in case of 32-bit, it should NOT propose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation " on a 32-bit kernel, but there must be a reason somewhere as AIX does support it.
Best regards,
Jean-Marc
.... By the way, it seems Oracle installs in 64-bit only on such machines ...
so why would DB2 avoid this support ?
How do you know that Oracle supports it?
Larry Edelstein
Jean-Marc Blaise wrote: "Jean-Marc Blaise" <no****@nowhere .com> a écrit dans le message de news:42******** **************@ news.wanadoo.fr ...
"Darin McBride" <dm******@naboo .to.org.no.spam .for.me> a écrit dans le message de news:T0ZLd.2504 07$Xk.6730@pd7t w3no...
Larry E wrote:
Jean-Marc,
I believe what the technote is trying to say is you can install the 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but once you install the DB2 binaries, you must create DB2 instances in order to operate a DB2 database. I believe it is saying that you cannot create 64-bit instances under a 32-bit OS. If you didn't receive an error in attempting to do so, I guess you are in uncharted territory, and risk not being able to get support from IBM. I'm not sure that there's any advantage to using a 64-bit instance under a 32-bit OS, even if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works. However, I don't think it's officially supported. I'm not sure if this is explicitly unsupported, or simply implicitly unsupported by the fact that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the
db2setup
propose to create a 64-bit instance ? I think a 'bootinfo -K' can be done
to
check if we are 32 or 64 bit kernel, and in case of 32-bit, it should NOT propose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation " on a 32-bit kernel, but there must be a reason somewhere as AIX does support it.
Best regards,
Jean-Marc
.... By the way, it seems Oracle installs in 64-bit only on such machines ... so why would DB2 avoid this support ?
Jean-Marc Blaise wrote: "Darin McBride" <dm******@naboo .to.org.no.spam .for.me> a écrit dans le message de news:T0ZLd.2504 07$Xk.6730@pd7t w3no... Larry E wrote:
> Jean-Marc, > > I believe what the technote is trying to say is you can install the > 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but > once you install the DB2 binaries, you must create DB2 instances in > order to operate a DB2 database. I believe it is saying that you cannot > create 64-bit instances under a 32-bit OS. If you didn't receive an > error in attempting to do so, I guess you are in uncharted territory, > and risk not being able to get support from IBM. I'm not sure that > there's any advantage to using a 64-bit instance under a 32-bit OS, > even if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works. However, I don't think it's officially supported. I'm not sure if this is explicitly unsupported, or simply implicitly unsupported by the fact that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the db2setup propose to create a 64-bit instance ? I think a 'bootinfo -K' can be done to check if we are 32 or 64 bit kernel, and in case of 32-bit, it should NOT propose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation " on a 32-bit kernel, but there must be a reason somewhere as AIX does support it.
I doubt it's "simulation " - I expect that since the processor can
handle 64-bit, the 32-bit kernel was just modified to allow 64-bit
programs to be controlled by it.
And why would db2setup allow 64-bit? Simple - users run all sorts of
unsupported scenarios. Many of them work. DB2 doesn't exactly want to
say it's smarter than the user when it can help it - if you really need
to run 64-bit on a 32-bit kernel, db2setup should not prevent it. This
is different from DB2's autonomic computing in that you can turn that
off. Since db2setup is run before you can configure DB2, it's hard to
turn off autonomic computing functionality there. It's a delicate line
which I'm sure db2setup jumps from side to side depending on the issue,
but we're definitely open to feedback about which side of the line
db2setup should be on for each issue.
Here's a scenario that would be, in my mind, a valid reason to run
64-bit DB2 on 32-bit AIX kernel (which is not to say IBM supports it -
my opinion should not be construed as IBM policy or even IBM opinion).
There are still some limitations of the 32- and 64-bit kernel, as I
understand it. One would be that kernel extentions (such as file
system drivers) can only run in a certain kernel - the one that matches
how it was compiled. (e.g., DB2 Datalinks Manager has a file system
driver which only runs 32-bit.) So, if you have such a driver from
another vendor, which prevents you from using the 64-bit kernel, but
you need access to all 8GB of RAM for DB2, you really have little
choice but to go into this "unsupporte d" realm.
Should you then have an actual problem to report to IBM, you may need
to reboot to 64-bit kernel (disabling the other software) to reproduce
and report it, so that your problem comes up in a "supported"
environment. But for the rest of the time, you run in the 32-bit
kernel.
Jean-Marc,
AIX has a lot of flexibility here, and you're probably fine: there's a
difference between 32 & 64 bit user space, kernel, and hardware. So, I
believe that a 64-bit user process like db2 can run using either 32 or
64 bit kernel as long as it's on 64 bit hardware.
I think the main issue regarding the use of 64-bit db2 on 32-bit kernel
is not memory, but instead that registers will have to be converted to
32-bit. However, there may still be some other application software
that isn't yet 64-bit kernel ready (pssp?).
So, probably the best reason to go 64-bit kernel is to avoid register
conversions, and maybe to support jfs2? But I've run db2 on the 32-bit
kernel without any issues.
buck
Another possible scenario: migration from 32-bit to 64-bit, where you
are doing it in stages and the stage at 64-bit DB2 with 32-bit OS is
very temporary.
Larry Edelstein
Darin McBride wrote: Jean-Marc Blaise wrote:
"Darin McBride" <dm******@naboo .to.org.no.spam .for.me> a écrit dans le message de news:T0ZLd.2504 07$Xk.6730@pd7t w3no...
Larry E wrote:
Jean-Marc,
I believe what the technote is trying to say is you can install the 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but once you install the DB2 binaries, you must create DB2 instances in order to operate a DB2 database. I believe it is saying that you cannot create 64-bit instances under a 32-bit OS. If you didn't receive an error in attempting to do so, I guess you are in uncharted territory, and risk not being able to get support from IBM. I'm not sure that there's any advantage to using a 64-bit instance under a 32-bit OS, even if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works. However, I don't think it's officially supported. I'm not sure if this is explicitly unsupported, or simply implicitly unsupported by the fact that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the db2setup propose to create a 64-bit instance ? I think a 'bootinfo -K' can be done to check if we are 32 or 64 bit kernel, and in case of 32-bit, it should NOT propose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation " on a 32-bit kernel, but there must be a reason somewhere as AIX does support it.
I doubt it's "simulation " - I expect that since the processor can handle 64-bit, the 32-bit kernel was just modified to allow 64-bit programs to be controlled by it.
And why would db2setup allow 64-bit? Simple - users run all sorts of unsupported scenarios. Many of them work. DB2 doesn't exactly want to say it's smarter than the user when it can help it - if you really need to run 64-bit on a 32-bit kernel, db2setup should not prevent it. This is different from DB2's autonomic computing in that you can turn that off. Since db2setup is run before you can configure DB2, it's hard to turn off autonomic computing functionality there. It's a delicate line which I'm sure db2setup jumps from side to side depending on the issue, but we're definitely open to feedback about which side of the line db2setup should be on for each issue.
Here's a scenario that would be, in my mind, a valid reason to run 64-bit DB2 on 32-bit AIX kernel (which is not to say IBM supports it - my opinion should not be construed as IBM policy or even IBM opinion). There are still some limitations of the 32- and 64-bit kernel, as I understand it. One would be that kernel extentions (such as file system drivers) can only run in a certain kernel - the one that matches how it was compiled. (e.g., DB2 Datalinks Manager has a file system driver which only runs 32-bit.) So, if you have such a driver from another vendor, which prevents you from using the 64-bit kernel, but you need access to all 8GB of RAM for DB2, you really have little choice but to go into this "unsupporte d" realm.
Should you then have an actual problem to report to IBM, you may need to reboot to 64-bit kernel (disabling the other software) to reproduce and report it, so that your problem comes up in a "supported" environment. But for the rest of the time, you run in the 32-bit kernel.
Larry, there is no distinction between 32/64 bit from version 9i, it seems,
except from JVMs ... if I am right. :-)
JM
"Larry" <la***@nospam.n et> a écrit dans le message de
news:Zz******** ***********@fe0 9.lga... How do you know that Oracle supports it?
Larry Edelstein
Jean-Marc Blaise wrote: "Jean-Marc Blaise" <no****@nowhere .com> a écrit dans le message de news:42******** **************@ news.wanadoo.fr ...
"Darin McBride" <dm******@naboo .to.org.no.spam .for.me> a écrit dans le message de news:T0ZLd.2504 07$Xk.6730@pd7t w3no...
Larry E wrote:
>Jean-Marc, > >I believe what the technote is trying to say is you can install the >64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but >once you install the DB2 binaries, you must create DB2 instances in >order to operate a DB2 database. I believe it is saying that you
cannot
>create 64-bit instances under a 32-bit OS. If you didn't receive an >error in attempting to do so, I guess you are in uncharted territory, >and risk not being able to get support from IBM. I'm not sure that >there's any advantage to using a 64-bit instance under a 32-bit OS,
even
>if you are able to get it to work and it even if it IS supported.
My understanding is that AIX is a special case in that it works. However, I don't think it's officially supported. I'm not sure if this is explicitly unsupported, or simply implicitly unsupported by the fact that the combination is not documented to be supported.
Hi Darin,
Thanks for your reply. This is not really clear to me; why does the
db2setup
propose to create a 64-bit instance ? I think a 'bootinfo -K' can be
done to
check if we are 32 or 64 bit kernel, and in case of 32-bit, it should
NOTpropose to create a 64-bit instance, don't you think so ?
I agree that it seems crazy to do 64-bit "simulation " on a 32-bit
kernel,but there must be a reason somewhere as AIX does support it.
Best regards,
Jean-Marc
.... By the way, it seems Oracle installs in 64-bit only on such
machines ... so why would DB2 avoid this support ?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Marc Poinot |
last post by:
Did anybody use numarray on a 64 bits platform ? (e.g. SGI/Irix)
The package works on our 64 bits platforms... using 32 bits mode,
but not using 64 mode. Big crash in _ufunc... Is there a flag to
set somewhere, trick, hint, noway ?
-MP-
-----------------------------------------------------------------------
Marc POINOT Alias:...
|
by: Hugo |
last post by:
I have a dual boot machine, runs Win XP pro and Win XP Pro 64, XP boots from
C and XP 64 boots from D.
They both have VS 2005 Beta 2 installed.
I have a webapp developed in Win XP (32) which has gone well and runs fine
in XP.
I Now want to get this same app running under IIS on XP 64.
|
by: Odd Bjørn Andersen |
last post by:
I was asked to install db2 udb workgroup edition (version 7.2) 64-bits on
AIX. But I cannot find that we have a CD with that software. Only Enterprise
Edition.
Is it correct that you have to install Enterprise (Server) Edition if you
want 64-bits DB2 UDB (both version 7 and 8) on AIX ? And that Workgroup
(Server) Edition doesn't come in...
|
by: Dave Vandervies |
last post by:
I just fixed a bug that some of the correctness pedants around here may
find useful as ammunition.
The problem was that some code would, very occasionally, die with a
segmentation violation error. (Not as infrequent as some bugs that
have been discussed here in the past, but maybe once in an overnight
run of the program when it was...
|
by: Hugo |
last post by:
I have a dual boot machine, runs Win XP pro and Win XP Pro 64, Win XP boots
from C and Win XP 64 boot from D.
They both have VS 2005 Beta 2 installed.
I have a webapp developed in Win XP (32) which has gone well and runs fine
in XP.
I Now want to get this same app running under IIS on XP 64.
| |
by: some one |
last post by:
I have kind of wired problem, I using httpwebrequest to post form data to
server , in the GetResponse stage a WebException occurred, after tracing the
actual error that occurs on the server, I found the follows.
Invalid length for a Base-64 char array.
Description: An unhandled exception occurred during the execution of the
current...
|
by: mel_apiso |
last post by:
Hi,
we have an AIX 5.3 OS, and we purchased DB2 UDB version 8 Workgroup
Edition.
We want to install 64 bits version, but the source CD's that we have
say:
WORKGROUP SERVER EDITION
Version 8.1
for AIX 5L
|
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: krunalb |
last post by:
Hi,
I am trying to shift unsigned long long value by 64 bits and this is
what i get
#include <stdio.h>
int main()
{
unsigned short shiftby= 64;
|
by: =?Utf-8?B?UGF1bCBQaGlsbGlwcw==?= |
last post by:
I have read many things about this but I haven't got a clear vision on what
to do if anything about this.
I have a system that tries to find holes in my web site. One of the things
it has found and has been sent to me is
an Invalid_Viewstate exception. I will provide the stack trace below. If
you read down the stack trace it talks...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |