Re: Onconfig Question

In article <6ebhun$stu@camel12.mindspring.com>, Barry Leb <barryleb@atl.mindspring.com> writes >I sent this a few weeks ago and didn't get any responses. I am >rephrasing the heading and trying again. > >We are not currently having any performance problems, but I am >interested in hearing some opinions from the experts out here. > >One of our systems is as follows: > >Sun SPARCcenter 2000E, Solaris 2.6, Veritas VM2.4 >6 SPARCstorage Arrays 100's populated with 1gig and 4 gig drives >All data and indexes are spread across 158 1 gig drives. >512 meg memory, 10 cpu's >Informix 7.14.ud5, Informix mirroring > >The system is 98% DSS. 99% of all inserts, updates and deletes done >through batch jobs approximately 2/3's of them run during off hours. >Largest table is 60 million rows of history. Next largest table only >5.6 million rows. Tables are fragmented primarily by round robin with >largest tables spanning 8 dbspaces. All indexes on largest tables are >detached and fragmented by expression across as many as 10 dbspaces. > >Currently we have approximately 80 users with access to the database, >but typically we have at most 15 queries running at any given time. >Occasionally we may get as many as 25 queries peak. > >These are some of our onconfig settings: > >SHMVIRTSIZE 170000 >SHMADD 30416 >SHMTOTAL 0>PDQPRIORITY 2 >MAX_PDQPRIORITY 100 >DS_MAX_QUERIES 20 >DS_TOTAL_MEMORY 160000 >DS_MAX_SCANS 100> >PSORT_NPROCS is not set. > >1. Given everything above, how would you configure these parameters? Depends, I would need an onstat -a to be able to tell what queries are running. >2. In the near future, DSS queries is likely to double or triple, >would you set the parameters differently? > Depends in what way it will change, exactly what SQL will be run and when.. Although I may well up DS_MAX_QUERIES to 80 and DS_MAX_SCANS to 160. >I am particularly interested in your opionions relating to decision >support variables and the best way to set PSORT_NPROCS variable. > >Thanks in advance. > >Barry Leb > >National Linen Service >1420 Peachtree Street >MS #314 >Atlanta, GA 30309 > >(404) 853-6119 >(404) 853-6485 fax >e-mail: barryleb@mindspring.com > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care