Re: DB's on CD's (again)

Chuck, I dont know about this. But the following is the problems I will see. If you try to put the whole instance there it will not work as Informix needs to write things ie physical log/logical log. Even if you wanted the CD to be a dbspace or a chunk so that you could add it to the instance when you wanted to use it, this will not work. When you add a chunk or dbspace Informix wants to write free lists and chunk timestamps etc. An option would be to put an onunload of the database on the CD. This could then be onloaded when you wanted to access it. But this limits you to not be able to change online versions or hardware platforms etc. dbexport is a truly portable platform and you could load the data back when it was needed. One or two GB dbimports arent too bad, but are a far cry from "online" access. Let me know if you do get this to work. We are currently archiving data to CDs and have to use ASCII format for the above reasons. Jason BTW, I know that MS SQL-Server allows you to create read-only databases on removable media. But it is a special option. On Thu, 12 Feb 1998 03:50:17 -0600, Chuck Jackson <cjackson@mail.waco.isd.tenet.edu> wrote: > >I'm going to re-ask this because I misspoke (typed?) earlier. > >What we want to do is put historical OL 5.0 databases (along with the >4GL's >that are current w/ the data) onto CD-ROM where they can STILL be >accessed ON LINE. I didn't mean that we wanted to output an archive ( I > >know, that's what I typed! :o) We want to make "last year's" DB static >but >also available for query and reporting (thru the 4GL's that currently >accompany >it.) > > -- Is it do-able? > -- Does anybody know how to do this? > -- What about 1Gig+ databases? ie. spanning a single volume. > > What about putting them on DVD, since the DB will span a single CD-ROM? > > > We may, in the near future, upgrade to OL 7.x. > -- Will our old 5.0 databases be "broken"? >I think it depends on your hardware and OS. > > I'm sure our 4GL's will need to be (at least) recompiled. > > Thanks! > > Chuck Jackson > System Administrator >Waco ISD >