RE: DB Sapces....
What's your backup strategy?
Informix onbar - smallest unit of work is a dbspace.
So if you have a 1 TB database in only 1 dbspace.... however long it
takes your backup software (i.e. netbackup/etc) to backup 1TB of
data...... that is how long your DB backup will be.
If your DB is across 10 dbspaces, .... and can multi-stream your
backup.... you'll have a faster backup, ....
And you know your backup time generally dictates your restore time....
so how fast will you need to restore???
Norma Jean Sebastian
ERP Support Administration
GIS- Enterprise Technical Services
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Tam OShanter
Sent: Thursday, November 09, 2006 10:49 AM
To: informix-list@iiug.org
Subject: DB Sapces....
Hello Friends,
I'm looking for the reasoning in deciding on how many DB Spaces to use
on a
given system.
Specifically, if using a SAN where disk IO and LUN size isn't an issue,
what
would be the reason for using multiple DBSpaces as opposed to 1 large
one?
Also, is a 60/40 ration of data space to log space a valid one when
sizing?
I'm sure this is a pedestrian question for most of you, but I am
currious.
Tam.
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================