Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1407
  • Last Modified:

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
0
asim252
Asked:
asim252
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?

0
 
asim252Author Commented:
Hi there,

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

Kind Regards,
A.
0
 
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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