Using kill with statusonly

The kill ...statusonly command reports on the progress of a server process ID (spid) in rollback status. It does not terminate the spid. The statusonly report displays the percent of rollback completed and the estimated length of time in seconds before the rollback completes. To track the progress of a rollback, you must run kill...with statusonly multiple times:

kill spid with statusonly

Where spid is the number of the process you are terminating.

For example, the following reports on the process of the rollback of spid number 13:

kill 13 with statusonly

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

If the rollback of the spid has completed when you issue kill...statusonly or if Adaptive Server cannot roll back the specified spid, kill...statusonly returns the following message:

Status report cannot be obtained. KILL spid:nn is not in progress....