From: "xaw" <xaw_spam_@mail.com>
>
>Hello dear DBAs.
Errm....
>I heard that it is not possible to make online reorganizations on Informix.
You probably heard this from the same person who said you can do it in
Oracle, right?
>I'm sorry if this is unclear... I mean a way to have maintenance jobs run
>while
>the database keeps on running. As far as I know, it is possible to do with
>Oracle
>DBs.
>Well, I just want double check. Some comments ?
Yes. Most of them unprintable. I can't think of a single reorg operation
that wouldn't require the database to be online. In other words, the
database must be running to do most reorgs. IIRC, adding logical logs
requires quiescent, and moving the physical log takes the server down, but I
bet you couldn't do either of those (or rather, their equivalents) in Oracle
without a recycle either.
What, specifically, do you want to do?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com