Unanswered: Need to cron a Script that resumes connection to Server.database
I need to write a script that resumes the replication connection to a database if the connection is broken. I usually have to manually resume it through a GUI called Sybase Central, but when i'm not here the connection remains down and the replication queue builds up. So I want to run a script every hour or so to check if any connection is down and automatically bring it up. It will have to be a Unix script though.
If you can help me with this please let me know.
Really appreciate it.
This is bad design. You should not have resume connection in the crontab. There is no point, if a connection has gone down no matter how many times you resume it won't come up unless handled by an error class.
A better design is to create an error_class for that condition and let Rep Server handle it.