By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,423 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

32-bit instance on AIX DB2 V9 ?

P: n/a
Greetings,
is it possible to create a 32-bit DB2 V9 instance on a p5 box running AIX
V5.2 (TL09) with 64-bit Kernel?
The command that used to set the bit-width of the DB2 instance - "db2icrt" -
doesn't support the "-w" switch anymore and instead uses the system
bit-width by default...

"db2level" shows:
DB21085I Instance "db9" uses "64" bits and DB2 code release "SQL09000" with
level identifier "01010107".
Informational tokens are "DB2 v9.0.0.0", "s060328", "AIX64", and Fix Pack
"0".
Product is installed at "/opt/IBM/db2/V9.0".

Regards,
Damir Wilder
Aug 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
To the best of my knowledge the answer is no.
32Bit DB2 9 is only supported on Windows and Linux (Intel and AMD based).
AFAIK 32bit client libraries are still available for stored procedures
and local apps that depend on 32bit.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Aug 10 '06 #2

P: n/a
Damir Wilder wrote:
Greetings,
is it possible to create a 32-bit DB2 V9 instance on a p5 box running AIX
V5.2 (TL09) with 64-bit Kernel?
The command that used to set the bit-width of the DB2 instance - "db2icrt"
- doesn't support the "-w" switch anymore and instead uses the system
bit-width by default...

"db2level" shows:
DB21085I Instance "db9" uses "64" bits and DB2 code release "SQL09000"
with level identifier "01010107".
Informational tokens are "DB2 v9.0.0.0", "s060328", "AIX64", and Fix Pack
"0".
Product is installed at "/opt/IBM/db2/V9.0".
More definitively than Serge's answer (but not in disagreement with him):

No. There is no such thing as an "xx-bit" instance anymore. A single
instance provides all the functionality of both 32- and 64-bit (where
supported - AIX is one such platform). You should be able to use your
32-bit applications in the v9 instance (note: not "v9 64-bit instance" -
that terminology is misleading and therefor incorrect). And you should
also be able to use your 64-bit applications in the same v9 instance.

If you are having problems with your applications working in this instance,
then please let IBM know that.

Thanks,

PS - v9 has GA'd, you may want to move up from the beta. Not that this
changes the answer to the question.
Aug 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.