Re: help with sessid

emaus wrote: > Hi all: > IBM Informix 10.00FC10 + HDR > IBM AIX 6.1 > > > > When I run > the command: > > $ onstat –u |grep 6579097> > > > 7000001e2809660 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000001e2809da8 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0 > 7000001eb9654c0 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000001eb969648 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0 > 7000001eb98b860 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000001edfb3338 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0 > 7000001edfbdab0 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 7000001f2f01f30 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000001f2f0a988 Y------ 6579097 user01 host01 70000020485bd68 0 4 0 0 > 7000001f2f1ffc0 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000001f6d31618 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0 > 7000001f6d3f088 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000001f6d5bb40 Y------ 6579097 user01 host01 7000001fc52a878 0 4 0 0 > 7000001f9b67770 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0 > 7000001f9b72d78 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0 > 7000001f9b923e0 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 7000001f9b96568 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 7000001fe8f2598 Y--P--- 6579097 user01 host01 7000001efba50b0 0 4 2502 1269 > 70000020637cae0 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 700000206387258 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 70000020af9fd90 Y------ 6579097 user01 host01 7000001ef606400 0 4 0 0 > 70000020afa2940 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 70000020afabae0 Y------ 6579097 user01 host01 7000001ef0c0578 0 4 0 0 > 70000020bbec678 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 70000020bbecdc0 Y------ 6579097 user01 host01 7000001e2f3d8a0 0 4 0 0 > 70000020bc05e38 Y------ 6579097 user01 host01 7000001f91723e0 0 4 0 0 > 700000211099a98 Y------ 6579097 user01 host01 7000001f2507248 0 4 0 0 > 7000002110a07d0 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000002110c1b58 Y------ 6579097 user01 host01 7000001f8291f90 0 4 0 0 > 7000002150434c0 Y------ 6579097 user01 host01 7000001e8847600 0 4 0 0 > 70000021504f958 Y------ 6579097 user01 host01 7000001f0d55e00 0 4 0 0 > > > > > I shows the same number of threads with the same > user and same sessid. This same event is repeated for other user's > > I would appreciate help to get the problem > > > > Thank you very much > Not a problem I guess - your session is probably using PDQPRIORITY and has multiple scan threads maybe. Check output of 'onstat -g ath' - What are the names of these threads ? HTH Tilman

tilleul17@web.de wrote: > emaus wrote: >> Hi all: >> IBM Informix 10.00FC10 + HDR >> IBM AIX 6.1 >> >> >> >> When I run >> the command: >> $ onstat 'u |grep 6579097>> >> >> >> 7000001e2809660 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000001e2809da8 Y------ 6579097 user01 host01 7000001e8847600 0 >> 4 0 0 >> 7000001eb9654c0 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000001eb969648 Y------ 6579097 user01 host01 7000001e8847600 0 >> 4 0 0 >> 7000001eb98b860 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000001edfb3338 Y------ 6579097 user01 host01 7000001ef606400 0 >> 4 0 0 >> 7000001edfbdab0 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 7000001f2f01f30 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000001f2f0a988 Y------ 6579097 user01 host01 70000020485bd68 0 >> 4 0 0 >> 7000001f2f1ffc0 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000001f6d31618 Y------ 6579097 user01 host01 7000001ef606400 0 >> 4 0 0 >> 7000001f6d3f088 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000001f6d5bb40 Y------ 6579097 user01 host01 7000001fc52a878 0 >> 4 0 0 >> 7000001f9b67770 Y------ 6579097 user01 host01 7000001e8847600 0 >> 4 0 0 >> 7000001f9b72d78 Y------ 6579097 user01 host01 7000001ef606400 0 >> 4 0 0 >> 7000001f9b923e0 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 7000001f9b96568 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 7000001fe8f2598 Y--P--- 6579097 user01 host01 7000001efba50b0 0 >> 4 2502 1269 >> 70000020637cae0 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 700000206387258 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 70000020af9fd90 Y------ 6579097 user01 host01 7000001ef606400 0 >> 4 0 0 >> 70000020afa2940 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 70000020afabae0 Y------ 6579097 user01 host01 7000001ef0c0578 0 >> 4 0 0 >> 70000020bbec678 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 70000020bbecdc0 Y------ 6579097 user01 host01 7000001e2f3d8a0 0 >> 4 0 0 >> 70000020bc05e38 Y------ 6579097 user01 host01 7000001f91723e0 0 >> 4 0 0 >> 700000211099a98 Y------ 6579097 user01 host01 7000001f2507248 0 >> 4 0 0 >> 7000002110a07d0 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000002110c1b58 Y------ 6579097 user01 host01 7000001f8291f90 0 >> 4 0 0 >> 7000002150434c0 Y------ 6579097 user01 host01 7000001e8847600 0 >> 4 0 0 >> 70000021504f958 Y------ 6579097 user01 host01 7000001f0d55e00 0 >> 4 0 0 >> >> >> >> I shows the same number of threads with the same >> user and same sessid. This same event is repeated for other user's >> I would appreciate help to get the problem >> >> >> Thank you very much > > Not a problem I guess - your session is probably using PDQPRIORITY and > has multiple scan threads maybe. > Check output of 'onstat -g ath' - What are the names of these threads ? > HTH > Tilman Or perhaps there is a stored procedure which had "update statistics for procedure" run with PDQPRIORITY set?

