Oninit cdi / Archive
Talk to an expert →

onstat -u - Why so many redunant user id's????

Posted in 2000

Topics: General Discussion

InfoJones — — source: Informix-list mailing list archive (1991-1998)

Can anyone tell me why I'm getting so many redundant/duplicate user process id's when I run onstat -u? Below is an output from the following command: onstat -u | grep pamc why is sessid 54753 repeated? 40050c60 Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0 40055148 Y-B---- 54753 pamc 3 416f3e34 0 3 0 0 40056ed0 Y-B---- 54753 pamc 3 40edf0b0 0 3 0 0 40059630 Y-B---- 54753 pamc 3 4104c478 0 3 0 0 4005c768 Y-B---- 54753 pamc 3 418e6664 0 3 0 0 4005d62c Y-B---- 54753 pamc 3 804e1600 0 3 0 0 4006fd7c Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0 40074c3c Y-B---- 54753 pamc 3 40f26188 0 3 0 0 41410774 Y-B---- 54753 pamc 3 418e5f14 0 3 0 0 414138ac Y-B---- 54753 pamc 3 41769910 0 3 0 0 41417d94 Y-B---- 54753 pamc 3 409cf7d0 0 3 2 0 41418c58 Y-B---- 54753 pamc 3 902fb22c 0 3 0 0 4141a008 Y-B---- 54753 pamc 3 907aff10 0 3 0 0 4141aecc Y-B---- 54753 pamc 3 40d8dcc0 0 3 4 0 41426ec0 Y-B---- 54753 pamc 3 9085be80 0 3 0 0 4142cc44 --B-R-- 54753 pamc 3 0 0 3 0 0 4142d130 Y-B---- 54753 pamc 3 80035a64 0 3 0 0 4142e9cc Y-B---- 54753 pamc 3 40549438 0 3 0 0 41430754 Y-B---- 54753 pamc 3 416f33a0 0 3 0 0 41433d78 Y-B---- 54753 pamc 3 80ef9f74 0 3 0 0 41435128 Y-B---- 54753 pamc 3 40d8d3f0 0 3 4 0 80211634 Y-B---- 54753 pamc 3 40473568 0 3 0 0 80215144 Y-B---- 54753 pamc 3 907af984 0 3 0 0 80217d90 --BP--- 54753 pamc 3 0 0 3 107 3 80218c54 Y-B---- 54753 pamc 3 40496378 0 3 0 0 8021bd8c Y-B---- 54753 pamc 3 403d3600 0 3 0 0 8021e9d8 Y-B---- 54753 pamc 3 40cd39fc 0 3 0 0 80220274 Y-B---- 54753 pamc 3 409cf7d0 0 3 6 0 80221ffc Y-B---- 54753 pamc 3 804d10b8 0 3 0 0 80224c48 Y--P--- 54749 pamc PVINEYAR 90f5c060 0 2 3 0 80225620 Y-B---- 54753 pamc 3 40413940 0 3 0 0 80230c3c Y-B---- 54753 pamc 3 90aadaec 0 3 0 0 9044a774 Y-B---- 54753 pamc 3 4146780c 0 3 0 0 9044b14c Y-B---- 54753 pamc 3 800354d8 0 3 0 0 9044c010 Y-B---- 54753 pamc 3 804d1988 0 3 0 0 9044e284 Y-B---- 54753 pamc 3 804d1988 0 3 7 0 9044e770 Y-B---- 54753 pamc 3 404134d8 0 3 0 0 90457b18 Y-B---- 54753 pamc 3 80377ccc 0 3 0 0 9045ac50 Y-B---- 54753 pamc 3 403d3e34 0 3 0 0 9045c9d8 Y-B---- 54753 pamc 3 80ceb310 0 3 0 0 9045d89c Y-B---- 54753 pamc 3 404c1988 0 3 0 0 90463134 Y-B---- 54753 pamc 3 40413940 0 3 0 0 90463620 Y-B---- 54753 pamc 3 804d10b8 0 3 0 0 90467130 Y-B---- 54753 pamc 3 40d8d3f0 0 3 1 0 90467b08 Y-B---- 54753 pamc 3 41165194 0 3 0 0

↪ replying to InfoJones
William Rice — — source: Informix-list mailing list archive (1991-1998)

