Re: How to hurt an Informix DB?

Curtis Preston (curtis@colltech.com) wrote: : SO, Informix folk, what can happen during an INFORMIX restore? (Or what : can happen to a running Informix database that would cause a restore?) : 1. Sysmaster dbspace blown away : 2. Logging device blown away : 3. ??? : What kind of nasty things have happened to your Informix databases that : required a restore? I want to cover every scenario. Nasty happenings: Archives failing without warning when the archive reached a 2-gig size limit (this only affects some O/S's) Restores necessitated by offsets and overlapping chunks in the file system (this one is particularly nasty, since it'll run along just fine until it tries to use data in a conflicting area) Most common causes for restores are either disk problems or user error (drop database business_critical) -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" The DBA Survival Guide, Second Edition will cover NT, 7.X through 7.3, graphical utilities, more survival hints. Publish date: 12/16/98 FINALLY! ---------------------------------------------------------------------------