View previous topic :: View next topic
|
Author |
Message |
narvapreddy Warnings : 1 New User
Joined: 29 May 2005 Posts: 5
|
|
|
|
Hi every one,
may i know what is the current version of db2 |
|
Back to top |
|
|
withnams
New User
Joined: 06 Jul 2005 Posts: 26 Location: Chennai
|
|
|
|
In Db2 run commands....type
- DISPLAY GROUP and press enter.
You wil get all the details about DB2 installed in your system. |
|
Back to top |
|
|
bheemas
New User
Joined: 19 Sep 2005 Posts: 6
|
|
|
|
Hi,
alternatively you can execute this query in SPUFI to view DB2 Version parameters.
SELECT JUR_CODE, SSID, MVS, DSGROUP
FROM USS@DB2.DSSJTAB, USS@DB2.DSSKTAB
WHERE MVS = LPAR
ORDER BY DSGROUP DESC, JUR_CODE, MVS
;
Let me know if it works in ur shop.
Regards,
Bheemas |
|
Back to top |
|
|
EnjoyMF
New User
Joined: 27 May 2005 Posts: 88
|
|
|
|
hi bheemas
The query give by u in not working
i am getting -204
SQLCODE = -204, ERROR: USS@DB2.DSSJTAB IS AN UNDEFINED NAME
Regards
prasad |
|
Back to top |
|
|
bheemas
New User
Joined: 19 Sep 2005 Posts: 6
|
|
|
|
The table name on which you need to run this query is DSSJTAB. Find out on what qualifier it exists in your project. probably you may not be having USS@DB2.
Regards,
Bheemas |
|
Back to top |
|
|
|