RE: ETL tool configuration

I've forgotten the type of tin we're on here? From: "Farmer, Byrd G - CFC" <Farmer.Byrd@cfwy.com> > >NETTYPE ipcshm,1,20,NET # Configure poll thread(s) for nettype >NETTYPE tlitcp,6,20,CPU # Configure poll thread(s) for nettype I'd rather swap NET and CPU on the above. >RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) Have you tried -1 >MULTIPROCESSOR 1 # 0 for single-processor, 1 for>multi-processor >NUMCPUVPS 7 # Number of user (cpu) vps >SINGLE_CPU_VP 0 # Set to 1 for 1/2 processor machines >NOAGE 0 # Process aging This might be better on 1. >AFF_SPROC 0 # Affinity start processor >AFF_NPROCS 0 # Affinity number of processors Setting these soemtimes helps. >LOCKS 400000 # Maximum number of locks >BUFFERS 900000 # Maximum number of shared buffers >NUMAIOVPS 4 # Number of IO vps I assume you have KAIO? >PHYSBUFF 16 # Physical log buffer size (Kbytes) >LOGBUFF 16 # Logical log buffer size (Kbytes) Buffered or unbuffered logging? Or none at all? >LOGSMAX 24 # Maximum number of logical log files Seems a bit low. >CLEANERS 10 # Number of buffer cleaner processes Seems a bit low. >SHMADD 32768 # Size of new shared memory segments Seems a bit low. >CKPTINTVL 300 # Check point interval (in sec) >LRUS 24 # Number of LRU queues 37,500 buffers per LRU? I'd add a few more LRUs... :-) >LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning limit >LRU_MIN_DIRTY 2 # LRU percent dirty end cleaning limit OLTP or DSS? >RA_PAGES 64 # Number of pages to attempt to read ahead >RA_THRESHOLD 50 # Number of pages left before next group I'm not sure if values > 32 pages actually work, but I stand to be corrected. >"onstat -d" >INFORMIX-OnLine Version 7.24.UC3 -- On-Line -- Up 2 days 18:03:34 -- >3094784 K >bytes > >Dbspaces >address number flags fchunk nchunks flags owner name >7e03a100 1 1 1 1 N informix rootdbs [SNIP] That's a lot of disk. Not exactly evenly used, is it? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com