Try running: \set

I have tried to print the hostname in nzsimulator with /set. I am only getting 127.0.0.1. How to get the host ip of netezza simulator.

I am sure \set and nzstats both will give host ip if you run on the netezza box.

My question was particularly for simulator. somehow \set or nzstats both are printing localhost(127.0.0.1) on the simulator .I needed it to diagnose as I was not able to connect to database even on my local machine outside vm player. I was not getting any ip on eth0.

  I have changed the defauilt network setting of vmware simulator from "Bridged" to "NAT" and now I am able to get the network connection atleast on the same local box outside vmware. I am still unsuccessful in connecting that enviornment from any other machine in network. As this is not my immediate requirement. I can live with it.

Thanks.