Oninit cdi / Archive
Talk to an expert →

Re: Load Performance problems

Posted in 2000

Topics: Performance & Tuning, Storage & Space Management, Logging & Checkpoints, Platform-Specific Issues, Versions, Editions & End-of-Life

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: benlag@aent.com > >I have a IDS 7.30 UC8-1 server running on HP-UX 11.0 system. > >The database is a data warehouse and I am trying to configure it so >that it is optimized for a DSS environment. We process daily data loads >at night that sometimes run 6 to 8 hours. During the load checkpoints >are occuring at almost every five minutes (probably because the >physical buffer is being filled). I want to configure the server so >that NO checkpoints occur any time during the load. (I will force a >checkpoint before the load and after the load in my script) I have >tried changing many parameters (LRUS, PHYSBUFF, CLEANERS) to try and >make this happen but nothing has worked. I have tried increasing >PHYSBUFF up to 1024 to no avail...> >How can I configure my server so that during my load checkpoints do not >occur?? I doubt anyone can promise it will *never* happen, but you can try to minimise it by >PHYSDBS plogdbspace # Location (dbspace) of physical log >PHYSFILE 2000000 # Physical log file size (Kbytes) ># Logical Log Configuration > >LOGFILES 12 # Number of logical log files >LOGSIZE 2000 # Logical log size (Kbytes) You may need more than this. I don't know. >LTAPEDEV /dev/null # Log tape device path Oh. Maybe not. :0) >LOCKS 15000 # Maximum number of locks >BUFFERS 225000 # Maximum number of shared buffers >NUMAIOVPS 25 # Number of IO vps Switch on KAIO. >QSTATS 1 Do you really want this on? ># Read Ahead Variables >RA_PAGES 32 # Number of pages to attempt to read>ahead >RA_THRESHOLD 4 # Number of pages left before next group Try 32 and 28. >OPTCOMPIND 0 # To hint the optimizer ??? Try 2. >TBLSPACE_STATS 1 Sure you want this on? You can probably double your PHYSBUFF, if you like. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Manel Falc� i Aige — — source: Informix-list mailing list archive (1991-1998)

Hi ! QSTAT ? what does it do ? I didn't find it on my onconfig V7.30 and TBLSPACE_STATS 1 What is it for ? tablespace statistics ? where do they go ? so, better to 0 ? Regards, Manel Falcó > >>QSTATS 1> >Do you really want this on? > >># Read Ahead Variables >>RA_PAGES 32 # Number of pages to attempt to read>>ahead >>RA_THRESHOLD 4 # Number of pages left before next group> >Try 32 and 28. > > >>OPTCOMPIND 0 # To hint the optimizer> >??? Try 2. > >>TBLSPACE_STATS 1> >Sure you want this on? >

Glossary