The sp_helprep and sp_helpsub commands return an incorrect subscription status (up) when the following situation occurs:
The ASE Replicator process shuts down abnormally (for example, a power failure on the host machine, or a process kill command), while a subscription is up (resumed), and
The remote server associated with that subscription is down when ASE Replicator is restarted after the abnormal shutdown.
When ASE Replicator is restarted, the subscription status is actually down (status 0 should be returned), but sp_helprep and sp_helpsub return the subscription status as 1 (up).
This is an error only in the status information that is returned. After the remote server is successfully restarted, you can resume the subscription normally using sp_resumesub.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
