471,855 Members | 1,074 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,855 software developers and data experts.

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 1412
"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 Együd 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
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.