dbTalk Databases Forums  

64-bit DB2 server and 32-bit application?

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss 64-bit DB2 server and 32-bit application? in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
shahhe@gmail.com
 
Posts: n/a

Default 64-bit DB2 server and 32-bit application? - 05-08-2010 , 09:16 AM






We are in process of upgrading from DB2 8 to DB2 9 on AIX. AIX is
running 64-bit kernel and DB2 8.2 is running 32-bit. Our application s
also 32-bit due to third party library, which is not available in 64-
bit, we cannot compile our application in 64-bit.

If we install DB2 9 in 64-bit can I link our application with DB2. Is
there any benefit in installing 64-bit DB2 if I my application is 32-
bit?

Thanks.

Reply With Quote
  #2  
Old   
The Boss
 
Posts: n/a

Default Re: 64-bit DB2 server and 32-bit application? - 05-08-2010 , 10:28 AM






shahhe (AT) gmail (DOT) com wrote:
Quote:
We are in process of upgrading from DB2 8 to DB2 9 on AIX. AIX is
running 64-bit kernel and DB2 8.2 is running 32-bit. Our application s
also 32-bit due to third party library, which is not available in 64-
bit, we cannot compile our application in 64-bit.

If we install DB2 9 in 64-bit can I link our application with DB2. Is
there any benefit in installing 64-bit DB2 if I my application is 32-
bit?

Thanks.
Starting DB2 version 9.5, you don't have the option to run a 32-bit instance
on a 64-bit OS.
For the implications for your application, see:
http://publib.boulder.ibm.com/infoce.../c0022266.html

HTH

--
Jeroen

Reply With Quote
  #3  
Old   
Helmut Tessarek
 
Posts: n/a

Default Re: 64-bit DB2 server and 32-bit application? - 05-08-2010 , 01:46 PM



Quote:
If we install DB2 9 in 64-bit can I link our application with DB2. Is
there any benefit in installing 64-bit DB2 if I my application is 32-
bit?
TheBoss was not entirely correct. Only the instance itself has to be 64 bit.
We still ship 32 bit libraries with DB2 for AIX. A 32 bit client is also still
available, even on AIX.

Therefore the answer is yes.

The benefit of using 64 bit is being able to use more memory for instance and
database. (> 4GB)

I really would ask for a 3rd party 64 bit library. Newer versions of AIX
(starting with AIX 5L) do not come with 32 bit kernels and running 32bit
applications on 64 bit hardware and 64 bit OS is rather suboptimal.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Reply With Quote
  #4  
Old   
The Boss
 
Posts: n/a

Default Re: 64-bit DB2 server and 32-bit application? - 05-08-2010 , 03:05 PM



"Helmut Tessarek" <tessarek (AT) evermeet (DOT) cx> schreef in bericht
news:hs4bhd$7rs$1 (AT) news (DOT) albasani.net...
Quote:
If we install DB2 9 in 64-bit can I link our application with DB2. Is
there any benefit in installing 64-bit DB2 if I my application is 32-
bit?

TheBoss was not entirely correct. Only the instance itself has to be 64
bit.
We still ship 32 bit libraries with DB2 for AIX. A 32 bit client is also
still
available, even on AIX.
How is that more correct than:
"... you don't have the option to run a 32-bit instance on a 64-bit OS."
followed by a link to point out the implications for an application?

Quote:
Therefore the answer is yes.

Agreed, but not without (resolvable) issues mentioned in the link provided.

Cheers!

--
Jeroen

Reply With Quote
  #5  
Old   
Helmut Tessarek
 
Posts: n/a

Default Re: 64-bit DB2 server and 32-bit application? - 05-08-2010 , 07:12 PM



Hey,

Sorry, I overread the line
For the implications for your application, see:

I just saw the link and assumed that it points to instance creation stuff.

My bad.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.