Answer / s

Clustering index determines where the row will be inserted.

Answer / saeed

clustering index attempts to maintain a particular order of
data, it try to keep newly inserted rows clustered
according to an index and avoid page splits.

Answer / mainframe.rahulz

A DB2 index is a clustering index if the CLUSTER keyword is
specified when the index is created.In a clustered index
rows are stored continuously in a an
order.

When you define a clustering index on a DB2 table, you
direct DB2 to insert rows into the table in the order of the
clustering key values. The first index that you define on
the table serves implicitly as the clustering index unless
you explicitly specify CLUSTER when you create or alter
another index. For example, if you first define a unique
index on |the EMPID column of the EMP table, DB2 inserts
rows into the EMP table in the order of the EMPLOYEE ID
unless you explicitly define another index to be the
clustering index

Eg:CREATE INDEX Index name
ON tablename CLUSTER;

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

What is the difference between Primary key and unique index?

6 Answers  

---

What is a base table?

2 Answers  

---

What is the logical entity between plan and Package?

5 Answers  

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---

What is db2 optimizer?

0 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

How to take backup of table in db2?

0 Answers  

---