onmode -I 154,-1 143 -1

HI, I want to capture the lock information, and I found IDS being blocked for a short time when dumping the AF file. Could IDS doesn't being blocked when dump the AF file ? blocking means transaction is hang. below are more information , thanks for your time. $ onmode -I 154,-1 143 -1 $ onstat -g ras IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line (Prim) -- Up 00:22:32 -- 44071680 Kbytes Diagnostics Current Settings AFCRASH 0x00002481 AFFAIL 0x00000401 AFWARN 0x00000401 AFDEBUG 0 AFLINES 0 BLOCKTIMEOUT 3600Block Status Unblocked CCFLAGS 0x00000000 CCFLAGS2 0x00000200 DUMPCORE 0 DUMPGCORE 0 DUMPSHMEM 0 DUMPCNT 1 DUMPDIR /informix12/tmprhead_t 0x070000001198f000 shmcb_t 0x0700000011921cf8 mtcb_t 0x07000000abba4028 pool list 0x0700000011921dd0 block pool list 0x07000000119889d8 SYSALARMPROGRAM /informix12/etc/evidence.sh LTXHWM 70% LTXEHWM 80% DYNAMIC_LOGS 0 Traperror info: Errno Session(s) 154 All 143 All 1 All

No. In order to dump shared memory that memory has to be quiescent, unchanging. So the engine blocks all processing during the dump. 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 Mon, Mar 28, 2016 at 10:50 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > HI, > > I want to capture the lock information, and I found IDS being blocked for a > short time when dumping the AF file. > > Could IDS doesn't being blocked when dump the AF file ? blocking means > transaction is hang. > > below are more information , thanks for your time. > > $ onmode -I 154,-1 143 -1 > $ onstat -g ras> > IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line (Prim) -- Up > 00:22:32 > -- 44071680 Kbytes> > Diagnostics Current Settings > > AFCRASH 0x00002481 > AFFAIL 0x00000401 > AFWARN 0x00000401 > AFDEBUG 0 > AFLINES 0 > > BLOCKTIMEOUT 3600> Block Status Unblocked > > CCFLAGS 0x00000000 > CCFLAGS2 0x00000200 > > DUMPCORE 0 > DUMPGCORE 0 > DUMPSHMEM 0 > DUMPCNT 1 > > DUMPDIR /informix12/tmp> rhead_t 0x070000001198f000 > shmcb_t 0x0700000011921cf8 > mtcb_t 0x07000000abba4028 > pool list 0x0700000011921dd0 > block pool list 0x07000000119889d8 > SYSALARMPROGRAM /informix12/etc/evidence.sh > > LTXHWM 70% > LTXEHWM 80% > DYNAMIC_LOGS 0> > Traperror info: > Errno Session(s) > 154 All > 143 All > 1 All > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013a1102e065ff052f1d1e32