problem while index creation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chettiar - 31 Jul 2005 08:54 GMT

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.

Reply to this Message

Mark A - 31 Jul 2005 09:13 GMT

> Hi,
>
[quoted text clipped - 5 lines]
> 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).

Reply to this Message