Oninit cdi / Archive
Talk to an expert →

Question on dbspaces and third party repositories

Posted in 2004

Topics: Performance & Tuning, Storage & Space Management

Geezer From Freezer — — source: Usenet: comp.databases.informix

We have an old system that I have inherited that has several repositories on some some third party software that is stored in informix. Each repository is stored in an individual dbspace. What is the reason for this, and would there be any reason (performance or admin) for not having the repositories stored on one dbspace?

↪ replying to Geezer From Freezer
Art S. Kagel — — source: Usenet: comp.databases.informix

On Tue, 30 Mar 2004 04:09:33 -0500, Geezer From Freezer wrote: > We have an old system that I have inherited that has several repositories on > some > some third party software that is stored in informix. Each repository is > stored in an individual dbspace. What is the reason for this, and would > there be any reason (performance or admin) for not having the repositories > stored > on one dbspace? The granularity of archive restoration is by dbspace. You can restore the entire system or a single dbspace. By placing each repository in a separate dbspace you can restore one that's been damaged. Art S. Kagel

↪ replying to Geezer From Freezer
scottishpoet — — source: Usenet: comp.databases.informix

Not sure what your backup strategy is like, but it is possible to recover indivual dbspaces. Therefore if you have each database in a different dbspace it meansyou can recover a particular database. Geezer From Freezer <Geezer@Freezer.com> wrote in message news:<4069394D.22B03164@Freezer.com>... > We have an old system that I have inherited that has several repositories on > some > some third party software that is stored in informix. > Each repository is stored in an individual dbspace. What is the reason for this, > and > would there be any reason (performance or admin) for not having the repositories > stored > on one dbspace?

Glossary