Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've recently become responsible for administering an application which is essentially a front end to a Sybase SQL Anywhere 9 database, including the database itself. I'd like to use unload table to efficiently export the data for backup and, in the case of a few tables, ETL to get it into a reporting database / small scale data warehouse.

The problem is that the client application crashes and leaves dead connections and shared locks on a pretty regular basis, which seems to prevent unload table from getting the (brief) exclusive locks it needs. Currently I use Sybase Central to verify that these connections are in fact zombies and drop them myself at the end of the day / week.

Is there a command or script to drop all connections? Being able to drop everything at once after verifying that they're unneeded would be quite helpful but I haven't found a way to do it.

share|improve this question
    
Gleening through the manual download.sybase.com/pdfdocs/awg0800e/dbdaen8.pdf you might want to dbstop command. I think that will disconnect all users witht he -y option. You might also want to make sure your database and log file are synced. I got the impression that dbstop will do that, but I've never done anything like this before. I was just using my google fu –  Nixphoe Aug 6 '11 at 18:19
    
I just looked at the age of that document, it's from 2001. There might be a more updated version out there. –  Nixphoe Aug 6 '11 at 18:21
    
Thanks - looks like that may be exactly what I'm looking for. –  nxzr Aug 7 '11 at 18:40
    
Glad to have helped then! –  Nixphoe Aug 7 '11 at 21:12

1 Answer 1

Gleening through the manual you might want to dbstop command. I think that will disconnect all users witht he -y option. You might also want to make sure your database and log file are synced. I got the impression that dbstop will do that, but I've never done anything like this before.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.