PDQ and Growth Edition

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...@yahoo.com> wrote: > 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. 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