Re: Restoring individual databases

Art S. Kagel wrote: > Simpson, Don wrote: > > I've thought about that. But I have an instance with over 1400 databases in > > it. I'm thinking maintenance on that many dbspaces would be a nightmare. > > I'm not even sure Informix can handle that many. Anyone know? Not to > > mention what onbar would do on level 0 backups, fork 1400 processes for each > > dbspace? There might even be a system limitation there! > > Max 1024 dbspaces in a 2K page system (2048 on 4K page) also 1024 > chunks (or 2048). Why 1400 databases? Couldn't that have been > condensed into a relatively few databases? Anyway that's the answer. Max 2047 dbspaces no matter what pagesize. Otherwise, I agree, 1400 sounds like an awful lot of databases. They can't ALL be so large that you need to back them all up separately. Maybe the question we should be asking is, WHY do you need to be able to restore each database individually? Please keep in mind that the ability to restore a dbspace does NOT mean you can undo stupid behavior like someone accidentally dropping a table, as you must go through logical recovery, which would replay the drop table. The only reason I can think of for backing them all up separately is to avoid bringing the others down while you restore one, but when they are small, this is not such a big issue. June -- june_t@hotmail.com Grounded in Palo Alto, living on Cafe Mocha