On Mar 6, 9:17 am, "Ultrak The DBA" <truthinl...@yahoo.comwrote:
I would like to connect to a remote server, which I have already
catalogued, and get the os and db2level information. I just realized
that even though I connect to the other server my '!hostname' and '!
db2level' commands are giving me the data for the server I am
currently telneted into.
Does anyone have a suggestion?
Thank you,
Kermit Lowry, III
I did a little more study, since we are at 8.2+ I was able to do
this:
SELECT INST_NAME, RELEASE_NUM , SERVICE_LEVEL, BLD_LEVEL FROM
TABLE(SYSPROC.ENV_GET_INST_INFO()) AS INSTANCEINFO
INST_NAME
RELEASE_NUM
SERVICE_LEVEL
BLD_LEVEL
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
dbi1134
03080106
DB2
v8.1.1.128
s061108
1 record(s) selected.