InfoJones wrote: > Can anyone tell me why I'm getting so many redundant/duplicate user > process id's when I run onstat -u? > > Below is an output from the following command: > onstat -u | grep pamc why is sessid 54753 repeated?> > 40050c60 Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0 > 40055148 Y-B---- 54753 pamc 3 416f3e34 0 3 0 0 > 40056ed0 Y-B---- 54753 pamc 3 40edf0b0 0 3 0 0 > 40059630 Y-B---- 54753 pamc 3 4104c478 0 3 0 0 > 4005c768 Y-B---- 54753 pamc 3 418e6664 0 3 0 0 > 4005d62c Y-B---- 54753 pamc 3 804e1600 0 3 0 0 > 4006fd7c Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0 > 40074c3c Y-B---- 54753 pamc 3 40f26188 0 3 0 0 > 41410774 Y-B---- 54753 pamc 3 418e5f14 0 3 0 0 > 414138ac Y-B---- 54753 pamc 3 41769910 0 3 0 0 > 41417d94 Y-B---- 54753 pamc 3 409cf7d0 0 3 2 0 > 41418c58 Y-B---- 54753 pamc 3 902fb22c 0 3 0 0 > 4141a008 Y-B---- 54753 pamc 3 907aff10 0 3 0 0 > 4141aecc Y-B---- 54753 pamc 3 40d8dcc0 0 3 4 0 > 41426ec0 Y-B---- 54753 pamc 3 9085be80 0 3 0 0 > 4142cc44 --B-R-- 54753 pamc 3 0 0 3 0 0 > 4142d130 Y-B---- 54753 pamc 3 80035a64 0 3 0 0 > 4142e9cc Y-B---- 54753 pamc 3 40549438 0 3 0 0 > 41430754 Y-B---- 54753 pamc 3 416f33a0 0 3 0 0 > 41433d78 Y-B---- 54753 pamc 3 80ef9f74 0 3 0 0 > 41435128 Y-B---- 54753 pamc 3 40d8d3f0 0 3 4 0 > 80211634 Y-B---- 54753 pamc 3 40473568 0 3 0 0 > 80215144 Y-B---- 54753 pamc 3 907af984 0 3 0 0 > > 80217d90 --BP--- 54753 pamc 3 0 0 3 107 3 > 80218c54 Y-B---- 54753 pamc 3 40496378 0 3 0 0 > 8021bd8c Y-B---- 54753 pamc 3 403d3600 0 3 0 0 > 8021e9d8 Y-B---- 54753 pamc 3 40cd39fc 0 3 0 0 > 80220274 Y-B---- 54753 pamc 3 409cf7d0 0 3 6 0 > 80221ffc Y-B---- 54753 pamc 3 804d10b8 0 3 0 0 > 80224c48 Y--P--- 54749 pamc PVINEYAR 90f5c060 0 2 3 0 > 80225620 Y-B---- 54753 pamc 3 40413940 0 3 0 0 > 80230c3c Y-B---- 54753 pamc 3 90aadaec 0 3 0 0 > 9044a774 Y-B---- 54753 pamc 3 4146780c 0 3 0 0 > 9044b14c Y-B---- 54753 pamc 3 800354d8 0 3 0 0 > 9044c010 Y-B---- 54753 pamc 3 804d1988 0 3 0 0 > 9044e284 Y-B---- 54753 pamc 3 804d1988 0 3 7 0 > 9044e770 Y-B---- 54753 pamc 3 404134d8 0 3 0 0 > 90457b18 Y-B---- 54753 pamc 3 80377ccc 0 3 0 0 > 9045ac50 Y-B---- 54753 pamc 3 403d3e34 0 3 0 0 > 9045c9d8 Y-B---- 54753 pamc 3 80ceb310 0 3 0 0 > 9045d89c Y-B---- 54753 pamc 3 404c1988 0 3 0 0 > 90463134 Y-B---- 54753 pamc 3 40413940 0 3 0 0 > 90463620 Y-B---- 54753 pamc 3 804d10b8 0 3 0 0 > 90467130 Y-B---- 54753 pamc 3 40d8d3f0 0 3 1 0 > 90467b08 Y-B---- 54753 pamc 3 41165194 0 3 0 0 The First entry in onstat -u is the shared memory address of the session thread, so I would assume that what you are seeing is a session which has multiple threads ... Hope this helps, Will

↪ replying to InfoJones
Ray Canuel — — source: Informix-list mailing list archive (1991-1998)

