Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: How to check if DB2 is 32 or 64 bits ?

    Can someone tell me how to determine if DB2 is 32 or 64 bits from within a shell script ? I know how to find out for the kernel (prtconf -k) but I have no idea for DB2.

    Platform: AIX 5.1 (both 32 and 64 bits)
    DB2: UDB EE 7.2 FP11 (both 32 and 64 bits)

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to check if DB2 is 32 or 64 bits ?

    /db2inst1/sqllib/ctrl]$cat .instuse
    BitWidth=32
    InstanceType=3

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: How to check if DB2 is 32 or 64 bits ?

    Issue the db2level command, The 3 column :

    0=32bit
    1=64bit


    v7.1.0.84 would be 32 bit
    v7.1.1.84 Would be 64 bit
    David Quigley

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    David, when looking at the following web page, I am not sure that holds true in all cases:
    http://www-3.ibm.com/cgi-bin/db2www/...ist.d2w/report
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    Not sure what your referring too, but on the boxes that say 32 & 64 bit, it means that the fixes are included for both. I guess another way you could check and see if your $HOME/sqllib/bin would be a 32 bit system and $HOME/sqllib/bin64 would be a 64 bit system.


    Please look at the following link which shows the db2level
    http://www.developer.ibm.com/tech/fa...al?oid=2:23393
    David Quigley

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •