I might have forgotten something, but as i read from the documentation the following command line statement:
dbsrv10.exe -z -o c:\somedir\somefile.txt
should make the engine write the console output to the somefile.txt. But somehow, this is not working for me. Am I missing something? It's also worth mentioning that dbsrv10.exe is started as a service, which also prevents me from looking at the engine console output.
asked 25 Jun '10, 15:24
I can think of a couple things that may help you Sergio:
1) modify the service in Sybase Central to "Interact with desktop"; then you will be able to view the SQLA server window. (The drawback is that a user can shutdown the service from the window that is now open.)
2) Run dbconsole.exe and connect to the database. In addition to lots of good user info, you will see the same SQLA server messages.
3) I have run into the problem under Windows of not being able to write to a log file on the server, I believe it had to do with the fact that the Windows account I used to create the service did not have "access" to the "file system" on the server. (You might have to do a little more digging to see if my memory is correct here.)
answered 25 Jun '10, 15:51