MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to find out the DB2 Version.

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
priyam
Beginner


Joined: 05 Jul 2006
Posts: 16
Topics: 12

PostPosted: Tue Aug 21, 2007 1:51 am    Post subject: How to find out the DB2 Version. Reply with quote

Hi,
This may be a silly question.Sorry for that.

Can any one tell me how to find out the DB2 Version, which am using from ISPF Main Menu or any other way?

Thanks is Advance!!!
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Aug 21, 2007 7:14 am    Post subject: Reply with quote

priyam,

If you are authorized then you can issue the following command from the DB2 commands option from the DB2I PRIMARY OPTION MENU
Code:

-DISPLAY GROUP


The output of the above command will show the version. ex: for version 8, the output would show 810. Along with this information there is a ton of information returned from the command.

If you are not authorized to run the above command then we need to query the catalog tables.

for ex: If you find the IPlist table (SYSIBM.IPLIST) then you are running DB2 Version 8 and higher

Code:

SELECT    NAME                 
  FROM SYSIBM.SYSTABLES 
 WHERE CREATOR = 'SYSIBM'
   AND NAME    = 'IPLIST'


If you find the statistics history table(SYSIBM.SYSCOLDIST_HIST) then you are using DB2 V7 and higher

Code:

SELECT    NAME                 
  FROM SYSIBM.SYSTABLES 
 WHERE CREATOR = 'SYSIBM'
   AND NAME    = 'SYSCOLDIST_HIST'


If you find any of the SYSIBM.SYSPARMS table then you are running Db2 version 6 and higher.

Code:

SELECT    NAME                 
  FROM SYSIBM.SYSTABLES 
 WHERE CREATOR = 'SYSIBM'
   AND NAME    = 'SYSPARMS'


Also the main panel of QMF lists the version of QMF you are running. This sometimes is in sync with the actual Db2 version of your system.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Tue Aug 21, 2007 7:51 am    Post subject: Reply with quote

Another place, if you have the authority to browse, is the sdsf output of the db2master (db2mast) job.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Thu Aug 23, 2007 2:06 am    Post subject: Reply with quote

Hello Dick,

could you supply us with a screenshot, since I don't manage to identify the version information in our DB2 master output?

regards
Christian
Back to top
View user's profile Send private message
acevedo
Beginner


Joined: 03 Dec 2002
Posts: 127
Topics: 0
Location: Europe

PostPosted: Thu Aug 23, 2007 3:59 am    Post subject: Re: How to find out the DB2 Version. Reply with quote

priyam wrote:
...or any other way?


in the db2 precompiler step of the output of a db2 program compilation..

Code:
DB2 SQL PRECOMPILER         VERSION 7 REL. 1.0         


hth
Back to top
View user's profile Send private message
pdhanvanthar
Beginner


Joined: 26 Jul 2007
Posts: 2
Topics: 1

PostPosted: Thu Aug 23, 2007 6:22 am    Post subject: Re: How to find out the DB2 Version. Reply with quote

Hi Priyam,

This is certainly not a silly question . Since we all have/had such question ,

Actually if you are familiar with freezeframe ,
then you can see your DB2 version in your DB2 measurement statistics under DB2 Measurement Profile

or
in INSYNC , go to DB2 - here go to INSYNC DBA you will see the DB2 version .
priyam wrote:
Hi,
This may be a silly question.Sorry for that.

Can any one tell me how to find out the DB2 Version, which am using from ISPF Main Menu or any other way?

Thanks is Advance!!!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group