RE: No future for DB2

Buck Nuggets wrote: > Hmm, most databases I've worked with don't require an entire subsystem > to make restoration humanly possible. Granted - oracle gives a vast > variety of restoration options, still - most databases don't need > entire manuals on just backup & recovery: just a single chapter in a > book. A chapter that a junior dba can easily master, and can be > expected to perform correctly in a pinch. Which databases don't have a backup/recovery manual amongst the documentation offerings? I am getting your posting via an Informix newsgroup. Granted, Informix ontape may be so simple you don't need a manual and a junior dba can easily do it. But if you go beyond a simple database, you may eventually find yourself in need of a less simple backup/recovery method. The now, defunct Informix onarchive tool had it's own book (a good one), and after reading it, I could make that product dance (senior Informix dba) The current Informix onbar utility has a book too. Noons wrote: >>Very good point, in fact. >>One might of course also deduct that most other databases gloss >>over the multiple possibilities and combinations of recovery. >>One size fits all comes to mind. With the obvious consequences >>in downtimes. Please identify "most other databases". Is this MySQL? MSAccess? Informix certainly does not gloss over this topic, and I can't imagine IBM's DB2 offering does either. >>Having said that, I'm the first to agree: Oracle recovery is a tad too far optioned and it can be very confusing. Try Informix onbar? (am I confused ....this discussion thread is happening in an Informix newsgroup) >>I assume you mean "the alternatives within oracle"? ;) >>Well, having been on the receiving end of recovering SS and udb >>databases in Windoze, all I can say is without RMAN I don't see >>Oracle as that much different from the others: Unless you're in a real bind, you probably do not want to be practicing fancy/chancey restores in productions systems anyway. Your summary is perfect.... in production, no matter what DB product you are on.... >>"Cleanup remnants, restore from backup[in whatever trusted full/partial you desire], >>restart in maintenance mode, apply logs, reopen for general access." In dev, hey anything goes.... whether that's RMAN practice or Onbar practice. ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ sending to informix-list