Re: Informix SE questions related to backups

Larry Magiera wrote: > > Pardon me if these topics have been discussed before, I'm new to > Informix. > > I am using Informix SE version 7.24 running under unix. > > >From what I've been able to gather, there is no safe way to ensure data > integrity when performing a tar of the SE data files while the database > is running. Is this true, or am I missing something? If this is the > case, are there any suggestions on performing a warm backup on a 24x7 SE > database? SE is the low end product of Informix's database servers. If you needed a server that was capable of doing a warm backup, then this was the wrong choice. I am currently running on an older version of SE, our database can be down long enough for a backup to be completed. If you are in a 24x7 operation (as we are) determine the least active time for the database and schedule backups at that time. Our backup to an 8mm drive only takes about 10-15 minutes to complete. > > Are there any manuals that address this issue? I have the Informix-SE > Administrator's Guide, Version 7.2 and the section on backups is very > sparse (3 sentences, to be exact!) Check out the Administrator's guide for your UNIX system and use the back up methods they reccommend. We currently use cpio. -- Cassandra Baldassano cassie@nas.nasa.gov Sterling Software (650) 604-6007 or (800) 331-8737 x6007 Supporting: M/S 258-6 Systems Control NASA Ames Research Center Database Administration Moffett Field, CA 94305-1000 *********************************************************************** Of all the things I've lost, I miss my mind the most.