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,
Regards,
Jean-Marc