IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Installed DB2 Version



IBM's flagship relational database management system
Post a reply

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: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time
Top

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: 265 times
Top

Re: Installed DB2 Version

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

DB2 Command
Select all
-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
Top

Re: Installed DB2 Version

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

Issue the following SQL statement:
Select all
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: 35
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks