Re: DB Sapces....
Posted in 2006
Sebastian, Norma J. wrote:
> 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
> ============================================================