Re: Slow database creation and loading

Hello John, do not set > export MAX_PDQPRIORITY=100 PSORT_NPROCS=6 PDQPRIORITY=100 > FET_BUF_SIZE=32767 make sure you have the shm connection. i do not see any i/o on your tempdbspaces....before you start do a onstat -z can you try setting DBSPACETEMP env var: export DBSPACETEMP= temp_space1,temp_space2 then dbaccess set pdqpriority 100; select current from systables where tabname = systables;create index...... select current from systables where tabname = systables;create index.... select current from systables where tabname = systables;... etc. do post a onstat -D. also a onstat -g mgm may help; dono we can then rule out that pdq is used or not.... you still may see an i/o problem which is hidden by sar... if kaio is used you may not see that it is waiting on i/o. maybe topas can tell you a bit more. Sorry that is all that comes to mind at the moment... Superboer.