Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Find out remaining rollback rows

3 posts in General Discussion Last posting was on 2010-08-04 18:26:36.0Z
Simon Posted on 2010-08-04 16:11:15.0Z
Subject: Find out remaining rollback rows
From: Simon <sst.misc@gmail.com>
Newsgroups: sybase.public.ase.general
X-Newsreader: MesNews/1.08.03.00
MIME-Version: 1.0
Reply-To: sst.misc@gmail.com
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c599123$1@forums-1-dub>
Date: 4 Aug 2010 09:11:15 -0700
X-Trace: forums-1-dub 1280938275 10.22.241.152 (4 Aug 2010 09:11:15 -0700)
X-Original-Trace: 4 Aug 2010 09:11:15 -0700, vip152.sybase.com
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29444
Article PK: 78676

ASE 12.5.x and ASE 15.x

Good afternoon,

During a rollback, are there any way to estimate the remaining rows to
rollback in order to forecast Rollback duration?

Thanks for your hints.


Simon

--
-- Simon --


Bret Halford Posted on 2010-08-04 18:21:50.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.11) Gecko/20100711 Thunderbird/3.0.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Find out remaining rollback rows
References: <4c599123$1@forums-1-dub>
In-Reply-To: <4c599123$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c59afbe$1@forums-1-dub>
Date: 4 Aug 2010 11:21:50 -0700
X-Trace: forums-1-dub 1280946110 10.22.241.152 (4 Aug 2010 11:21:50 -0700)
X-Original-Trace: 4 Aug 2010 11:21:50 -0700, vip152.sybase.com
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29447
Article PK: 78678


On 8/4/2010 10:11 AM, Simon wrote:
> ASE 12.5.x and ASE 15.x
>
> Good afternoon,
>
> During a rollback, are there any way to estimate the remaining rows to
> rollback in order to forecast Rollback duration?
>
> Thanks for your hints.
>
>
> Simon

See the command "kill with statusonly"

kill 13 with statusonly

spid: 13 Transaction rollback in progress. Estimated rollback completion:17%
Estimated time left: 13 seconds

-bret


Sherlock, Kevin [TeamSybase] Posted on 2010-08-04 18:26:36.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4c599123$1@forums-1-dub>
Subject: Re: Find out remaining rollback rows
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c59b0dc$1@forums-1-dub>
Date: 4 Aug 2010 11:26:36 -0700
X-Trace: forums-1-dub 1280946396 10.22.241.152 (4 Aug 2010 11:26:36 -0700)
X-Original-Trace: 4 Aug 2010 11:26:36 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29449
Article PK: 78680

look into "kill with statusonly"

http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1512.htm?

"Simon" <sst.misc@gmail.com> wrote in message
news:4c599123$1@forums-1-dub...
> ASE 12.5.x and ASE 15.x
>
> Good afternoon,
>
> During a rollback, are there any way to estimate the remaining rows to
> rollback in order to forecast Rollback duration?
>
> Thanks for your hints.
>
>
> Simon
>
> --
> -- Simon --
>
>