topic Re: Catch All Queries Executed on DB Programmatically in Application Development and Automation Discussions

Catch All Queries Executed on DB Programmatically

Former Member — Fri, 19 Aug 2016 13:46:03 GMT

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

Re: Catch All Queries Executed on DB Programmatically

Sandra_Rossi — Sat, 20 Aug 2016 21:00:30 GMT

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)

Re: Catch All Queries Executed on DB Programmatically

Former Member — Sun, 21 Aug 2016 06:46:53 GMT

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

Re: Catch All Queries Executed on DB Programmatically

Sandra_Rossi — Sun, 21 Aug 2016 06:53:35 GMT

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?

Re: Catch All Queries Executed on DB Programmatically

Former Member — Sun, 21 Aug 2016 07:04:08 GMT

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

Re: Catch All Queries Executed on DB Programmatically

Sandra_Rossi — Sun, 21 Aug 2016 08:58:01 GMT

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"