output logging in SQL Anywhere 10

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.

dbsrv10 logging

asked 25 Jun '10, 15:24

Sergio
460●15●18●20
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.)

permanent link

answered 25 Jun '10, 15:51

Bill Aumen
2.1k●35●47●75
accept rate: 16%

Thanks for the tips. I think i found the reason the log file was not being created. Probably has to do with me editing the registry directly instead of using dbsvc to modify the service. :P

(25 Jun '10, 15:56) Sergio

@Sergio: It is likely a permission problem - please report back here to let others know when you have solve your isse. Also, note that Windows Vista and Win7 does not allow a service to interact with the desktop.

(25 Jun '10, 17:39) Mark Culp

The problem was that i was adding the -z -o options in the wrong place. If i use the dbsvc utility, the logfile is generated.

(30 Jun '10, 07:45) Sergio

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

logging ×40
dbsrv10 ×10

question asked: 25 Jun '10, 15:24

question was seen: 2,501 times

last updated: 25 Jun '10, 15:51

SAP SQL Anywhere

output logging in SQL Anywhere 10

Follow this question

Related questions