Its most likely a PDQ query. Run onstat -g mgm and see the session id under 'Active Queries'. Number 54753 is probably under there. PDQ brakes up a query input parts and runs them in || by creating a thread for each part. A part could be a scan thread per fragment, exchange, filter, group, etc..... Ray InfoJones wrote: > > Can anyone tell me why I'm getting so many redundant/duplicate user > process id's when I run onstat -u? > > Below is an output from the following command: > onstat -u | grep pamc why is sessid 54753 repeated?> > 40050c60 Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0 > 40055148 Y-B---- 54753 pamc 3 416f3e34 0 3 0 0 > 40056ed0 Y-B---- 54753 pamc 3 40edf0b0 0 3 0 0 > 40059630 Y-B---- 54753 pamc 3 4104c478 0 3 0 0 > 4005c768 Y-B---- 54753 pamc 3 418e6664 0 3 0 0 > 4005d62c Y-B---- 54753 pamc 3 804e1600 0 3 0 0 > 4006fd7c Y-B---- 54753 pamc 3 9085b5b0 0 3 0 0 > 40074c3c Y-B---- 54753 pamc 3 40f26188 0 3 0 0 > 41410774 Y-B---- 54753 pamc 3 418e5f14 0 3 0 0 > 414138ac Y-B---- 54753 pamc 3 41769910 0 3 0 0 > 41417d94 Y-B---- 54753 pamc 3 409cf7d0 0 3 2 0 > 41418c58 Y-B---- 54753 pamc 3 902fb22c 0 3 0 0 > 4141a008 Y-B---- 54753 pamc 3 907aff10 0 3 0 0 > 4141aecc Y-B---- 54753 pamc 3 40d8dcc0 0 3 4 0 > 41426ec0 Y-B---- 54753 pamc 3 9085be80 0 3 0 0 > 4142cc44 --B-R-- 54753 pamc 3 0 0 3 0 0 > 4142d130 Y-B---- 54753 pamc 3 80035a64 0 3 0 0 > 4142e9cc Y-B---- 54753 pamc 3 40549438 0 3 0 0 > 41430754 Y-B---- 54753 pamc 3 416f33a0 0 3 0 0 > 41433d78 Y-B---- 54753 pamc 3 80ef9f74 0 3 0 0 > 41435128 Y-B---- 54753 pamc 3 40d8d3f0 0 3 4 0 > 80211634 Y-B---- 54753 pamc 3 40473568 0 3 0 0 > 80215144 Y-B---- 54753 pamc 3 907af984 0 3 0 0 > > 80217d90 --BP--- 54753 pamc 3 0 0 3 107 3 > 80218c54 Y-B---- 54753 pamc 3 40496378 0 3 0 0 > 8021bd8c Y-B---- 54753 pamc 3 403d3600 0 3 0 0 > 8021e9d8 Y-B---- 54753 pamc 3 40cd39fc 0 3 0 0 > 80220274 Y-B---- 54753 pamc 3 409cf7d0 0 3 6 0 > 80221ffc Y-B---- 54753 pamc 3 804d10b8 0 3 0 0 > 80224c48 Y--P--- 54749 pamc PVINEYAR 90f5c060 0 2 3 0 > 80225620 Y-B---- 54753 pamc 3 40413940 0 3 0 0 > 80230c3c Y-B---- 54753 pamc 3 90aadaec 0 3 0 0 > 9044a774 Y-B---- 54753 pamc 3 4146780c 0 3 0 0 > 9044b14c Y-B---- 54753 pamc 3 800354d8 0 3 0 0 > 9044c010 Y-B---- 54753 pamc 3 804d1988 0 3 0 0 > 9044e284 Y-B---- 54753 pamc 3 804d1988 0 3 7 0 > 9044e770 Y-B---- 54753 pamc 3 404134d8 0 3 0 0 > 90457b18 Y-B---- 54753 pamc 3 80377ccc 0 3 0 0 > 9045ac50 Y-B---- 54753 pamc 3 403d3e34 0 3 0 0 > 9045c9d8 Y-B---- 54753 pamc 3 80ceb310 0 3 0 0 > 9045d89c Y-B---- 54753 pamc 3 404c1988 0 3 0 0 > 90463134 Y-B---- 54753 pamc 3 40413940 0 3 0 0 > 90463620 Y-B---- 54753 pamc 3 804d10b8 0 3 0 0 > 90467130 Y-B---- 54753 pamc 3 40d8d3f0 0 3 1 0 > 90467b08 Y-B---- 54753 pamc 3 41165194 0 3 0 0

Related threads

Glossary