Answer / sadiq afroze

EXPLAIN is used to display the access path as determined by
the optimizer for a SQL statement. It can be used in SPUFI
(for single SQL statement) or in BIND step (for embedded
SQL). The results of EXPLAIN is stored in U.PLAN_TABLE
where U is the authorization id of the user

What types of tables are there in the db2 database?

0 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What is an instance database?

0 Answers  

---

what is parm utility

2 Answers   IBM,

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

What is database reorganization?

0 Answers  

---

List out the buffer pools in db2

0 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

How to find schema of a table in db2?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---