IDS Forum

Re: Waits in database

Posted By: Art Kagel
Date: Thursday, 12 January 2017, at 2:37 p.m.

In Response To: Waits in database (HUGO PADILLA)

If the resource being waited for is a lock then onstat -k will show who is
holding that lock address:

onstat -k | fgrep 1440e1440

On the other hand if it is an internal latch then it will show in the
onstat -s report:

onstat -s | fgrep 1440e1440

Art

Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Thu, Jan 12, 2017 at 2:02 PM, HUGO PADILLA <hugo_padilla@terra.com.mx>
wrote:

> Greetings
>
> I have a degradation in a IDS 11.50.
>
> With onstat -u I detect a lot of waits in a resource, but I cant identity
> wich
> user causes this
>
> The output is:
> /informix/ids1150 [casiopea2] (informix): onstat -u | egrep 1440
> 2bdde5ba8 B--PX-- 944923 masiste - 1440e1440 0 0 303091 5189
> 2e0149e80 ---P--- 922478 masiste - 1440e1440 0 2 370541 13209
> 2e0152400 B--PX-- 923513 masiste WVMXAMUL 1440e1440 0 4 5531 1065
> 2e0153d08 B--PX-- 932984 masiste XMZ7129- 1440e1440 0 4 98173 964
> 2e0154db8 B--PX-- 918964 masiste MA14613- 1440e1440 0 4 46258 0
> 316c6d380 B--PX-- 1004916 masiste - 1440e1440 0 0 136069 11762
> 316c782b8 B--PX-- 923071 masiste MA00296P 1440e1440 0 3 26950 17661
> 316c91b90 ---P--- 1032894 masiste WVMXAMUL 1440e1440 0 2 161 0
> 316c97758 B--PX-- 1001928 masiste - 1440e1440 0 0 103790 9780
> 34ae94158 B--PX-- 1036188 masiste - 1440e1440 0 3 1134 0
> 34ae9c6d8 B--PX-- 1001968 masiste - 1440e1440 0 0 60741 19712
> 34aea5d08 B--PX-- 1038729 masiste - 1440e1440 0 3 1 0
> 34aeaf338 B--PX-- 1032877 masiste SEG048 1440e1440 0 4 70043 0
> 34aeb35f8 B---X-- 696956 masiste ASISTEVA 1440e1440 0 0 0 0
> 393c62f60 B--PX-- 1037700 masiste MA00757- 1440e1440 0 0 4374 0
> 393c82c58 B--PX-- 1009251 masiste ALEOROZC 1440e1440 0 0 351 0
> 393c915f8 B--PX-- 1034495 masiste WVMXAMUL 1440e1440 0 0 8995 1255
> 3e25ce6a8 B--PX-- 1038767 masiste POLIZARI 1440e1440 0 3 3 0
> 3e25d2110 B--PX-- 1029623 masiste - 1440e1440 0 0 331042 89529
> 4542b2cf0 B--PX-- 1004890 masiste - 1440e1440 0 0 102862 4912
> 49df37640 B--PX-- 916702 masiste - 1440e1440 0 4 769602 9768
> 49df38f48 B--PX-- 1005236 masiste XMBX096 1440e1440 0 0 2184 0
> 49df3b900 B--PX-- 1038225 masiste - 1440e1440 0 0 23 0
> /informix/ids1150 [casiopea2] (informix):
>
> How Can I dentify the user o resource
>
> Thanks a lot
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--94eb2c05cf72f380d50545ead880

Messages In This Thread

• Waits in database
  HUGO PADILLA -- Thursday, 12 January 2017, at 2:01 p.m.
  • Re: Waits in database
    Art Kagel -- Thursday, 12 January 2017, at 2:37 p.m.
    • Re: Waits in database
      HUGO PADILLA -- Thursday, 12 January 2017, at 2:59 p.m.
  • Re: Waits in database
    Andreas Legner -- Tuesday, 17 January 2017, at 5:33 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.