Oninit cdi / Archive
Talk to an expert →

Re: (2) Poor Performance with 7.31.uc6

Posted in 2000

Topics: Performance & Tuning, Server Administration

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

I have one here I cut up earlier if anyone's interested? From: Andy Lennard <andy@kontron.demon.co.uk> > >Is there a utility to rebuild indexes? or is dbschema/dbaccess the best? > >In article <397E269B.B55E93FF@maxor.invalid.com>, Ty O'Kelly ><tokelly@maxor.invalid.com> writes > >Obnoxio The Clown wrote: > > > >> A word to the wise: when you need to do your index rebuilds, set the > >> following environment variables: > >> > >> PSORT_NPROCS=[2 * NUMCPUVPS] > >> PDQPRIORITY=100 > >> PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 # i.e., 3 temporary filesystems > > > >how will PDQPRIORITY=100 be affected by the onconfig parameter >MAX_PDQPRIORITY> >which is currently10? (i am at home and don't have the fm to read.) > > > >thanks, > >ty > > > > > >Andrew Lennard andy@kontron.demon.co.uk ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Andy Lennard — — source: Informix-list mailing list archive (1991-1998)

Yes, please. Thanks, Andy. In article <8lmhbm$or3$1@news.xmission.com>, Obnoxio The Clown <obnoxio@hotmail.com> writes > >I have one here I cut up earlier if anyone's interested? > >From: Andy Lennard <andy@kontron.demon.co.uk> >> >>Is there a utility to rebuild indexes? or is dbschema/dbaccess the best? >> >>In article <397E269B.B55E93FF@maxor.invalid.com>, Ty O'Kelly >><tokelly@maxor.invalid.com> writes >> >Obnoxio The Clown wrote: >> > >> >> A word to the wise: when you need to do your index rebuilds, set the >> >> following environment variables: >> >> >> >> PSORT_NPROCS=[2 * NUMCPUVPS] >> >> PDQPRIORITY=100 >> >> PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 # i.e., 3 temporary filesystems >> > >> >how will PDQPRIORITY=100 be affected by the onconfig parameter >>MAX_PDQPRIORITY>> >which is currently10? (i am at home and don't have the fm to read.) >> > >> >thanks, >> >ty >> > >> > >> >>Andrew Lennard andy@kontron.demon.co.uk > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > Andrew Lennard andy@kontron.demon.co.uk

Glossary