Re: onstat -g ses hostname info

In article <6ofmge$4db$1@nnrp1.dejanews.com>, jgubler@my-dejanews.com wrote: > 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 > I'm not sure, but I think you can try to get that information from 'sysscblst'. It's just the table on which 'syssessions' view constructed. -- Vardan Aroustamian -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum