ontape/onbar

Hi, we are proud owners of two aix pseries. On each server we have one online system with 25 databases. We use ontape (Level 0) to save the online system, but we have the problem that we can't restore one special database. Anybody better experiences, may be with onbar? Thanks for all hints Jogi

On Thu, 04 Dec 2003 05:33:45 -0500, jogi wrote: > Hi, > > we are proud owners of two aix pseries. On each server we have one online > system > with 25 databases. We use ontape (Level 0) to save the online system, but we > have the problem that we can't restore one special database. Anybody better > experiences, may be with onbar? I do not understand. Ontape does not restore individual databases. You can only restore either an entire instance or specified dbspace(s). Are you saying that your 25 databases live in 25 separate instances of IDS? Or that there is one instance but each database has its own dbspace and you are restoring the dbspaces individually? If the former, I do not know what the problem is with that one restore, but I have a question. WHY? Why not compile several or all of the databases into a single instance or at least a small number of instances? If the latter, perhaps that database was initially created in the root dbspace and so you are not correctly restoring the entire database when you restore the one dbspace? Art S. Kagel

Hi Art, thanks for your answer. My English in not the very best, so sorry ... We have one instance wtih 25 databases with own dbspaces. I think for every database an own instance costs too much memory and cpupower. Restoring a single dbspace is not really assists by informix. May be its better with ONBAR or another possibility is to do an export every nigth. Greetings Jogi "Art S. Kagel" <kagel@bloomberg.net> schrieb im Newsbeitrag news:pan.2003.12.04.08.54.40.242661.12806@bloomberg.net... > On Thu, 04 Dec 2003 05:33:45 -0500, jogi wrote: > > > Hi, > > > > we are proud owners of two aix pseries. On each server we have one online > > system > > with 25 databases. We use ontape (Level 0) to save the online system, but we > > have the problem that we can't restore one special database. Anybody better > > experiences, may be with onbar? > > I do not understand. Ontape does not restore individual databases. You can > only restore either an entire instance or specified dbspace(s). Are you saying > that your 25 databases live in 25 separate instances of IDS? Or that there is > one instance but each database has its own dbspace and you are restoring the > dbspaces individually? > > If the former, I do not know what the problem is with that one restore, but I > have a question. WHY? Why not compile several or all of the databases into a > single instance or at least a small number of instances? > > If the latter, perhaps that database was initially created in the root dbspace > and so you are not correctly restoring the entire database when you restore the > one dbspace? > > Art S. Kagel