logging all kdb server user queries - Kdb+ / qStudio

Home Forums Kdb+ / qStudio logging all kdb server user queries

This topic contains 1 reply, has 2 voices, and was last updated by  Ryan Hamilton 6 years, 5 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #142

    Dave

    Is there an option in kdb to monitor all user queries?
    How can this be controlled?

    #151

    Kdb processes can be monitored using the scripts at:
    http://code.kx.com/wiki/Contrib/UsingDotz

    Monitoring works by overriding the default IPC event handlers (http://www.timestored.com/kdb-guides/interprocess-communication#messageHandlers) so that for all types of client call the username, time, query itself can all be logged.

    The console even has an event handler for instructions entered there, that can be overridden e.g.


    q).z.pi:{ show raze "user entered ",string[x]," at ",string .z.t; value x}
    q)2+2
    "user entered 2+2\n at 22:14:22.356"

    The defaults on UsingDotz are probably excessive for what you need and introduce unnecessary overhead per call, I would customize it to your requirements.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.