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

Define check constraint.

1068

---

How to connect to db2 database from windows command line?

1050

---

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

1033

---

What does db2 mean?

1003

---

Mention the definition of cobol in varchar field.

1236

---

What is reorg?

1146

---

What is cascading rollback?

1203

---

What are the different types of base tables?

1085

---

How is deadlock resolved?

1141

---

How to retrieve rows from a db2 table in embedded sql?

1378

---

What is null value in db2?

1012

---

What is image copy in db2?

1003

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1231

---

What is the difference between db2 and oracle?

1116

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2228

---