set index enabled online?
Posted in 2014
Greetings.
After a less-than-impressive HPL job aborted amidst enabling the indexes it
had disabled for its load (10,000+ rows/sec, HOURS to enable each index) it
still left 3 indexes in a disabled state. I'd really prefer to:
set indexes for <table> enabled
but do not wish to leave the table locked for over 7 hours while it rebuilds
the indexes. The alternative is to:
- Run dbschema to get the syntax to recreate those indexes
- Drop the indexes
- Recreate them from scratch, using CREATE INDEX with the ONLINE option, and
with the help of PSORT and possibly SET PDQPRIORITY 25.
I have not found any information on using the ONLINE option to SET INDEXES
ENABLED. Am I merely not finding it or does that option really not exist for
the command? My client is using 11.5 but if that option exists in a later
release I'd sure like to know about it as well.
Thanks.
-- Jacob S.