"chettiar" <ch************ @yahoo.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .
Hi,
I am dropping an index and recreating it to lower the high water mark.
The index creation is taking a lot of time. I am stuck as to why it
does so. Is there any way that I can find out why it is doing so. Is
there a snapshot that will help me while index creation.
P.S. There are no users connected to the system when i m creating the
index.
DB2 needs a work area to sort the index rows before creating the index. If
your system temporary tablespace is too small, it could take a lot longer
than necessary. If you system temporary tablespace is SMS defined on a path,
make sure you have adequate space on the path for it grow as needed. If it
is DMS (not a good idea), then make sure enough space is allocated. By
"enough," I mean several times as large as the index in order to speed up
the creation of the index. Generally, you system temporary tablespace
should be at least as large as your largest table (minimum size).