View previous topic :: View next topic |
Author |
Message |
priyam Beginner
Joined: 05 Jul 2006 Posts: 16 Topics: 12
|
Posted: Tue Aug 21, 2007 1:51 am Post subject: How to find out the DB2 Version. |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Tue Aug 21, 2007 7:14 am Post subject: |
|
|
priyam,
If you are authorized then you can issue the following command from the DB2 commands option from the DB2I PRIMARY OPTION MENU
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 |
|
 |
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Tue Aug 21, 2007 7:51 am Post subject: |
|
|
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 |
|
 |
CZerfas Intermediate
Joined: 31 Jan 2003 Posts: 211 Topics: 8
|
Posted: Thu Aug 23, 2007 2:06 am Post subject: |
|
|
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 |
|
 |
acevedo Beginner

Joined: 03 Dec 2002 Posts: 127 Topics: 0 Location: Europe
|
Posted: Thu Aug 23, 2007 3:59 am Post subject: Re: How to find out the DB2 Version. |
|
|
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 |
|
 |
pdhanvanthar Beginner
Joined: 26 Jul 2007 Posts: 2 Topics: 1
|
Posted: Thu Aug 23, 2007 6:22 am Post subject: Re: How to find out the DB2 Version. |
|
|
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 |
|
 |
|
|