Answer Posted / 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;

What is cascading rollback?

1205

---

What is catalog database in db2?

1156

---

How do you stop a db2 database in linux?

1006

---

What is copy pending and check pending in db2?

994

---

B37 abend during spufi?

1450

---

What is a bind card?

1212

---

What is dclgen (declaration generator)?

1049

---

What is a page in db2?

1025

---

List down the types of triggers in the db2 database?

1018

---

Why do we need reorg in db2?

981

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1097

---

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

1065

---

Which component is responsible for db2 startup and shutdown?

1031

---

How to create db2 table in mainframe?

1150

---

What is runstats and reorg in db2?

1295

---