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

db2 8.1.5 how obtain machine name

P: n/a
Hi

How obtain server (machine name) with db2 8.1.5 ?
I need get this name in select statement:

select (something)
from sysibm.sysdummy1

Would be nice also obtain fixpack level.

Unfortunnatelly I can't upgrade server and use env_get_sys_infor()
function.

Any hint?
Thanks
Yaro
Oct 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi, Yaro.

I'm hopeful that there's yet an easier way, but you may have to roll
your own UDF that calls, say, db2level and/or uname. Check out this
link:

http://www-128.ibm.com/developerwork...303stolze.html

--Jeff

Yaro wrote:
Hi

How obtain server (machine name) with db2 8.1.5 ?
I need get this name in select statement:

select (something)
from sysibm.sysdummy1

Would be nice also obtain fixpack level.

Unfortunnatelly I can't upgrade server and use env_get_sys_infor()
function.

Any hint?
Thanks
Yaro
Oct 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.