By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

problem while index creation

P: n/a
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.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"chettiar" <ch************@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.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).
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.