Answer / yuvaevergreen

Indexable predicates are the one which match with index
entries. It depends on the indexes that are available and
the access path chosen at bind time.
For example,if the employee table has an index on the
column LASTNAME,
the following predicate can be a matching predicate:
SELECT * FROM emp WHERE LASTNAME = 'SMITH';
Stage 1 predicates are the predicates which are processed
by Data
manager component of DB2 as soon as it recieves data from
the buffer manager.
Some examples are:
COL BETWEEN value1 AND value2
COL IN (list)
COL LIKE host variable
more examples:
http://publib.boulder.ibm.com/cgi-bin/bookmgr/
BOOKS/dsnapj12/6.3.3.2?
DT=20050328013405#TBLISARG

What is a view? Why use it?

3 Answers  

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

What is reorg in database?

1 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What is cursor stability?

1 Answers  

---

What is db2 instance?

0 Answers  

---

How many types of page locks can be held in db2?

0 Answers  

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

Explain correlated sub-queries.

0 Answers  

---