Identify the sessions which using all tempspaces
Hi, Is there any way (any query/command), to identify the sessions which are trying to use all of the tempspaces? Thank you!!! Pravin Bankar pravinebankar@gmail.com
When running an onstat -g ses the bottom will list the temp t= ables
for each user. In this list is the
"partnum" which can be u= sed to look up the size.
User-created Temp tables :
partnu= m tabname = rowsize
300002 t1 &nbs= p; = ; 2000
John F. Miller III
STSM,= Lead Architect
[1]miller3= @us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)=
[2]-----ids-bounces@iiug.org wrote: -----
=
>To: [3]ids@iiug.or= g
>From: "PRAVIN BANKAR"
>Sent by: [4]ids-bounces@iiug.org
>Date: = 11/04/2015 02:35AM
>Subject: Identify the sessions which using all te= mpspaces [35995]
>
>Hi,
>
>Is there any way (any = query/command), to identify the sessions
which
>are
>trying to= use all of the tempspaces?
>
>Thank you!!!
>
>Pr= avin Bankar
>[5]pravinebankar@gmail.com
>
>
>***************=
******************************************************
>********** > Forum Note: Use "Reply" to post a response in the
discussion forum.=
>
>
>
References
1. 3D"mailto:miller3@us.ibm.com"
2. 3D"mailto:-----=
3. 3D"mailto:ids@iiug.org"
4. 3D"mailto:ids-bounces@iiug.org"
5. 3D"mailto:pravinebankar@gma=