Adaptive Server version 12.5.2 adds the statusonly parameter to the kill command. kill ...statusonly 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. The syntax is:
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 spid: 13 Transaction rollback in progress. Estimated rollback completion: 29% Estimated time left: 9 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 40% Estimated time left: 8 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 47% Estimated time left: 7 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 55% Estimated time left: 6 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 65% Estimated time left: 5 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 73% Estimated time left: 4 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 76% Estimated time left: 3 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 83% Estimated time left: 2 seconds spid: 13 Transaction rollback in progress. Estimated rollback completion: 94% Estimated time left: 0 seconds
If the rollback of the spid has completed when you issue kill...statusonly or if Adaptive Server is not rolling back the specified spid, kill...statusonly returns the following message:
Status report cannot be obtained. KILL spid:nn is not in progress.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
