IBM Mainframe Forum

Posted: **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 ?

Posted: **Fri Jan 25, 2013 3:41 pm**

Ask the DBA team?

Posted: **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.

Posted: **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).

IBM Mainframe Forum

Installed DB2 Version

Installed DB2 Version

Re: Installed DB2 Version

Re: Installed DB2 Version

Re: Installed DB2 Version