How to get server_name or IP address of computer from select statement

grofaty · #1 (**permalink**) 04-20-07, 09:01

Hi,
I would like to write SQL to get info about server name or IP address on DB2 v9 on Windows. Is there any way to get some operating system info from "select" statement.

I have several testing databases and one production one. So it would be nice just to write "select server_name from..." or something like that. I would like to be 100% sure I am testing on test database.

Any help is very appreciated.
Thanks,
Grofaty

rahul_s80 · #2 (**permalink**) 04-20-07, 10:44

select INBOUND_COMM_ADDRESS from SYSIBMADM.SNAPAPPL

stolze · #3 (**permalink**) 04-21-07, 05:16

We also wrote a UDF at some point in time that does exactly the same. You could have a look at the code if you like to understand how it works: http://www.ibm.com/developerworks/db...ein/index.html

grofaty · #4 (**permalink**) 04-23-07, 01:38

Quote:

Originally Posted by rahul_s80

select INBOUND_COMM_ADDRESS from SYSIBMADM.SNAPAPPL

Hi,
this is db2 v9 specific. I also need the same solution for db2 v8 fp9. Is there any solution that works on v8 as well?
Thanks,
Grofaty

rahul_s80 · #5 (**permalink**) 04-23-07, 05:34

chk table function for application snapshot.
i think its there also with same col name.

grofaty · #6 (**permalink**) 04-23-07, 06:26

Hi,
SELECT INBOUND_COMM_ADDRESS FROM TABLE( SNAPSHOT_APPL( 'DB_NAME', -1 )) as SNAPSHOT_BP
The above command returns client IP's. I would like to get server IP - where DB is installed.
Any idea?
Thanks,
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech