What catalog table contains the hostname?

Currently the onstat -g ses only displays the first 8 characters of a remote host, is there more that I can get from the catalog table(s)? OS - AIX 6.1 $onstat -g ses IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 1 days 04:26:04 -- 235600 Kbytes session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 86 informix - 0 - 0 12288 12288 off 80 informix - 0 - 0 12288 12288 off 35 informix - 0 - 0 12288 12288 off 30 informix - 0 - 1 606208 569496 off 29 informix - 0 - 1 679936 645024 off 28 informix - 0 - 1 471040 393760 off 17 informix - 0 - 0 12288 12288 off 16 informix - 0 - 0 12288 12288 off 11 informix - 0 - 0 16384 13872 off 10 informix - 0 - 0 16384 13872 off 9 informix - 0 - 0 16384 13872 off 8 informix - 0 - 0 16384 13872 off 7 informix - 0 - 0 12288 12288 off 6 informix - 0 - 0 12288 12288 off 5 informix - 0 - 0 16384 13872 off 4 informix - 0 - 0 16384 13872 off 3 informix - 0 - 0 12288 12288 off 2 informix - 0 - 0 12288 12288 off 16001 osnd - -1 uskwasp3 1 45056 33704 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU *******************************************************************

sysmaster:syssessions has the full host name. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 9, 2010 at 3:13 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Currently the onstat -g ses only displays the first 8 characters of a > remote host, is there more that I can get from the catalog table(s)? > > OS - AIX 6.1 > > $onstat -g ses > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 1 > days 04:26:04 -- 235600 Kbytes> > session #RSAM total used > dynamic > > id user tty pid hostname threads memory memory > explain > > 86 informix - 0 - 0 12288 12288 > off > > 80 informix - 0 - 0 12288 12288 > off > > 35 informix - 0 - 0 12288 12288 > off > > 30 informix - 0 - 1 606208 569496 > off > > 29 informix - 0 - 1 679936 645024 > off > > 28 informix - 0 - 1 471040 393760 > off > > 17 informix - 0 - 0 12288 12288 > off > > 16 informix - 0 - 0 12288 12288 > off > > 11 informix - 0 - 0 16384 13872 > off > > 10 informix - 0 - 0 16384 13872 > off > > 9 informix - 0 - 0 16384 13872 > off > > 8 informix - 0 - 0 16384 13872 > off > > 7 informix - 0 - 0 12288 12288 > off > > 6 informix - 0 - 0 12288 12288 > off > > 5 informix - 0 - 0 16384 13872 > off > > 4 informix - 0 - 0 16384 13872 > off > > 3 informix - 0 - 0 12288 12288 > off > > 2 informix - 0 - 0 12288 12288 > off > > 16001 osnd - -1 uskwasp3 1 45056 33704 > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd61a52a9c48204889dbec7

Great. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Wednesday, June 09, 2010 2:22 PM To: ids@iiug.org Subject: Re: What catalog table contains the hostname? [20352] sysmaster:syssessions has the full host name. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 9, 2010 at 3:13 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Currently the onstat -g ses only displays the first 8 characters of a > remote host, is there more that I can get from the catalog table(s)? > > OS - AIX 6.1 > > $onstat -g ses > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 1 > days 04:26:04 -- 235600 Kbytes> > session #RSAM total used > dynamic > > id user tty pid hostname threads memory memory > explain > > 86 informix - 0 - 0 12288 12288 > off > > 80 informix - 0 - 0 12288 12288 > off > > 35 informix - 0 - 0 12288 12288 > off > > 30 informix - 0 - 1 606208 569496 > off > > 29 informix - 0 - 1 679936 645024 > off > > 28 informix - 0 - 1 471040 393760 > off > > 17 informix - 0 - 0 12288 12288 > off > > 16 informix - 0 - 0 12288 12288 > off > > 11 informix - 0 - 0 16384 13872 > off > > 10 informix - 0 - 0 16384 13872 > off > > 9 informix - 0 - 0 16384 13872 > off > > 8 informix - 0 - 0 16384 13872 > off > > 7 informix - 0 - 0 12288 12288 > off > > 6 informix - 0 - 0 12288 12288 > off > > 5 informix - 0 - 0 16384 13872 > off > > 4 informix - 0 - 0 16384 13872 > off > > 3 informix - 0 - 0 12288 12288 > off > > 2 informix - 0 - 0 12288 12288 > off > > 16001 osnd - -1 uskwasp3 1 45056 33704 > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd61a52a9c48204889dbec7 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

The size of the hostname column in the sysmaster:syssessions table was increased in version 11.10 to 256 bytes. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/09/2010 12:22:22 PM: > [image removed] > > Re: What catalog table contains the hostname? [20352] > > Art Kagel > > to: > > ids > > 06/09/2010 12:23 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > sysmaster:syssessions has the full host name. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Wed, Jun 9, 2010 at 3:13 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > > > Currently the onstat -g ses only displays the first 8 characters of a > > remote host, is there more that I can get from the catalog table(s)? > > > > OS - AIX 6.1 > > > > $onstat -g ses > > > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 1 > > days 04:26:04 -- 235600 Kbytes> > > > session #RSAM total used > > dynamic > > > > id user tty pid hostname threads memory memory > > explain > > > > 86 informix - 0 - 0 12288 12288 > > off > > > > 80 informix - 0 - 0 12288 12288 > > off > > > > 35 informix - 0 - 0 12288 12288 > > off > > > > 30 informix - 0 - 1 606208 569496 > > off > > > > 29 informix - 0 - 1 679936 645024 > > off > > > > 28 informix - 0 - 1 471040 393760 > > off > > > > 17 informix - 0 - 0 12288 12288 > > off > > > > 16 informix - 0 - 0 12288 12288 > > off > > > > 11 informix - 0 - 0 16384 13872 > > off > > > > 10 informix - 0 - 0 16384 13872 > > off > > > > 9 informix - 0 - 0 16384 13872 > > off > > > > 8 informix - 0 - 0 16384 13872 > > off > > > > 7 informix - 0 - 0 12288 12288 > > off > > > > 6 informix - 0 - 0 12288 12288 > > off > > > > 5 informix - 0 - 0 16384 13872 > > off > > > > 4 informix - 0 - 0 16384 13872 > > off > > > > 3 informix - 0 - 0 12288 12288 > > off > > > > 2 informix - 0 - 0 12288 12288 > > off > > > > 16001 osnd - -1 uskwasp3 1 45056 33704 > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd., B4-266A > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com> > > > > Page via Skytel: 2244650553@sprint.skytel.com > > <mailto:2244650553@sprint.skytel.com> > > > > Informix or MySQL Primary: 9110210@skytel.com > > <mailto:9110210@skytel.com> > > > > Informix or MySQL Secondary: 7276872@skytel.com > > <mailto:7276872@skytel.com> > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > > " > > > > " Lets not forget - GO Pistons and Red Wings! " > > > > GSU > > > > ******************************************************************* > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --000e0cd61a52a9c48204889dbec7 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >