32-bit vs. 64-bit ??

[Sam]

What are the advantages of 64-bit over 32-bit computing? Does DB2
support 64-bit architectures for Windows or Linux?

[DA Morgan]

Sam wrote:

What are the advantages of 64-bit over 32-bit computing? Does DB2
support 64-bit architectures for Windows or Linux?

DB2 and Oracle support 64 bit computing and have for some time now.

The advantages are in the area of floating-point math, the ability
to address large amounts of RAM, moving very large datasets (and that
doesn't mean tens or a few hundreds of GB).

--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)

[jayped]

Sam,

As DA morgan, pointed out there are a number of advantages. Microsoft
has a good page on it here:
http://www.microsoft.com/windowsserv.../benefits.mspx.

DB2 already supports the Itanium (IA64) as well x86-64 (AMD64 and Intel
EM64T) for both Windows and Linux. DB2 has a beta for Windows x64 and
already supports Linux Redhat and SUSE on AMD64 and EM64T as of V8.2.
For more information, you can go here:
http://www.ibm.com/software/data/db2/windows/x64.html

DB2 also support 64-bit Linux on Power architectures such as OpenPower
and pSeries.

-Jay

DA Morgan wrote:

Sam wrote:

What are the advantages of 64-bit over 32-bit computing? Does DB2
support 64-bit architectures for Windows or Linux?

DB2 and Oracle support 64 bit computing and have for some time now.

The advantages are in the area of floating-point math, the ability
to address large amounts of RAM, moving very large datasets (and that
doesn't mean tens or a few hundreds of GB).

--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)

[Pablo Sanchez]

"jayped" <ja****@gmail.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:

Sam,

As DA morgan, pointed out there are a number of advantages.
Microsoft has a good page on it here:
http://www.microsoft.com/windowsserv.../benefits.mspx.

The disadvantage is you require a larger code cache footprint;
you're pointers are now twice as large as in 32-bit code.

If you're not taking advantage of the larger memory model available,
you should stick to 32-bit version of the DBMS.

Regards,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

[Larry]

The only thing you need to consider is how much longer 32-bit will be
supported by the database and the OS. I cannot make any official
statements on behalf of IBM on this, but I can say that you can expect
that 32-bit DB2 may not be supported forever. I'd speak to my local IBM
rep about this before making a decision unless someone else from IBM is
willing to be more specific here.

Larry Edelstein

Pablo Sanchez wrote:

"jayped" <ja****@gmail.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:

Sam,

As DA morgan, pointed out there are a number of advantages.
Microsoft has a good page on it here:
http://www.microsoft.com/windowsserv.../benefits.mspx.

The disadvantage is you require a larger code cache footprint;
you're pointers are now twice as large as in 32-bit code.

If you're not taking advantage of the larger memory model available,
you should stick to 32-bit version of the DBMS.

Regards,

[Pablo Sanchez]

Larry <la***@nospam.net> wrote in news:nI************@fe10.lga:

The only thing you need to consider is how much longer 32-bit will
be supported by the database and the OS. I cannot make any
official statements on behalf of IBM on this, but I can say that
you can expect that 32-bit DB2 may not be supported forever. I'd
speak to my local IBM rep about this before making a decision
unless someone else from IBM is willing to be more specific here.

FWIW, I doubt it'll go away any time soon. I believe the DBMS
vendors would love to minimize how many builds they need to 'make'.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

[Larry]

What is "soon" to you? You really need to check with your local IBM
team. Word to the wise.

Larry Edelstein

Pablo Sanchez wrote:

Larry <la***@nospam.net> wrote in news:nI************@fe10.lga:

The only thing you need to consider is how much longer 32-bit will
be supported by the database and the OS. I cannot make any
official statements on behalf of IBM on this, but I can say that
you can expect that 32-bit DB2 may not be supported forever. I'd
speak to my local IBM rep about this before making a decision
unless someone else from IBM is willing to be more specific here.

FWIW, I doubt it'll go away any time soon. I believe the DBMS
vendors would love to minimize how many builds they need to 'make'.

[djwilliams]

You might want to check with the db2 udb email users group folks for
some insight at http://www.herethey.com.

There was a bit of discussion on his a while back.

[Knut Stolze]

Larry wrote:

What is "soon" to you? You really need to check with your local IBM
team. Word to the wise.

Exactly. If you want to run your applications for the next 50 years, then
you should really worry about 32-bit support now.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena