By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

remote server os and db2level info

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Mar 6 '07 #2

P: n/a
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" <tr*********@yahoo.coma écrit dans le message de news:
11********************@c51g2000cwc.googlegroups.co m...
>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 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.