469,609 Members | 1,634 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

problem while index creation

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
1 1341
"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.

Similar topics

reply views Thread by Guy Deprez | last post: by
15 posts views Thread by Hemant Shah | last post: by
1 post views Thread by I am Sam | last post: by
20 posts views Thread by Development - multi.art.studio | last post: by
15 posts views Thread by Egyd Csaba | last post: by
reply views Thread by Spacen Jasset | last post: by
4 posts views Thread by Laurence Breeze | last post: by
3 posts views Thread by mearvk | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.