4

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.

Bart De Vos
  • 17,761
  • 6
  • 62
  • 81
nxzr
  • 141
  • 3
  • Gleening through the manual http://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 06 '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 06 '11 at 18:21
  • Thanks - looks like that may be exactly what I'm looking for. – nxzr Aug 07 '11 at 18:40
  • Glad to have helped then! – Nixphoe Aug 07 '11 at 21:12

1 Answers1

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.

Nixphoe
  • 4,524
  • 7
  • 32
  • 51