• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1435
  • Last Modified:

SQL Profiler in DB2


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,
1 Solution
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?

asim252Author Commented:
Hi there,

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

Kind Regards,
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 (?, ?, ?)


insert into table1  values(1,2,3)?
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

db2 does not have such exact utility.
You may try Event (Statement) Monitor
asim252Author Commented:
@momi_sabaq, we want to see insert into table1  values(1,2,3)?
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now