onstat -g ses is truncating the hostname

Hello, I'm running an onstat -g ses as I need to find out the pids on various hosts. But it is truncating the hostname to 8 characters. e.g. session #RSAM total used id user tty pid hostname threads memory memory 33141 simon - 32548 myhost00 1 651264 633984 33106 ben - 22024 myhost00 1 368640 356112 Where myhost00 could be myhost002 or myhost007 etc. Is there a way I can get it to return the full hostname? It is on Solaris 9. Thanks.

forum.subscriber@iiug.org wrote on 03/08/2005 01:53:38 AM: > I'm running an onstat -g ses as I need to find out the pids on various > hosts. But it is truncating the hostname to 8 characters. e.g. > > session #RSAM total used > id user tty pid hostname threads memory memory > 33141 simon - 32548 myhost00 1 651264 633984 > 33106 ben - 22024 myhost00 1 368640 356112 > > Where myhost00 could be myhost002 or myhost007 etc. > > Is there a way I can get it to return the full hostname? > > It is on Solaris 9. I'm feeling like a broken record today (do people still understand the reference to a circular grooved piece of vinyl?). Which version of IDS are you using? I am not aware of an option to display longer hostnames in the '-g ses' output - which isn't quite the same as saying there is no such option. Did you look in the manual for one? -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Information Management Division 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!"

you can sub $1 for the session id or create this as a script and pass the session id. $INFORMIXDIR/bin/dbaccess sysmaster <<! select sid, username, pid, hostname from syssessions where sid = $1! "Jonathan Le...." <jleffler@us.ibm.com> Sent by: forum.subscriber@iiug.org 03/08/2005 03:06 PM To ids@iiug.org cc Subject Re: onstat -g ses is truncating the hostname [4436] forum.subscriber@iiug.org wrote on 03/08/2005 01:53:38 AM: > I'm running an onstat -g ses as I need to find out the pids on various > hosts. But it is truncating the hostname to 8 characters. e.g. > > session #RSAM total used > id user tty pid hostname threads memory memory > 33141 simon - 32548 myhost00 1 651264 633984 > 33106 ben - 22024 myhost00 1 368640 356112 > > Where myhost00 could be myhost002 or myhost007 etc. > > Is there a way I can get it to return the full hostname? > > It is on Solaris 9. I'm feeling like a broken record today (do people still understand the reference to a circular grooved piece of vinyl?). Which version of IDS are you using? I am not aware of an option to display longer hostnames in the '-g ses' output - which isn't quite the same as saying there is no such option. Did you look in the manual for one? -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Information Management Division 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!"

Thanks for all the replies. onstat truncates which I didn't realise so I just can't use it. I have to query the sysmaster db directly instead. select sid, hostname, pid, username from syssessions; Cheers, Maeve "Darren_Jaco...." <Darren_Jacobs@carmax.com> wrote: you can sub $1 for the session id or create this as a script and pass the session id. $INFORMIXDIR/bin/dbaccess sysmaster <select sid, username, pid, hostname from syssessions where sid = $1 ! "Jonathan Le...." Sent by: forum.subscriber@iiug.org 03/08/2005 03:06 PM To ids@iiug.org cc Subject Re: onstat -g ses is truncating the hostname [4436] forum.subscriber@iiug.org wrote on 03/08/2005 01:53:38 AM: > I'm running an onstat -g ses as I need to find out the pids on various > hosts. But it is truncating the hostname to 8 characters. e.g. > > session #RSAM total used > id user tty pid hostname threads memory memory > 33141 simon - 32548 myhost00 1 651264 633984 > 33106 ben - 22024 myhost00 1 368640 356112 > > Where myhost00 could be myhost002 or myhost007 etc. > > Is there a way I can get it to return the full hostname? > > It is on Solaris 9. I'm feeling like a broken record today (do people still understand the reference to a circular grooved piece of vinyl?). Which version of IDS are you using? I am not aware of an option to display longer hostnames in the '-g ses' output - which isn't quite the same as saying there is no such option. Did you look in the manual for one? -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Information Management Division 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" --------------------------------- Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web