MVSFORUMS.com

Sara1977 · Beginner Joined: 25 Apr 2004 Posts: 7 Topics: 4

Hi,

I want to know the DB2 Version installed in our machine. I referred precompilation listing. It says the version is 7.1

DB2 SQL PRECOMPILER VERSION 7 REL. 1.0
OPTIONS SPECIFIED: HOST(COB2),APOST,APOSTSQL,SOURCE
OPTIONS USED - SPECIFIED OR DEFAULTED

Can I get the version and release from any System catalog table to ensure whether it is 7.1?. (This is for preparing PMP!)

Regards,
Sara..

kolusu · Posted: Mon May 03, 2004 8:29 am Post subject:

Sara,

As ravi mentioned you can find the db2 version from the main screen of qmf or using DISPLAY GROUP command. You can also use -DISPLAY LOCATION command to locate the version number very easily

Check this link for detailed explanation of -DISPLAY LOCATION COMMAND

You can also use the set connection command in application programming and if the call is successfull you would get the version number similar to the display location command.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

bauer · Posted: Mon May 03, 2004 8:35 am Post subject:

Hi,

-DIS GROUP result looks like appended screenshot.

Doesn't DB2 level prompt the requestetd information ?

-dis group
,DSN7100I +DB2X DSN7GCMD,
,*** BEGIN DISPLAY OF GROUP(........) GROUP LEVEL(...),
, GROUP ATTACH NAME(....),
,--------------------------------------------------------------------,
,DB2 DB2 SYSTEM IRLM,
,MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC,
,-------- --- ---- -------- -------- --- -------- ---- --------,
,........ 0 DB2X +DB2X ACTIVE 710 CPE IR2X DB2XIRLM,
,--------------------------------------------------------------------,
,*** END DISPLAY OF GROUP(........),
,DSN9022I +DB2X DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION,

kolusu · Posted: Mon May 03, 2004 9:04 am Post subject:

bauer,

Read my post which is posted above your post.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kolusu · Posted: Mon May 03, 2004 10:46 am Post subject:

Ravi,

I never used -DIS GROUP command to get the version number . your links prove that the same command can be used to get the version info. I am sorry for contradicting your post. I am going to edit the post. My sincere apologies.

Both commands essentially show the same thing, but with DIS GROUP command you get a lot of information which can be quite overwhelming when you are just trying to get the version info. So I prefer DIS LOCATION command to DIS GROUP command.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Sara1977 · Beginner Joined: 25 Apr 2004 Posts: 7 Topics: 4

Thanks for all the responses.

My precompiler output, DIS GROUP or DIS LOCATION commands says that the version at my installation is 7.1

-DIS LOCATION:
DB2TPJ DSN07010 TPADB2J 0 0 2
DB2TPJ DSN07010 TPADB2V 0 0 2
DB2TPZ DSN07010 TPADB2X 0 0 2
DB2TPZ DSN07010 TPADB2Z 0 0 2

-DIS GROUP

DB2 1 DB2 -DB2M ACTIVE 710 C3 IRLM DB2IRLM
DB2D 2 DB2D -DB2D ACTIVE 710 C7 IRLD DB2DIRLM
DB2P 3 DB2P -DB2P ACTIVE 710 C3 IRLP DB2PIRLM

But QMF home panel says it is 7.2. I could very well confirm that the version is 7.1. But I just want to update that we can get the right DB2 version only from DIS GROUP or DIS LOCATION and QMF panel version could be what the latest release the QMF can support.Any contradition???

QMF HOME PANEL Query Management Facility
Version 7 Release 2

[/quote]

bauer · Posted: Tue May 04, 2004 5:19 am Post subject:

Hi kolusu,
hi ravi,

pls see my sample output. -DISP GROUP gives the version number.

By the way: The version number in the precompiler listing meens only the version of the precompiler not the DB2 subsystem.

Is is possible to work with precompiler version 6.0 and db2 subsystem version 7.2.

regards,
bauer