Make Slow rollback job faster ?

Folks, IDS 12.10 FC4. An external application initiated a LARGE job which caused a long transaction to rollback.... The rollback has been running for more than half day ..... and still running ( blocking other)..... Any more options to make the rollback job faster ( not sure how long need wait )? Thanks Frank --001a11c12b52c57f01052ae22c85

The rollback will take at least as long as the original transaction took to get to the point where it failed. Often it can take as much as 3X as long if the original was multithreaded and you don't have enough online recovery threads configured in your ONCONFIG file. I don't know whether increasing this parameter dynamically will improve a rollback that is already in progress. Bouncing the engine will trigger an offline rollback, which may be faster. However, before the rollback can begin after the bounce, the interrupted rollback has to be rolled forward again, so trying that is non-trivial and may make things take even longer if the current rollback is close to finishing. 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 Wed, Feb 3, 2016 at 1:56 PM, FRANK <yunyaoqu@gmail.com> wrote: > Folks, > > IDS 12.10 FC4. > > An external application initiated a LARGE job which caused a long > transaction to rollback.... > > The rollback has been running for more than half day ..... and still > running ( blocking other)..... > > Any more options to make the rollback job faster ( not sure how long > need wait )? > > Thanks > Frank > > --001a11c12b52c57f01052ae22c85 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113ff3182ad218052ae255d5

If you have not looked at onstat -x, it provides an estimated= rollback time. Also you might want to consider increasing the dis= tance between LTXHWM and LTXEHWM. Increasing this distance between then = means you will start rollbacks earlier and allows other to do work while= the rollback is occurring. Might help. Look at the third = column from the end "rb=5Ftime". Since the server know how far you= must rollback and your average rate, we now provide an estimate of how = long it will take. The more it processes the better the estimate. = onstat -x IBM Informix Dynamic Server Version 12.10.UC6 -- On-Li= ne -- Up 12 days 12:50:41 -- 276736 Kbytes Transactions &nb= sp; = &nb= sp; = &nb= sp; = es= t. address flags userthread locks begin= =5Flogpos current logpos is= ol rb=5Ftime retrys coord 462c4018 A---- 4629101= 8 0 - &nbs= p; - = ; &n= bsp; COMMIT - 0= 462c42a0 A---- 46291668 0&nb= sp; - &nbs= p; - = ; C= OMMIT - 0 = 462c4528 A---- 46291cb8 0 &nb= sp; - &nbs= p; - = ; COMMIT - = ; 0 4= 62c47b0 A---- 46292308 0 - &= nbsp; &nbs= p; - = ; COMMIT - = ; 0 John F. Mil= ler III STSM, Lead Architect [1]miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Ser= ver (IDS) [2]-----ids-bounces@iiug.org wrote: = ----- >To: [3]ids@iiug.org >From: "Art Kagel" >Sent by: [4]ids-bounces@iiug.org= >Date: 02/03/2016 11:08AM >Subject: Re: Make Slow rollback job= faster ? [36491] > >The rollback will take at least as long a= s the original transaction >took to >get to the point where it= failed. Often it can take as much as 3X as >long >if the orig= inal was multithreaded and you don't have enough online >recovery >threads configured in your ONCONFIG file. I don't know whether >= increasing >this parameter dynamically will improve a rollback that = is already in > >progress. Bouncing the engine will trigger an = offline rollback, which >may >be faster. However, before the r= ollback can begin after the bounce, >the >interrupted rollback= has to be rolled forward again, so trying that >is >non-trivi= al and may make things take even longer if the current >rollback is <= br>>close to finishing. > >Art > >Art S. Kagel= , President and Principal Consultant >ASK Database Management &g= t;[5]www.askdbmgt.com<= /a> > >Blog: [6]http://informix-myview.blogspot.com/ > &g= t;Disclaimer: Please keep in mind that my own opinions are my own >op= inions >and do not reflect on the IIUG, nor any other organization w= ith which >I am >associated either explicitly, implicitly, or = by inference. Neither do > >those opinions reflect those of oth= er individuals affiliated with any > >entity with which I am af= filiated nor those of the entities >themselves. > >On We= d, Feb 3, 2016 at 1:56 PM, FRANK <[7]yunyaoqu@gmail.com> wrote: > >> = Folks, >> >> IDS 12.10 FC4. >> >> A= n external application initiated a LARGE job which caused a long >&g= t; transaction to rollback.... >> >> The rollback has b= een running for more than half day ..... and >still >> runn= ing ( blocking other)..... >> >> Any more options to ma= ke the rollback job faster ( not sure how >long >> need wai= t )? >> >> Thanks >> Frank >> &= gt;> --001a11c12b52c57f01052ae22c85 >> >> >&g= t; >> >***************************************************= ****************** >********** >> Forum Note: Use "Reply" t= o post a response in the discussion forum. > >> >>= > >--001a113ff3182ad218052ae255d5 > > >***= ****************************************************************** >*= ********* > Forum Note: Use "Reply" to post a response in the discu= ssion forum. > > > References 1. 3D"mailto:miller3@us.= 2. =3D"mailto:-----ids-bounces@iiug.org" 3. 3D"mailto:ids@iiug.= 4. 3D"mailto:ids-bounces@iiug.org" 5. 3D"http://www.askdbmgt.com"/ 6. 3D"http://informix-my=/ 7. 3D"mailto:=