remote server os and db2level info

Ultrak The DBA

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

Mar 6 '07 #1

Ultrak The DBA

On Mar 6, 9:17 am, "Ultrak The DBA" <truthinl...@yahoo.comwrote: 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.

Mar 6 '07 #2

Pierre Saint-Jacques

The db2level and hostname commands always are to the "machine" you are on.
If you "telnet" then both commands will give you the info. about the remote
server.
If you did not telnet and issue the commands on your local machine then you
get its hostname and the db2 level of code installed on that box.

Your second post is the expected answer because for you to select you had to
be connected to a db so you got that db's local environmant.
Regards, Pierre.



If you use a db2 connect statement then
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Ultrak The DBA" <truthinlife@yahoo.coma écrit dans le message de news:
1173190661.192053.9670@c51g2000cwc.googlegroups.co m...

Mar 7 '07 #3