Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.