onmode -I question
Chuan Lu wanted onmode -I 154 to capture AF files without the engine blocking on shared memory dumps. Alexandre Marini advised onmode -wm DUMPSHMEM=0 and noted error 154 is a lock timeout, while deadlocks are -143. Chuan tested a deadlock scenario with both settings and found no files in tmp. Alexandre asked about logging mode. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I execute "onmode -I 154" to capture the deadlock information. I find:
1) ids generate af file when SHMEMDUMP=2, during the dumping, ids is being
blocked. so customer refused to use 'onmode -I"
2) If I set SHMEMDUMP=0, ids can't generate the af file.
My question is how to generate the af file when I use 'onmode -I" , and ids
isn't being blocked.
Hi.
If you are using 11.50+ version (you didn´t specify your version!!!!),
you might change the correct parameter to:
onmode -wm DUMPSHMEM=0
Then you might turn on the trace (be careful, sqlcode 154 means ISAM error:
Lock Timeout Expired).
It has nothing to do with deadlocks ok?
If you are trying to catch dadlock, you should search for error:
-143 ISAM error: deadlock detected.
(Trace generates AF files, no matter how is your DUMPSHMEM value).
Best regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator
> To: ids@iiug.org
> From: luchuan@cn.ibm.com
> Subject: onmode -I question [26543]
> Date: Mon, 19 Mar 2012 23:38:36 -0400
>
> I execute "onmode -I 154" to capture the deadlock information. I find:
> 1) ids generate af file when SHMEMDUMP=2, during the dumping, ids is being
> blocked. so customer refused to use 'onmode -I"
> 2) If I set SHMEMDUMP=0, ids can't generate the af file.
>
> My question is how to generate the af file when I use 'onmode -I" , and ids
> isn't being blocked.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi,
I do it according your suggestion.
below are the steps.
1) create table tb1(c1 int) lock mode row;
insert into tb1 values (10);
insert into tb1 values (20);2) onmode -wm DUMPSHMEM=0 (the value of onconfig is 2)
onmode -I 154
onmode -I 143
3) Session 1:
begin work;
set lock mode to wait 40;
update tb1 set c1=1 where c1=10;
update tb1 set c1=2 where c1=20;4) Session 2:
begin work;
set lock mode to wait;
update tb1 set c1=2 where c1=20;
update tb1 set c1=1 where c1=10;
I see nothing in the $INFORMIXDIR/tmp.
Ok just a guess:
What is your database logging mode??? (ansi mode ????)
What happened to your sessions? They completed without any errors???
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator
> To: ids@iiug.org
> From: luchuan@cn.ibm.com
> Subject: Re: RE: onmode -I question [26558]
> Date: Tue, 20 Mar 2012 23:56:55 -0400
>
> Hi,
>
> I do it according your suggestion.
>
> below are the steps.
> 1) create table tb1(c1 int) lock mode row;
>
> insert into tb1 values (10);>
> insert into tb1 values (20);> 2) onmode -wm DUMPSHMEM=0 (the value of onconfig is 2)
>
> onmode -I 154>
> onmode -I 143
> 3) Session 1:>
> begin work;
>
> set lock mode to wait 40;>
> update tb1 set c1=1 where c1=10;>
> update tb1 set c1=2 where c1=20;> 4) Session 2:
>
> begin work;
>
> set lock mode to wait;>
> update tb1 set c1=2 where c1=20;>
> update tb1 set c1=1 where c1=10;>
> I see nothing in the $INFORMIXDIR/tmp.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>