View previous topic :: View next topic |
Author |
Message |
Sara1977 Beginner
Joined: 25 Apr 2004 Posts: 7 Topics: 4
|
Posted: Mon May 03, 2004 6:53 am Post subject: DB2: Version at my installation: |
|
|
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.. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
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
Last edited by kolusu on Mon May 03, 2004 10:45 am; edited 1 time in total |
|
Back to top |
|
|
bauer Intermediate
Joined: 10 Oct 2003 Posts: 315 Topics: 49 Location: Germany
|
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, |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
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 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
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 |
|
Back to top |
|
|
Sara1977 Beginner
Joined: 25 Apr 2004 Posts: 7 Topics: 4
|
Posted: Mon May 03, 2004 10:16 pm Post subject: |
|
|
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] |
|
Back to top |
|
|
bauer Intermediate
Joined: 10 Oct 2003 Posts: 315 Topics: 49 Location: Germany
|
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 |
|
Back to top |
|
|
|
|