Catch All Queries Executed on DB Programmatically

[Former Member]

Hi all,

I have a requirement where I need to catch all queries (SELECT, INSERT, UPDATE, DELETE) being executed against the data base server from SAP server programmatically, anybody can advise on this?

Thanks

[Sandra_Rossi]

You could debug what is done during the SQL trace (transaction code ST05), and reproduce it into your program. There are probably many threads which discuss of that (search function module PERFORMANCE_TRACE_ON, PERFORMANCE_TRACE_GET, etc., there are also classes now to read the traces)

[Former Member]

Thank you for your suggestion but I'm looking for something the runs continuously, not just when a trace is running.

[Sandra_Rossi]

No you can't do that, you would put the server down. Can you imagine how many SQL operations per second there are in the system! I can't imagine you have to trace everything, what is your exact requirement?

[Former Member]

As far as I know ST04 is already doing that so why can't we have something similar?

[Sandra_Rossi]

So, if it's a tool in your database system, you should refer to the database editor's documentation or forum, to see where and how this trace is stored (not at the "ABAP side" anyway). If your ST04 tool displays the data, then same remark as above: "You could debug what is done during the [trace display], and reproduce it into your program"