Automated backup for Online & NT?

Hi, everyone. I was hoping someone might be able to help me out on this one... I work for a software house that creates and implements data warehousing systems. It is a Windows NT 4.x application, that we develop, and all systems use Informix Online DS 7.3 (others that are not are in the process of being upgraded). The database is generally hosted by an NT machine as well. All of the smaller operations have no on-staff DBAs and generally run automated backups at a pre-determined hour. Does anyone know of a way to run an automated backup (tape or other) that would produce the same effects as an 'onstat -s' command? Or, at the very least, a utility that would help the low-maintenance types out? Further, being small locations, they don't want to pay a lot of money for one. I appreciate everyone's time. Shawn Pasco Unique Business Systems Project Manager 310.396.3929 ext. 109 / spasco@unibiz.com

spasco@unibiz.com wrote: > > Hi, everyone. I was hoping someone might be able to help me out on this one... > I work for a software house that creates and implements data warehousing > systems. It is a Windows NT 4.x application, that we develop, and all systems > use Informix Online DS 7.3 (others that are not are in the process of being > upgraded). The database is generally hosted by an NT machine as well. All of > the smaller operations have no on-staff DBAs and generally run automated backups > at a pre-determined hour. Does anyone know of a way to run an automated backup > (tape or other) that would produce the same effects as an 'onstat -s' command? > Or, at the very least, a utility that would help the low-maintenance types out? > Further, being small locations, they don't want to pay a lot of money for one. > I appreciate everyone's time. You can run ontape -s out of a cron script it just has to be fairly intelligent to be able to reply to the ontape prompts and handle problems. You might try using 'expect' to write such a beast. As long as your archive will fit on a single tape or you use a tape library that you can control from inside the script or archive to disk so the script can rename the files as they fill up this is doable. Art S. Kagel