Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Db2 query to find the current version of DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kutty.r

New User


Joined: 22 Jun 2006
Posts: 24

PostPosted: Fri Aug 01, 2008 2:27 pm    Post subject: Db2 query to find the current version of DB2
Reply with quote

Hi all,

Do we have any Db2 query to find the current version and release for the Database(DB2) which we were working on, if so could u please help me with that query.
Thanks!
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Aug 01, 2008 2:55 pm    Post subject:
Reply with quote

as i answered in the other website, i always look at a bind output listing.

not really sure where db2 stores its version number.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Fri Aug 01, 2008 6:56 pm    Post subject:
Reply with quote

Go to DB2 commands in DB2 primary option and issue the below command.

-DIS GROUP or -DIS GROUP DETAIL

You should get some info. You can issue the above command from DSN console as well. (Go to TSO commands and enter DSN, issue the above commands and enter END to come out).
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Aug 01, 2008 7:08 pm    Post subject:
Reply with quote

vini_srcna,

thx vini, i can issue -dis database but racf'd out of -dis group
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Sun Aug 03, 2008 10:06 pm    Post subject:
Reply with quote

you are welcome..

I often see DB2 Version number when using DB2 tools .Most of the tools displays the version installed.

Let me check if there are any other ways.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Mon Aug 04, 2008 3:51 am    Post subject:
Reply with quote

I usually just query my DBAs and they tell me.
Back to top
View user's profile Send private message
kutty.r

New User


Joined: 22 Jun 2006
Posts: 24

PostPosted: Mon Aug 04, 2008 2:50 pm    Post subject: Reply to: Db2 query to find the current version of DB2
Reply with quote

Hi All,

i don't have the authorization ti issue a -DIS GROUP DETAIL command , do we have any other alternative.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Mon Aug 04, 2008 2:59 pm    Post subject:
Reply with quote

Hi Dick,

How do we find it in bind output listing.?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Aug 04, 2008 5:33 pm    Post subject:
Reply with quote

Hi vini,

got me. I just looked at my current site and noticed what they give me for a db2 bind output listing, does not tell me the db2 version.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Mon Aug 04, 2008 7:48 pm    Post subject:
Reply with quote

The QMF home page is another place to find it.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Aug 04, 2008 8:00 pm    Post subject:
Reply with quote

Terry,

I think that is the qmf rel vsn.

we are using a v7 precompiler on development machine

db2 v7 on development machine

qmf on development is Vsn 8.1

db2 v8 on production machine.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Mon Aug 04, 2008 10:55 pm    Post subject:
Reply with quote

Last time I had access to a mainframe, it displayed the DB2 version. QMF version was also probably there, but I'm certain about the DB2 version. Two more places to look might be SPUFI and CA-Platinum.
Back to top
View user's profile Send private message
Suresh Ponnusamy

Active User


Joined: 22 Feb 2008
Posts: 107
Location: New York

PostPosted: Mon Aug 04, 2008 11:02 pm    Post subject:
Reply with quote

We have File Aid for DB2 in our project. There we can find the version.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts Spool Extract for Z /os 1.04 version Khadhar Basha CLIST & REXX 3 Thu Sep 28, 2017 3:14 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us