RE: Parallel backups in Informix 5.xx

Jacek Q. Why are you taking two backups of Informix? You will get into problems if you try and restore your first level 0 and rollforward the logical logs that were backed up after the second level 0. What you should consider if your overnight window for backups is too small, is to create a number of Informix instances with your database evenly split across these instances. On your primary instance, create synonyms to the tables in the other instances. Your application will therefore not need changed in any way because it is still talking to the one instance and your database and all the tables will _appear_ to be in that instance. You therefore have a number of tbconfig files with a number of "archive devices". HTH --------------------------------------------- All opinions are my own Neil Stevenson nmsteven@eukcumbpo1.unitedkingdom.attgis.com Voice: +44 1236 851218 Fax: +44 1236 457459 --------------------------------------------- ---------- From: blocki To: informix-list Subject: Parallel backups in Informix 5.xx Date: 02 November 1995 13:18 Hi, I need to make a backup of Informix in two copies. Unfortunately it seems my version of Informix (5.03UC1) does not support this feature since it allows for only one definition of tape (archive device). I run two backups one by one but database size grows and it won't be feasible soon. If you have any idea how to solve this problem please write me, my address is blocki@fuw.edu.pl Regards, Jacek Blocki