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 the sqlcode -501

12916

---

Can there be more than one cursor open for any program?

1123

---

What os does db2 run on?

924

---

What are the bind parameters ibm db2?

988

---

What is the physical storage length of timestamp data type?

1024

---

What is difference between isnull and coalesce?

1006

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

---

How do I add a column in db2?

997

---

What is difference between alias and synonym in db2?

1066

---

Why do chiropractors use drop table?

1044

---

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

1085

---

Can we update view in db2?

944

---

What is table space in db2?

959

---

Explain the contents that are a part of dclgen.

1033

---

Which are the db2 tools to protect integrity of the database?

1070

---