how to force aborting long transaction
Mars Chen (IDS 11.50.UC6) wanted to abort the rollback of a long transaction so he could drop the table. Art Kagel said it cannot be done and suggested altering the table to RAW and using TRUNCATE TABLE with REUSE STORAGE, then back to STANDARD. Shan Sean said IBM support has internal tools. Mars asked about a tbzero-like tool; no public one was named.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Dear All... I wonder if there is a way to force aborting long transaction rollback? My IDS is 11.50.uc6 in RedHat 5.4 !! This morning I forgot to set DB to no log , so I tried to interupt the long transaction , I've to wait long enough for long transaction rollbacking, I really like to abort rollbacking long transaction , drop table , and then do the transaction all over again(in no log DB) !! Waiting millions of rows rollback is long , What can I tell IDS to stop it, I just don't care that table's data , just let me drop that table is good enough ... any suggestion is welcome ! Thanks !!
Can't do it. FYI, try ALTERING the table to RAW and use TRUNCATE TABLE with REUSE STORAGE instead of DROP TABLE ... CREATE TABLE to prepare for the processing in your processing scripts then back to STANDARD at the end of processing. This doesn't require any manual intervention, so you can't forget, and the TRUNCATE will leave the previously allocated extents in place which will speed the inserts into the table. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Thu, Jul 15, 2010 at 2:44 AM, MARS CHEN <mars@jsun.com> wrote: > Dear All... > > I wonder if there is a way to force aborting long transaction rollback? > My IDS is 11.50.uc6 in RedHat 5.4 !! > > This morning I forgot to set DB to no log , so I tried to interupt the > long transaction , I've to wait long enough for long transaction > rollbacking, > I really like to abort rollbacking long transaction , drop table , > and then do the transaction all over again(in no log DB) !! > > Waiting millions of rows rollback is long , What can I tell IDS to stop it, > I just don't care that table's data , just let me drop that table is good > enough ... any suggestion is welcome ! > > Thanks !! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485e7704cf95632048b6b2c4c
ibm support can force that user their tools which is internal.
As I rememebered , there used to be a tbzero or else can make a checkpoint flag , is there a tool like that in iiug ? or it is for ibm internal only ~~