index building performance

IDS 9.40.UC2 / RedHat AS 3 / 4CPUs (OS sees 8) I'm building a primary key / unique index on a 140M+ row table. I have PDQ=100 in the environment, PSORT_NPROCS=6 and NETTYPE ipcshm,6,30,CPU. Question: I have 2 temp spaces. Will adding temp spaces - on different spindles - speed up the index build? TIA

Bob Roussey said: > IDS 9.40.UC2 / RedHat AS 3 / 4CPUs (OS sees 8) > > I'm building a primary key / unique index on a 140M+ row table. I have > PDQ=100 in the environment, PSORT_NPROCS=6 and NETTYPE ipcshm,6,30,CPU. > > Question: I have 2 temp spaces. Will adding temp spaces - on different > spindles - speed up the index build? Try adding temporary file systems on different spindles and setting PSORT_DBTEMP. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche When I was a kid, we walked 6 miles to school every day, sometimes in the rain or snow. Man, did we feel stupid when we found out there was a bus ...