I'm doing an upgrade from 9.40 to 11.5.

For reasons unrelated to the upgrade process I want to buiold a new 11.5
server and dbexport/dbimport from 9 to 11.5

This is taking much longer than I planned for because I'm using IDS 11.5
Growth Edition, which disables PDQ, so the index builds are unviably slow.

Does anyone know any way to legitimately by-pass this? I assume not but
thought I'd ask, as I'm not going to get a downtime long enough to do the
migration.

Obviously I could install Enterprise Edition just to do the dbimport then
uninstall it and replace it with Growth but I'd like to avoid it, not least
because it's not legitimate.

Thanks

Hello Neil,

Try putting your TEMPDBS in ramdrive. That should speed up the
sorting required to create an index. Also, make sure your swapping is
zero.

Just for grins, I would try everything: Define tables as raw, lock
tables in exclusive mode, dirty read, LIGHT_SCANS=FORCE, cio, dio,
ANSI database, etc. This won't be as fast as ramdrive but might add
more speed anyway.

L.S.

On 12 Aug, 20:21, LIGHT SCANS <light_sc... (AT) yahoo (DOT) com> wrote:
Neil, thought you did Informix consultancy so you should be able to
tell us!!

Set DS_NONPDQ_QUERY_MEM to a large value.

Use a large PSORT_NPROCS and PSORT_DBTEMP (many folders, each folder
stripped across a different set of spindles).

Increase RA_PAGE RA_THRESHOLD CKPTINTVL LRU_MIN/MAX_DIRTY