Sybase db crashing - how to monitor

[suzreid]

We have a SQL Anywhere 5.5 database that seems to crash for no reason intermittently. Is there any way that I can log what happens on the database so try and determine what happens just before the crash.

We have a couple of restrictions
1. The database is a critical 24x7 application and downtime must be kept to a minimum
2. There isn;t a lot of space on the server so the space for the log file is restricted.

Any help would be greatly appreciated as I haven't a lot of experience with sybase

Thanks
Susan

 

[abdaler]

Hi Susan,

Do you tray reading the log file located usually under "install" folder and named "dataservername".log

Regards.

Abdaler

 

[snow00]

Hi
I have some quiestion about BCP command in linux .When I used this command by command line it work but used by write to file.sql it can't work . please tell me .
I 'm use sybase linux 11.9.2

Regrad