DB2 for Solaris 10 x64 now available

DB2 V8.2.4 for Solaris 10 01/06 x64 is finally available. While it is still hard to find on ibm.com/db2 website, if you have access to IBM Software Catalog (via Passport Advantage,PartnerWorld, etc) then you can request/search for it via the part number C909HML.

Following are the quick tips for improving your experience with DB2 on Solaris x64

  • Need Solaris 10 1/06 or greater (no support for Solaris 9, Solaris 8 on the x64 Platform)
  • Only 64-bit DB2 instance supported (no support for 32-bit DB2 instance on Solaris x64 which restricts you currently to use 64 bit enabled platforms using AMD64/EMT64 like the Sun Fire X4200 )
  • # isainfo
    amd64 i386
  • You will need 64-bit JVM installed on your system. If you are using Solaris 10 1/06 then it has 64-bit JVM for 1.5 and not 1.4.2 . Hence DB2 V8.2.4 on Solaris x64 uses JDK_PATH in the dbm cfg of DB2 pointing to /usr/java instead of /usr/j2se default (DB2 on Solaris SPARC). If the path is pointing to something else use the following command to reset it right for Solaris 10 x64
  • db2 update dbm cfg using JDK_PATH /usr/java

Also the valuable db2osconf is still not available on this version for Solaris x64, and hence the following will help you to get started with a decent database size . (Example shown assumes instance owner name as db2inst1, replace it with your instance owner name)

projadd -U db2inst1 user.db2inst1
projmod -a -K "project.max-shm-ids=(priv,4k,deny)" user.db2inst1
projmod -a -K "project.max-sem-ids=(priv,4k,deny)" user.db2inst1
projmod -a -K "project.max-shm-memory=(priv,4G,deny)" user.db2inst1
projmod -a -K "project.max-msg-ids=(priv,4k,deny)" user.db2inst1

The above helps to increase the limits of shared memory segments, semaphore ids and total memory that can be used for shared memory. Of course I still used the traditional way to set the following values on a Sun Fire 4200 with Solaris 10 1/06 for DB2 V8.2.4 that I had used for a recent test (I still need to verify if this is the right way set these values)

set msgsys:msginfo_msgmni = 3584
set semsys:seminfo_semmni = 4096
set shmsys:shminfo_shmmax = 15392386252
set shmsys:shminfo_shmmni = 4096

Other quick tips: If you install it on 32-bit Solaris 10 01/06, it will take you through the software binaries install successfully, but the instance creation step will fail. So please make sure that you are using 64-bit Solaris 10 01/06 otherwise it will result in wasted resources. Please share your experiences with us.



Have you tried it on a newer Nevada build?

Posted by Tao on May 11, 2006 at 05:04 AM EDT #

Yes, just make sure you are using Solaris Nevada on AMD64 (64-bit boot required)

Posted by Jignesh Shah on May 15, 2006 at 10:48 PM EDT #

Gr8 .. Is this DB Platform is going to be supported by Application vendors like BEA, WebSphere, SAP etc.

Posted by Selva on September 07, 2006 at 07:30 AM EDT #

Hi Selva, It is already supported with WebSphere, BEA WebLogic. You can look at the Spec.org website for the recent SpecJAppServer2004 benchmarks for both WebSphere and BEA Weblogic which used DB2 running on Solaris x64. -Jignesh

Posted by Jignesh Shah on September 12, 2006 at 11:49 PM EDT #

... I am sorry for the output. Somehow it got messed up.

Posted by matjazc on July 17, 2007 at 11:27 AM EDT #

ok, my post got lost ( but before it did I commented it ). Here it is one more time (without special characters ): root$ prtdiag | grep System System Configuration: IBM eserver xSeries 346 (8840EAY) root$ uname -a SunOS pankrt 5.10 Generic_125101-09 i86pc i386 i86pc root$ isainfo amd64 i386 root$ java -d64 -version java version "1.5.0_12" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04) Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_07-b03, mixed mode) root$ /data/007_ESE_SUN_3264_NLV/ese/db2setup ... Error: can't find libjava.so.

Posted by guest on July 17, 2007 at 11:37 AM EDT #

Once again I appologize for output. Besides I forgot to enter my name and email above ( both posts are mine ). As you can see, I am unable to install DB2 on xSeries with Intel Xeon EM64T processors with latest Solaris10 i386 OS. If I understood correctly I don't need to install Java IBM Development Kit since 64bit java already comes with Solaris10. Besides there isn't one for Solaris on IBM's download page. Do you have any suggestions how I could fix the issue ? Regards, Matjaz

Posted by matjazc on July 17, 2007 at 11:46 AM EDT #

ok, I know what the problem is. I don't have the right file C909HML, but older 8.1 C47KOML.tar. I have been sufring IBM's site whole day and it seems v8 downloads are history. Regards, Matjaz

Posted by matjazc on July 17, 2007 at 02:43 PM EDT #

Post a Comment:
Comments are closed for this entry.

Jignesh Shah is Principal Software Engineer in Application Integration Engineering, Oracle Corporation. AIE enables integration of ISV products including Oracle with Unified Storage Systems. You can also follow me on my blog http://jkshah.blogspot.com


« July 2016