SQL Profiler in DB2

Hi,

In SQL Server, we have a tool called SQL Profiler. This allows you to view the insert statements, select statements, stored procedure being currently executed on a database.

Is there an equivalent in DB2 version 9.1?

What I would like to see is a log for the insertions done (which was originally invoked by the software layer)?

Kind Regards,
Asim
asim252Asked:
Who is Participating?
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Asim,

Do you want to see the insert statement(s) or a log of everything that was inserted into a table?

0
 
asim252Author Commented:
Hi there,

I want to see the insert statements that happen at run time.

Kind Regards,
A.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
momi_sabagCommented:
do you want to see the statements or do you need the actual values?
for example, do you want to see

insert into table1 values (?, ?, ?)

or

insert into table1  values(1,2,3)?
0
 
waynezhuCommented:
db2 does not have such exact utility.
You may try Event (Statement) Monitor
0
 
asim252Author Commented:
@momi_sabaq, we want to see insert into table1  values(1,2,3)?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.