From: shahhe on
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.
From: The Boss on
shahhe(a)gmail.com wrote:
> 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/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.qb.migration.doc/doc/c0022266.html

HTH

--
Jeroen


From: Helmut Tessarek on

> 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.
*/
From: The Boss on

"Helmut Tessarek" <tessarek(a)evermeet.cx> schreef in bericht
news:hs4bhd$7rs$1(a)news.albasani.net...
>
>> 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?

>
> Therefore the answer is yes.
>

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

Cheers!

--
Jeroen


From: Helmut Tessarek on
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.
*/