RE: Total memory & used memory in onstat -g ses
Arun,
It looks like a join of syspools with either the syssessions or sysscblst
table will yield what I need.
session #RSAM total used
id user tty pid hostname threads memory memory
1474 sapr3 - 12686 wrax3921 1 180224 177172
1472 sapr3 - 56390 wrax3921 1 3489792 3475464
1332 sapr3 - 14724 wrax3921 1 532480 529664
1284 sapr3 - 53766 wrax3921 1 8077312 5405012
1254 sapr3 - 54236 wrax3921 1 8069120 6246496
1242 sapr3 - 26414 wrax3921 1 7225344 6844236
-- clipped --
We are running on AIX and the syssessions table does contain a 16 character
host name. In fact, I am already querying syssessions to identify
workstations who are connected to our Data Warehouse instance.
sid user database tty start_time_pdt pid
97 busobj busobj IVSD58004 1998-08-28 13:25 235
98 busobj busobj IVSD58004 1998-08-28 13:26 235
99 agoines quality IVSD58004 1998-08-28 13:29 235
100 agoines quality IVSD58004 1998-08-28 13:37 235
170 informix quality 1998-08-29 10:30 24862
Thank you for your assistance.
Rick
-----Original Message-----
From: Arun Shastry [mailto:arun@accentsoftware.com]
Sent: Thursday, September 10, 1998 13:34
To: informix-list@iiug.org
Subject: Re: Total memory & used memory in onstat -g ses
Look in syspools. You'll need to do a little math to exactly reproduce the
onstat -g ses info., but everything you need is there.
syssessions has char(16) for the hostname, but if you are on an HP system,
HP-UX uses only 8 character hostnames.
Good luck,
Arun
Bernstein, Rick wrote:
> The onstat -g ses commands displays total memory and used memory by
> session. Does anyone know how I can reproduce this display using
> sysmaster tables?
>
> I am trying to determine which host(s) are initiating sessions using
larger
> amounts of memory. This onstat command shows only the first 8 characters
> of the host name. Unfortunately, all of our SAP application servers use
the
>
> same first 8 characters in their host name, and our management is
> unwilling to change this naming convention.
>
> Your assistance in finding another way to display this information
> would be appreciated.
>
> Rick Bernstein Phone: (619) 458-7048
> Principal Database Administrator FAX: (619) 458-7640
> Alaris Medical Systems E-mail: rbernste@alarismed.com
> San Diego, CA 92121