Re: Multiple-onlines with shared disk?

In <1993Apr5.160644.18616@informix.com> davek@newjersey.informix.com (Dave Kosenko) writes: >Andrew Burt writes: >|> We have two online licenses at this point (for the same machine): A >|> development licencse and a runtime license. Indeed, we have two sets of >|> tapes, serial numbers, etc. >|> >|> <STUFF DELETED> >|> >|> Ok, but, suppose I *want* to share the chunks (mainly since we have about >|> 7Gb of data on 10Gb of disk space; so we can't have two complete >copies, even >|> if we wanted to, which we don't, since the development code needs to see the >|> changes the production side sees, etc. etc. etc.). So my question is, will >|> the world END if I share the chunks, rootdbs and all? >|> >|> <STUFF DELETED> >NO! This will NOT work, since there is no coordination between two >OnLine instances for things like log buffers, checkpoints, etc. You >WILL wind up with a corrupted database if you attempt to share chunks >amongst different OnLine systems. >As per the runtime vs. development: there is no such thing as a runtime >server. A server is a server. However, when you buy runtime tools, >you are given a price break on your server. The functionality of the >server remains the same. If both runtime and development are on the same >machine, you can simply use the same server. You will NOT be in violation >of your contract if you have paid for a development license. Dave is quite right the world will end, or at least your database will! I am confused as to your requirement as I would have thought that one of the reasons for two servers would be to HIDE the Development changes from Production. If, what you really require is to share TABLES (rather than CHUNKS) then Informix have a little product called Informix-Star which would allow you to do just that (read-only at 4.x, read/write at 5.0). Maybe they'll let you trade in your superfluous OnLine license!!! (PS If you really don't need to protect production from development, why have two servers at all???) graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.