IDS Forum

Re: Application hanged no error on logs

Posted By: Keith Simmons
Date: Tuesday, 19 January 2010, at 3:25 a.m.

In Response To: Application hanged no error on logs (JACK PAPA)

2010/1/19 JACK PAPA <informix2009@gmail.com>:
> Hi All,
>
> I encountered problem today. the application can't continue processing...
> Please see below "onstat -u" output... I've noticed there are lot of users in
> "waiting for a condition" mode. My question is, when can i kill a process? I
> remember, i kill process only when the table is locked...
>
> 502090d8 ---P--F 0 informix - 0 0 0 0 24341
> 502096f0 ---P--- 10 informix - 0 0 0 0 0
> 50209d08 ---P--B 11 informix - 0 0 0 199488 1576
> 5020af50 ---P--D 14 informix - 0 0 0 0 0
> 5020b568 Y--P--D 19 informix - 3008812c 0 0 0 0
> 5020c7b0 Y--P--- 22 patrol - 50bac018 0 0 0 0
> 5020cdc8 Y--P--- 43418 dxasd2075 - 541bdaa8 0 1 98 251
> 5020d3e0 Y--P--- 39793 aasdt04 20 51bd2670 0 1 32 0
> 5020e628 Y--P--- 43554 tpasdd02 13 541bd498 0 1 452 102
> 5020ec40 Y--P--- 41551 rola0asd00 15 51862f58 0 1 190 525
> 502104a0 Y--P--- 34622 amaadsdrt04 14 50dc0158 0 0 72 253
> 502110d0 Y--P--- 43540 dx2asd075 - 50bc1380 0 1 57 169
> 50213560 Y--P--- 42887 apadoon00 81 50b01878 0 1 17 4
> 50213b78 Y--P--- 1711 holadbr05 3 5168f588 0 0 24 27
> 50214dc0 Y--P--- 40879 tperrasd02 13 552c2bb8 0 0 36 232
> 502159f0 Y--P--- 43724 admrodr03 8 517d5068 0 0 5 9
> 50216008 Y--P--- 42886 apoon00 81 54a7fef0 0 0 1 1
> 50216620 Y--P--- 43753 mradodr03 8 542cb578 0 1 0 12
> 50216c38 Y--P--- 38550 holbr01 11 54a7f9e0 0 1 128 350
> 50217250 Y--P--- 9358 holbr01 11 517d5158 0 0 15 14
> 50217868 Y--P--- 32173 kldsars02 28 1442d00 0 0 11 25
> 50218498 Y--P--- 43422 dx2sd075 - 546d6220 0 1 167 345
> 50218ab0 Y--P--- 32512 kldsars02 28 51477870 0 1 0 0
> 502190c8 Y--P--- 39523 holbr05 3 5182f018 0 1 19 54
> 50219cf8 Y--P--- 36794 jfraadn08 1 54d53940 0 0 13 7
> 5021a310 Y--P--- 42800 rordo00 21 52b5b390 0 1 90 219
> 5021bb70 Y--P--- 43539 dx20ds75 - 52b5b1b0 0 1 89 234
> 5021d9e8 Y--P--- 39035 rorddso00 21 547c4af8 0 0 1 0
> 5021e000 Y--P--- 36796 jfrdsan08 1 51477b28 0 1 5 27
> 5021e618 Y--P--- 43847 amart04 14 50dd2518 0 1 17 24
> 5021f248 Y--P--- 39010 roladsads000 15 517d5518 0 0 2 0
> 50221cf0 Y--P--- 43863 whssddepr01 - 517d5428 0 1 266 295
> 50223b68 Y--P--- 43536 dx2ads075 - 545bc6e0 0 1 93 228
> 50224798 Y--P--- 43537 dax2ada075 - 53163858 0 1 94 125
> 50226c28 Y--P--- 43538 dx2asd075 - 517d51a8 0 1 44 231
>
> What i also noticed on logs are:
> 19:07:27 Maximum server connections 76
> 19:22:27 Checkpoint Completed: duration was 0 seconds.
> 19:22:27 Checkpoint loguniq 195401, logpos 0x383f018, timestamp: 0xd6cadbc4
>
> 19:22:27 Maximum server connections 76
> 19:31:10 Checkpoint Completed: duration was 0 seconds.
> 19:31:10 Checkpoint loguniq 195401, logpos 0x431c018, timestamp: 0xd6cf1ed9
>
> 19:31:10 Maximum server connections 76
> 19:46:27 Checkpoint Completed: duration was 0 seconds.
> 19:46:27 Checkpoint loguniq 195401, logpos 0x4b29018, timestamp: 0xd6d1f98e
>
> Did i run out of connection??
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Jack

Far, far too little information !!
Operating system, IDS Version, application platform and software.
onstat -p, onconfig, extract of the log when the issue first occured.
Better description other than can't continue processing. Is this for
every connected process, just updates, just certain areas of the app?
Can you still use dbaccess during these periods?

Keith

Messages In This Thread

• Application hanged no error on logs
  JACK PAPA -- Monday, 18 January 2010, at 9:51 p.m.
  • Re: Application hanged no error on logs
    Keith Simmons -- Tuesday, 19 January 2010, at 3:25 a.m.
  • Re: Application hanged no error on logs
    Art Kagel -- Tuesday, 19 January 2010, at 6:31 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.