Answer / s

Data Manager evaulates the Stage 1 Predicates on the data
in the bufferpool. It also interfaces with the index
manager for index processing. Data Manager does tablespace
scans. The DM passes the qualifying rows are one column at
a time the Relational data manager.

Answer / renu gupta

Data Manager manages the physical databases by performing
all the normal access method functions

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

what is the role of the cursor in db2?

0 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

What is meant by repeatable read?

4 Answers  

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

What does db2 mean?

0 Answers  

---

Which transaction use a command thread ?

1 Answers  

---