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

Indexing mode "autoselect"

P: n/a
Dear all,

The LOAD indexing mode is by default, I presume, "autoselect", and the LOAD
should choose between REBUILD or INCREMENTAL.

In version 7.2 FP11, so in "offline" mode, with a LOAD INSERT, we got the
LOAD choose the REBUILD despite the lack of pages in the tablespace (we had
2Million 16K page free, but this was not enough).

Is the behavior the same in V8.1 (I've noticed the READ ACCESS mode only
allows to REBUID ... USE TEMPSPACE) ?

If yes, could the LOAD "autoselect" mode, pick up the available free space
in the TS (that is DMS/ one for data, one for Index), the NLEAF from the
index and substracting the 2 values, decide to switch to INCREMENTAL mode,
instead of allowing your tablespace to blow up ?

Thanks for your help,

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.