DB2 Verion Details

Posted on 2007-07-28
Last Modified: 2007-07-30
1) We have Red Hat Linux 9
2) They say they installed DB2 9 but what I see with db2level is 8.x
3) When I connect to database I see DB2/Linux 8.2.4 ( Is this DB2/linux version details? )
4) Does db2level show client/server/both versions.
5) What should show up if really DB2 9 is insatlled.
6) Also, how many ways are there to find version, release, fixpack etc. details in server and client & what are they?
Question by:k_murli_krishna
    LVL 37

    Accepted Solution

    the best way to see the version of db2 that is installed is to use the db2level command
    my version 9 shows
    C:\program files\IBM\SQLLIB_01\bin>db2level
    DB21085I  Instance "DB2_01" uses "32" bits and DB2 code release "SQL09010" with

    level identifier "02010107".
    Informational tokens are "DB2 v9.1.0.356", "s060629", "NT32", and Fix Pack "0".
    Product is installed at "C:\PROGRA~1\IBM\SQLLIB~1" with DB2 Copy Name

    C:\program files\IBM\SQLLIB_01\bin>

    regrading the client / server question, i believe that the db2level command will show which server is installed, because when you install a server a client is also installed
    you can also use a table function called
    that will list all udb products and thier versions that are installed on the machine
    LVL 17

    Author Comment

    Thanks momi. Please answer my point 3). v9.1.0.356 => version9.release1.fixpack0.?356. What does s060629 denote?
    LVL 37

    Expert Comment

    0.356 is the build level, it's not the fixpack number. i have fixpack 0
    you can find more data about the db2level output here

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now