Re: onstat -g ses hostname info

In article <35AB2FE4.7485@email.address>, Danny Williams <dummy@email.address> wrote: > Hi there! > > onstat -g ses only provides 8 characters for the hostname field - even> when you provide a session ID. Is there any way to find out the full > hostname of the connected host? > > Danny > Informix "sysmaster database" has a table named "sysessions" which contains all sessions. Look at the "hostname" field (char(16)). The hostname may be "truncated"... SELECT sid, username, hostname FROM sysmaster:syssessions Ex. 566 dbo dgtah.digitro.co 564 dbo dgtaz 562 dbo dgtai.digitro.co 556 dbo dgtag.digitro.co 494 dbo dgtah.digitro.co 492 dbo dgtah.digitro.co 377 dbo dgtag.digitro.co 84 cds dgtaz -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum