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

Tempspace UDB V8 FP 10

P: n/a
How large should tempspace be relative to the largest table in a
database to do reorgs? Does tempspace have to be at least twice the
size of the table being reorged. Assuming nothing is using tempspace at
the time other than a reorg on 1 table. It appears when the total of
used pages on that table is more than half the size of the Tempspace
file system, we get the disk full error. Has anyone else experienced
this? Table to reorg is DMS. Tempspace is SMS. With nothing running
execept the reorg, we've watch the file system used for tempspace grow
to 100% and fail with disk full error. We've even tried dropping all,
but 1 index on the table prior to reorging and still get the same
results.

reorg table table index index allow read access use TEMPSPACE

Apr 24 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.