filesystem full and sybase logfile

[Frank Bonnet]

Hello

We experienced a problem last night , the filesystem where are written
SYBASE logfiles has been filled up by another process in debug mode.

Since this moment we are not able to cleanly shutdown the ASE server
it says it cannot shutdown because another shutdown is in progress ...
( we stop and dump our databases each night )

Thanks for any info on how to backup and shutdown ASE cleanly if possible !

[keith....@ronin-capital.com]

1) isql> shutdown with nowait

## Assuming *nix; for Win* don't know...
2) sh> kill $PID # where PID is the process ID(s) of your dataserver
instances
3) sh> kill -9 $PID .....

While none of these are what I would call a "clean" shutdown, they are
in order of gentlest to roughest. In Rob Verschoor's excellent book
he gives some precautions about what you might do before any of them
to lessen the impact (dbcc cacheremove, etc.)

If you know what process has eaten the space on your file system, and
if it is still running, you can it as well, in hopes
of closing file-handle(s) and perhaps recovering the space. You might
look for core files or other deletable space hogs.

For future reference, you can see why it makes sense to use dedicated
Sybase servers, or at the very least, dedicated filesystems. (Yeah,
I know, 20:20 hindsight is a wonderful gift...).

Good luck,

Keith

[ThanksButNo]

On Jun 4, 9:27 am, keith.wing...@ronin-capital.com wrote:

> For future reference, you can see why it makes sense to use dedicated
> Sybase servers, or at the very least, dedicated filesystems. (Yeah,
> I know, 20:20 hindsight is a wonderful gift...).

That's Ok, it's like a crystal ball for others reading
this who might not have stumbled on to that problem yet!

\:-\