Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DB2 Verion Details

Posted on 2007-07-28
3
Medium Priority
?
856 Views
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?
0
Comment
Question by:k_murli_krishna
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 19587331
hi
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
"DB2COPY1".


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
ENV_GET_PROD_INFO
that will list all udb products and thier versions that are installed on the machine
0
 
LVL 17

Author Comment

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

Expert Comment

by:momi_sabag
ID: 19590780
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
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.pd.doc/pd/c0020806.htm
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

581 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