View previous topic :: View next topic
|
Author |
Message |
kutty.r
New User
Joined: 22 Jun 2006 Posts: 24
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
vini_srcna,
thx vini, i can issue -dis database but racf'd out of -dis group |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
I usually just query my DBAs and they tell me. |
|
Back to top |
|
|
kutty.r
New User
Joined: 22 Jun 2006 Posts: 24
|
|
|
|
Hi All,
i don't have the authorization ti issue a -DIS GROUP DETAIL command , do we have any other alternative. |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Hi Dick,
How do we find it in bind output listing.? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
The QMF home page is another place to find it. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
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 |
|
|
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008 Posts: 107 Location: New York
|
|
|
|
We have File Aid for DB2 in our project. There we can find the version. |
|
Back to top |
|
|
|