Installed DB2 Version



IBM's flagship relational database management system

Installed DB2 Version

Postby fornanthakumar » Fri Jan 25, 2013 11:39 am

Hi,

Good Day.

Can somebody tell me, how do we know what is the DB2 version installed in my system ?
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 70
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Installed DB2 Version

 

Re: Installed DB2 Version

Postby BillyBoyo » Fri Jan 25, 2013 3:41 pm

Ask the DBA team?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Installed DB2 Version

Postby GuyC » Fri Jan 25, 2013 6:00 pm

DB2 Command
-DIS GROUP DETAIL

will retutn you LEVEL(101) MODE(NFM) when you are in Version 10 New Function Mode.
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Installed DB2 Version

Postby alexm » Fri Feb 01, 2013 4:26 pm

Issue the following SQL statement:
SELECT 'VERSION=' ,GETVARIABLE('SYSIBM.VERSION') FROM SYSIBM.SYSDUMMY1 ;
---------+---------+
VERSION=  DSN09015
---------+---------+


See DB2 SQL Reference for explanations regarding the GETVARIABLE function (and possibilities), and the returned value (DSN09015, in the sample above).
;)
User avatar
alexm
 
Posts: 33
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post