Re: tempspace

Boscia wrote: > > 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, use 3 spindles if you can. > 2. Or should the tempspace be sharing disk space with other tables? It probably will have to unless you have a lot of spare disk. > 3. Or should each tempspace have it's own disk? These days, with 18 and 36 Gb disks, not many people can devote them to temp space. :-) But if you can, then do. > (In this scenario, it would be a waste to use the 18G - so we would > probably opt for smaller ones-which is an option) If you can still get them, then yes. Generally, temp space is spread out over your disks with low access tables. > Also, another question about tempspace.... > 4. Is there any advantage to creating the tempspaces as dbspaces rather > than as chunks? That question does not make sense! A tempspace IS a dbspace, and dbspaces are created using chunks. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+