DB2 11.5 on Windows
We have an app that creates and runs a query based on a number of conditions. This app is legacy and no one know much about it. The beginning of the query is the same.
MERGE INTO schema1.table1 dgmsnc USING
After that it gets complicated. I have searched the plan cache and diag log but can't find it. Is there any way to capture a given query without capturing all queries? This is a busy system and if I try to log every query it will bring the system to it's knees.
That's a tough one. I don't know of any way to log just one query without modifying the SQL that's running it.
What are you trying to learn?