Answer Posted / s.v.venkata sivaprasad

reorg is a db2 use to improve the performance and any unused
pages in table space is rearange it perticul order and
release free space
//job1 job....
//step1 exec pgm=IKJEFT01
//sysin dd *
reorg db123.tb123
//

Mention the location where the output received from explain statement is stored.

1053

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1020

---

What is bufferpool in db2?

983

---

Mention the different locking levels that are available in db2.

1064

---

What is bind in db2?

975

---

Is ibm db2 open source?

1010

---

How does coalesce work?

955

---

What is query_cache_limit?

927

---

List some fields from sqlca?

1000

---

How do you pull up a query which was previously saved in qmf?

1098

---

What is ibm db2 client?

876

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1974

---

Which component is responsible for db2 startup and shutdown?

979

---

What is syscat in db2?

949

---

How do I add a column in db2?

997

---