onstat -g nif

Folks, What might be the possibilities that will generate "RUN,BLOCK " in the State column of the output? We have significant ER data replication slowness issue... Thanks, Frank onstat -g nif IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 09:53:53 --8359540 Kbytes NIF anchor Block: 0x1428997e8 nifGState RUN RetryTimeout 300 CDR connections: Id Name State Version Sent Received --------------------------------------------------------------------------- 21 g_nsofops RUN 10 6193229 7188999 22 g_ncdcops RUN,BLOCK 10 15516482 8848536 --001a11c2bc122e878404e7530309

Usually that would mean that you have a very large transaction that the= target is trying to apply, and because it is a large transaction it's blocked the network from sending anything until that one transaction is= applied. Sent from my iPad > On Sep 26, 2013, at 8:01 PM, "FRANK" <yunyaoqu@gmail.com> wrote: > > Folks, > > What might be the possibilities that will generate "RUN,BLOCK " in > the State column of the output? > > We have significant ER data replication slowness issue... > > Thanks, > Frank > > onstat -g nif> > IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 09:53:=53 -- > 8359540 Kbytes > > NIF anchor Block: 0x1428997e8 > > nifGState RUN > > RetryTimeout 300 > > CDR connections: > Id Name State Version Sent Received > -----------------------------------------------------------------------= ---- > 21 g_nsofops RUN 10 6193229 7188999 > 22 g_ncdcops RUN,BLOCK 10 15516482 8848536 > > --001a11c2bc122e878404e7530309 > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

Thanks Madison! Our transaction is not very big. Is Heavy network traffic( or slow, unreliable,congested ....) able to create this type of issue? Frank On Thu, Sep 26, 2013 at 9:10 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > Usually that would mean that you have a very large transaction that the= > > target is trying to apply, and because it is a large transaction it's > blocked the network from sending anything until that one transaction is= > > applied. > > Sent from my iPad > > > On Sep 26, 2013, at 8:01 PM, "FRANK" <yunyaoqu@gmail.com> wrote: > > > > Folks, > > > > What might be the possibilities that will generate "RUN,BLOCK " in > > the State column of the output? > > > > We have significant ER data replication slowness issue... > > > > Thanks, > > Frank > > > > onstat -g nif> > > > IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 09:53:=> 53 > -- > > 8359540 Kbytes > > > > NIF anchor Block: 0x1428997e8 > > > > nifGState RUN > > > > RetryTimeout 300 > > > > CDR connections: > > Id Name State Version Sent Received > > > -----------------------------------------------------------------------= > ---- > > 21 g_nsofops RUN 10 6193229 7188999 > > 22 g_ncdcops RUN,BLOCK 10 15516482 8848536 > > > > --001a11c2bc122e878404e7530309 > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > >= > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd6aeba892d8f04e755b423