SEO

EEM

Yep I left out the backups, you know the DBA's motto "when in doubt do a
backup". :-)

Hmm I forgot about logged temp tables, I think only the developers would
be creating any of them and rootdb space seems to be pretty stable with
room in it. So, maybe they are actually listening to me to create their
temp tables with no logs.

John

-----Original Message-----
From: Everett Mills [mailto:eemills@nationalbeef.com]
Sent: Monday, January 15, 2007 2:01 PM
To: John Adamski; informix-list@iiug.org
Subject: RE: temp space question

The only thing I saw is that you didn't mention running backups before
and after, but I'm figuring you'd do that anyway. Other than that,
remember that if you have logged temp tables, you need a logged temp
space for them, or they'll land in your rootdbs.

--EEM

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of jda
Sent: Monday, January 15, 2007 12:24 PM
To: informix-list@iiug.org
Subject: temp space question

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