Hi all: MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority DS_MAX_QUERIES 20 # Maximum number of decision support queries DS_TOTAL_MEMORY 4000000 # Decision support memory (Kbytes) DS_MAX_SCANS 1048576 # Maximum number of decision support scans DS_NONPDQ_QUERY_MEM 128 # Non PDQ query memory (Kbytes) DATASKIP off # List of dbspaces to skip Thanks > From: theBP@Usenet-News.Net > Subject: Re: help with sessid > Date: Tue, 4 Aug 2009 17:11:36 +0100 > To: informix-list@iiug.org > > tilleul17@web.de wrote: > > emaus wrote: > >> Hi all: > >> IBM Informix 10.00FC10 + HDR > >> IBM AIX 6.1 > >> > >> > >> > >> When I run > >> the command: > >> $ onstat –u |grep 6579097> >> > >> > >> > >> 7000001e2809660 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000001e2809da8 Y------ 6579097 user01 host01 7000001e8847600 0 > >> 4 0 0 > >> 7000001eb9654c0 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000001eb969648 Y------ 6579097 user01 host01 7000001e8847600 0 > >> 4 0 0 > >> 7000001eb98b860 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000001edfb3338 Y------ 6579097 user01 host01 7000001ef606400 0 > >> 4 0 0 > >> 7000001edfbdab0 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 7000001f2f01f30 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000001f2f0a988 Y------ 6579097 user01 host01 70000020485bd68 0 > >> 4 0 0 > >> 7000001f2f1ffc0 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000001f6d31618 Y------ 6579097 user01 host01 7000001ef606400 0 > >> 4 0 0 > >> 7000001f6d3f088 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000001f6d5bb40 Y------ 6579097 user01 host01 7000001fc52a878 0 > >> 4 0 0 > >> 7000001f9b67770 Y------ 6579097 user01 host01 7000001e8847600 0 > >> 4 0 0 > >> 7000001f9b72d78 Y------ 6579097 user01 host01 7000001ef606400 0 > >> 4 0 0 > >> 7000001f9b923e0 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 7000001f9b96568 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 7000001fe8f2598 Y--P--- 6579097 user01 host01 7000001efba50b0 0 > >> 4 2502 1269 > >> 70000020637cae0 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 700000206387258 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 70000020af9fd90 Y------ 6579097 user01 host01 7000001ef606400 0 > >> 4 0 0 > >> 70000020afa2940 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 70000020afabae0 Y------ 6579097 user01 host01 7000001ef0c0578 0 > >> 4 0 0 > >> 70000020bbec678 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 70000020bbecdc0 Y------ 6579097 user01 host01 7000001e2f3d8a0 0 > >> 4 0 0 > >> 70000020bc05e38 Y------ 6579097 user01 host01 7000001f91723e0 0 > >> 4 0 0 > >> 700000211099a98 Y------ 6579097 user01 host01 7000001f2507248 0 > >> 4 0 0 > >> 7000002110a07d0 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000002110c1b58 Y------ 6579097 user01 host01 7000001f8291f90 0 > >> 4 0 0 > >> 7000002150434c0 Y------ 6579097 user01 host01 7000001e8847600 0 > >> 4 0 0 > >> 70000021504f958 Y------ 6579097 user01 host01 7000001f0d55e00 0 > >> 4 0 0 > >> > >> > >> > >> I shows the same number of threads with the same > >> user and same sessid. This same event is repeated for other user's > >> I would appreciate help to get the problem > >> > >> > >> Thank you very much > > > > Not a problem I guess - your session is probably using PDQPRIORITY and > > has multiple scan threads maybe. > > Check output of 'onstat -g ath' - What are the names of these threads ? > > HTH > > Tilman > > Or perhaps there is a stored procedure which had "update statistics for procedure" run with PDQPRIORITY set? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ MSN Música: radio online y GRATIS. ¡Disfrutala! http://latam.msn.cyloop.com/

emaus wrote: > Hi all: > > MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority > DS_MAX_QUERIES 20 # Maximum number of decision support queries > DS_TOTAL_MEMORY 4000000 # Decision support memory (Kbytes) > DS_MAX_SCANS 1048576 # Maximum number of decision support scans > DS_NONPDQ_QUERY_MEM 128 # Non PDQ query memory (Kbytes) > DATASKIP off # List of dbspaces to skip> > > Thanks > > onstat -g ses "sessionid with many threads" output would help ...