UDB V7.2 on AIX 5.2 32-bit to 64-bit migration

James Sargent

UDB V7.2 on AIX 5.2 32-bit to 64-bit migration
Hi folks:

We recently discovered (couldn't address memory above 2 gigs)
that although the OS is 64-bit.. it appears that our DB2 Tivolii Data
Warehouse & Data Mart are 32-bit.
Aaarrrggghhhhhh! Partitioning does not look feasible.

Does anyone have any experience, thoughts or wisdom to offer on the
above?

Thanks
James

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Wayne Driscoll

Re: UDB V7.2 on AIX 5.2 32-bit to 64-bit migration
(in response to James Sargent)
James,
First, you should be aware that DB2 UDB 7.2 for LUW has been out of support
from IBM since September 30, 2004. Second one of the big problems with 64
bit DB2 with version 7.2 and earlier is that the client and server all had
to be of the same architecture (ie. 32 bit client could not connect to a 64
bit server). However, in DB2 V8.1 the connectivity piece was completely
re-written to use DRDA data streams, and this restriction has been lifted.
My first suggestion would be to upgrade to a supported version of DB2
(preferably 8.2) in 32 bit mode, then convert to 64 bit mode. While you can
go directly to 64 bit mode (I believe) I think it would be safer to perform
a 2 stage conversion.
Good Luck
Wayne Driscoll
Product Developer
Western Metal Supply
NOTE: All opinions are strictly my own.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of James Sargent
Sent: Saturday, December 10, 2005 7:59 AM
To: [login to unmask email]
Subject: [DB2-L] UDB V7.2 on AIX 5.2 32-bit to 64-bit migration



Hi folks:



We recently discovered (couldn't address memory above 2 gigs)

that although the OS is 64-bit.. it appears that our DB2 Tivolii Data
Warehouse & Data Mart are 32-bit.

Aaarrrggghhhhhh! Partitioning does not look feasible.



Does anyone have any experience, thoughts or wisdom to offer on the above?



Thanks

James

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Sargent

UDB V7.2 on AIX 5.2 32-bit to 64-bit migration
(in response to Wayne Driscoll)
Hi Wayne:

Thanks for responding.

I'm stuck on this release because of the Tivoli Data Warehouse sitting
on it.

The product went GA on V8 about 3 months after development started.

Everything I see speaks to the two stage approach. and a bunch of
PTF's..

Thanks for you help

Best regards
Jamie


James,
First, you should be aware that DB2 UDB 7.2 for LUW has been out of
support from IBM since September 30, 2004. Second one of the big
problems with 64 bit DB2 with version 7.2 and earlier is that the client
and server all had to be of the same architecture (ie. 32 bit client
could not connect to a 64 bit server). However, in DB2 V8.1 the
connectivity piece was completely re-written to use DRDA data streams,
and this restriction has been lifted. My first suggestion would be to
upgrade to a supported version of DB2 (preferably 8.2) in 32 bit mode,
then convert to 64 bit mode. While you can go directly to 64 bit mode
(I believe) I think it would be safer to perform a 2 stage conversion.
Good Luck Wayne Driscoll Product Developer Western Metal Supply
NOTE: All opinions are strictly my own.

[login to unmask email]

Hi folks:

We recently discovered (couldn't address memory above 2 gigs)
that although the OS is 64-bit.. it appears that our DB2 Tivolii Data
Warehouse & Data Mart are 32-bit.
Aaarrrggghhhhhh! Partitioning does not look feasible.

Does anyone have any experience, thoughts or wisdom to offer on the
above?

Thanks
James


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm