I'm using db2 CLI client on AIX, which was set up for me by an admin.

I would like to know the hostname of the DB2 server that I'm
connecting to.

How do I see that?

Thanks!

"DavidFilmer" <usenet (AT) davidfilmer (DOT) com> wrote

Try this:

db2 "select * from sysibmadm.env_sys_info"

On Oct 12, 7:06*pm, "Mark A" <no... (AT) nowhere (DOT) com> wrote:
no joy -

SQL0204N "SYSIBMADM.ENV_SYS_INFO" is an undefined name.
SQLSTATE=42704

thx

"DavidFilmer" <usenet (AT) davidfilmer (DOT) com> wrote

What DB2 product (including OS) and release are your using?

for somewhat older DB2 versions:

SELECT HOST_NAME FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) T