When I look @ the URL http://www-306.ibm.com/software/data...is3264bit.html
I see that there are no separate binaries for 32-bit and 64-bit solaris. This being the case, am I right to assume that a sun sparc system that has 32-bit DB2 UDB installed can be updated to use 64-bit with the same binary software used intially to install 32-bit DB2 UDB?

What is the performance gain, if any, after moving to 64-bit DB2 UDB from 32-bit DB2 UDB on a Sun SPARC Solaris box?

Thanks in advance.

I don't know about the binaries, but the primary benefit of 64-bit DB2 is the ability to address more memory, especially for the bufferpools. In 32-bit, DB2 instances are constrained to about 2GB of memory (depending on which operating system), unlike 64-bit DB2 which can address just about as much physical memory as any server can support.

Whether your DB2 database can benefit from addressing more system memory depends on the amount of data in the database and the performance requirements of the application. If the total of all your bufferpools for an instance is less than 1.5 GB and your bufferpool hit ratio is already at 99%+, then you are not likely to see any performance improvement by using larger bufferpools that are available with 64-bit DB2.