HI all,

is there a way how to track SQL statements sent to the server?

I'm using ADO.NET Entities Tool which generates these statements automatically (based on entity model etc...), so I can't check them and I don't know how they look like.

I know about possibility to create Event Monitors, but it seems to me too complicated to define, filter, manage and analyze records.

Isn't there another easier way how to track them?

Thanks a lot!

Frantisek

---
DB2 v9.5.0.808 (Express), OS Win 2003 Server

Easiest way is to "Get snapshot for dynamic SQL" (see Command Reference). You will have to turn on the statement monitor.

db2pd is your friend

I'm probably missing something, but when i run command db2pd in the interactive mode and then enter -db DBNAME -dynamic command, the tool displays tons of statistics from the past.

When I enter the command db2pd -db DBNAME -dynamic, the output is Option -dynamic requires -db <database> or -alldbs option and active database.

I'm DB2 greenhorn, so I'd like a tool like a MS SQL Profiler - it is a windows application with disagnostic window and when it is active, it monitors activity and displays SQL statements immediately after they are sent to the SQL server, so it is easy fo find last command and assign it to the correct UI action.
MS SQL Profiler Screenshot

Do you mean some special SQL statemenet?

You could flush the package cache if you do not want the "SQL history lesson". To look at the SQL currently execuitng I'd recomment db2mon.

Yep, that's the tool i was looking for :-) It is based on snapshots also, but it has functionality to show differences between them. It has potential to become my favorite tool :-) Thanks a lot.