Answer Posted / arun

If you want to check from DBA point of view.

I would suggest if the query is taking longer time you can
use any of the tools like detector and check how long the
query is running and how much cpu has been allocated to
this thread and how many get pages has been done how many
rows has been selected or inserted or updated.

We have tools to know the current status of the query.


If the query is simple and completes quickly SQL RC = 0 is
for the normal completion of the query

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1092

---

How can you find out the # of rows updated after an update statement?

1050

---

What are db2 tables?

1049

---

How do I import a csv file into db2?

936

---

List out the buffer pools in db2

1019

---

What is syscat in db2?

950

---

What is a system catalog table in db2?

1101

---

What does reorg do in db2?

983

---

Are views updateable?

1070

---

i want to maintain uniqueness on pdf without make lf??????????

2097

---

What is copy pending and check pending in db2?

950

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2122

---

Comment whether the cursor is closed during commit or not.

1039

---

What is page size in db2?

906

---

How to check sequence on a table in db2?

994

---