<div>
Hi Asim,<br />
<br />
Do you want to see the insert statement(s) or a log of everything that was inserted into a table?<br />
<br />

</div>


Hi Asim,

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



<div>
Hi there,<br />
<br />
I want to see the insert statements that happen at run time.<br />
<br />
Kind Regards,<br />
A.
</div>


Hi there,

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

Kind Regards,
A.

<div>
do you want to see the statements or do you need the actual values?<br />
for example, do you want to see<br />
<br />
insert into table1 values (?, ?, ?)<br />
<br />
or<br />
<br />
insert into table1 &nbsp;values(1,2,3)?
</div>


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)?

<div>
db2 does not have such exact utility.<br />
You may try Event (Statement) Monitor 
</div>


db2 does not have such exact utility.
You may try Event (Statement) Monitor

<div>
@momi_sabaq, we want to see insert into table1 &nbsp;values(1,2,3)?
</div>


@momi_sabaq, we want to see insert into table1  values(1,2,3)?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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.<br />
<br />
Is there an equivalent in DB2 version 9.1?<br />
<br />
What I would like to see is a log for the insertions done (which was originally invoked by the software layer)?<br />
<br />
Kind Regards,<br />
Asim
</div>
</div>


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

SQL Profiler in DB2

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.