DB2/UDB version 6.1 - is it 32-bit or 64-bit on AIX 4.3 
Author Message
 DB2/UDB version 6.1 - is it 32-bit or 64-bit on AIX 4.3
I just took over a ver 6.1 UDB database on AIX 4.3 and have no prior
experience with UDB.  A software vendor needs to know if we are
running 32-bit or 64-bit UDB.  Where can I find this info?? How can
you tell??
I did a "get dbm cfg" and "get db cfg" and it does not say.


Tue, 27 Apr 2004 08:05:46 GMT
 DB2/UDB version 6.1 - is it 32-bit or 64-bit on AIX 4.3

I believe that 64-bit DB2 only became available in V7. V6 would have to
be 32-bit.

Larry Edelstein

Quote:

> I just took over a ver 6.1 UDB database on AIX 4.3 and have no prior
> experience with UDB.  A software vendor needs to know if we are
> running 32-bit or 64-bit UDB.  Where can I find this info?? How can
> you tell??
> I did a "get dbm cfg" and "get db cfg" and it does not say.



Tue, 27 Apr 2004 08:20:05 GMT
 DB2/UDB version 6.1 - is it 32-bit or 64-bit on AIX 4.3
Larry E . is correct ... you must install a minimum of DB2 v7.1 FixPak 1
before creating 64-bit instances.  Must update all 32-bit instances to
minimum of FP1 level before updating to 64-bit instances. So if your
instance is V6.1, then it is not 64-bit.

Also makes sense that your AIX level should be 64-bit as well? To check
your AIX level :

bootinfo -K returns kernel "bitness"
bootinfo -y returns H/W capability i.e. 32 or 64 so if -y=32, -K=32 and
if -y=64, -K=32|64
--

Bob Harbus - Senior Consultant
DB2 UDB Data Management Consulting Services - IBM Toronto

Quote:

> I just took over a ver 6.1 UDB database on AIX 4.3 and have no prior
> experience with UDB.  A software vendor needs to know if we are
> running 32-bit or 64-bit UDB.  Where can I find this info?? How can
> you tell??
> I did a "get dbm cfg" and "get db cfg" and it does not say.



Tue, 27 Apr 2004 11:08:48 GMT
 DB2/UDB version 6.1 - is it 32-bit or 64-bit on AIX 4.3
I was passed some additional information that should help in future ...

 "If sqllib/lib is a link to PRODDIR/lib, it's 32-bit.  If sqllib/lib is a
link to PRODDIR/lib64, it's 64-bit." where PRODDIR is your installation
directory. These should hold true for almost all our installations.

--

Bob Harbus

Quote:

> Larry E . is correct ... you must install a minimum of DB2 v7.1 FixPak 1
> before creating 64-bit instances.  Must update all 32-bit instances to
> minimum of FP1 level before updating to 64-bit instances. So if your
> instance is V6.1, then it is not 64-bit.

> Also makes sense that your AIX level should be 64-bit as well? To check
> your AIX level :

> bootinfo -K returns kernel "bitness"
> bootinfo -y returns H/W capability i.e. 32 or 64 so if -y=32, -K=32 and
> if -y=64, -K=32|64
> --

> Bob Harbus - Senior Consultant
> DB2 UDB Data Management Consulting Services - IBM Toronto


> > I just took over a ver 6.1 UDB database on AIX 4.3 and have no prior
> > experience with UDB.  A software vendor needs to know if we are
> > running 32-bit or 64-bit UDB.  Where can I find this info?? How can
> > you tell??
> > I did a "get dbm cfg" and "get db cfg" and it does not say.



Tue, 27 Apr 2004 21:55:08 GMT
 DB2/UDB version 6.1 - is it 32-bit or 64-bit on AIX 4.3
As Bob says v6 is definately 32-bit.

To check one can also dump -HX64 sqllib/adm/db2sysc  if the loader section is
dumped out then db2 is 64-bit.

Quote:

> I was passed some additional information that should help in future ...
>  "If sqllib/lib is a link to PRODDIR/lib, it's 32-bit.  If sqllib/lib is a
> link to PRODDIR/lib64, it's 64-bit." where PRODDIR is your installation
> directory. These should hold true for almost all our installations.
> --
> Bob Harbus




Sun, 16 May 2004 06:44:02 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. 32-bit vs 64-bit on AIX 4.3.3

2. DB2 64 bit - 32 bit problem

3. 64-bit SQL Server and 32-bit dlls question

4. 32-bit Oracle Server on 64-bit Solaris?

5. Performance: 32-bit SE vs. 64-bit EE

6. Changes in 64 bit Oracle from 32 bit

7. Moving from 8.1.7 32-bit to 8.1.7 64-bit

8. 32-bit Clients to 64-bit Oracle Server

9. 8.0.5 32-bit on HP-UX 11.0 64-bit

10. 32-bit client to 64-bit server

11. 64 bit client accessing 32 bit server?

12. 64-bit or 32-bit word size?


 
Powered by phpBB® Forum Software