RE: temp space question

Posted in 2007

John Adamski — Tue, 16 Jan 2007 11:32:49 -0600 — source: Usenet: comp.databases.informix

We have 4 CPUs on the server, instance can us 3, so think 6 GB should be a good number as 9GB seems we don't use most of the space most of the time. With 6GB I was hoping to handle peak times with plenty of room to spare. John -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of elanleblanc@yahoo.com Sent: Monday, January 15, 2007 1:27 PM To: informix-list@iiug.org Subject: Re: temp space question How many CPUs do you have allocated to the instance? A good rule of thumb is to set your temp spaces to a multiple of the number of CPUs. More, smaller temp dbspaces typically provide better parallelism and performance so long as there is no bottleneck with storage. Christine jda wrote: > We have an instance of IDS 9.40.HC3 on a HP-UX 11i (11v1) box, that has > about an 100GB database and currently the temp space is 9GB made up of > 6 chuncks. I want to reduce the temp space to 6GB made up of 3 2GB > chucks. If for no other reason to make it look pretty. :-) Really I > want to use the freed space to an another chuck for the database > dbspace. We seldon go over 3.5GB use of temp space so 6GB should be > enough for the unexpected. > > My question is what is what is the easies way to do this or am I just > mad in thinking to try it? > > My idea was to bring down the engine then drop the first 5 nodes, > rename 5th & 6th to 0 & 1 and then create a new LVM node. Change the > onconf to reflect just temp0-temp2 and bring up the engine. It that a > good plan? What am I missing? > > John > > DBSPACETEMP temp0:temp1:temp2:temp3:temp4:temp5:temp6 > > crw-rw---- 1 informix informix 64 0x01000f Apr 2 2005 temp0.1 > {1GB} > crw-rw---- 1 informix informix 64 0x010010 Apr 2 2005 temp1.1 > {1GB} > crw-rw---- 1 informix informix 64 0x010011 Apr 2 2005 temp2.1 > {1GB} > crw-rw---- 1 informix informix 64 0x010012 Apr 2 2005 temp3.1 > {1GB} > crw-rw---- 1 informix informix 64 0x010013 Apr 2 2005 temp4.1 > {1GB} > crw-rw---- 1 informix informix 64 0x010026 Mar 4 2006 temp5.1 > {2GB} > crw-rw---- 1 informix informix 64 0x010027 Mar 4 2006 temp6.1 > {2GB} _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list