Re: tempspace

In answer to my #4 question and Obnoxio's reply..... I thought I read or heard somewhere that Informix treats a dbspace differently than a chunk - obviously that is not true ... Maybe it was a bad dream..... Thanks for the other info.... Robin > From: "Obnoxio The Clown" <obnoxio@hotmail.com> > Organization: Mailing List Gateway > Reply-To: "Obnoxio The Clown" <obnoxio@hotmail.com> > Newsgroups: comp.databases.informix > Date: Fri, 07 Jul 2000 10:42:42 BST > Subject: Re: tempspace > > > From: Boscia <rwboscia@worldnet.att.net> >> >> I have 3 tempspace dbspaces. They are each 2 Gig. We are running IDS 7.3 >> on a Sun E10K with 18 Gig disks - & using raw disk space. >> We have some very large tables that "see action" continuously. >> >> 1. Is it "smart" to use 1 disk for all 3 tempspaces? > > No. > >> 2. Or should the tempspace be sharing disk space with other tables? > > No. > >> 3. Or should each tempspace have it's own disk? > > Yes. > >> (In this scenario, it would be a waste to use the 18G - so we would >> probably opt for smaller ones-which is an option) >> >> Also, another question about tempspace.... >> 4. Is there any advantage to creating the tempspaces as dbspaces rather >> than as chunks? > > Huh? You want separate dbspaces, not just chunks of a single dbspace. > > Something else you might want to look into is PSORT_NPROCS and PSORT_DBTEMP. > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >