SQL Statement Monitor
Posted on 2006-07-13
We're trying to record all SQL statements issued against our DB2/400. We're running V5R2. Played around with SQL Performance Monitors quite a bit in the Operations Navigator, but we are running an application on the 400 via Client Access that we know is executing queries against the database--yet these queries do NOT show up in any performance monitor. I thought perhaps that because SQL Performance Monitor does not record SQL queries from "pre-existing" jobs (correct?) that logging into a new green screen and starting a new instance of the app would solve our problem. So, we logged and noted the job that newly started app was running under and set a monitor on that job. However, no data showed up despite the fact we know the app ran severeal queries. We can't see any of the SQL the app is executing. Even tried monitoring all jobs with no luck. Since we know what tables the app is hitting we know what to look for. Is there another tool which should be used instead of this one?
If we run SQL against the DB using "Run an SQL script" these statements DO show up in . Any ideas?