Our IDS V7.3.TC3 NT4 (RAID5) environment is setup to perform a nightly
level 0 Informix backup to a disk-file which is then saved to tape via 3rd
party backup software. Transaction logs are continuously copied to tape
throughout the day.
I would like to create, and automate a procedure that daily restores the
level 0 backup onto another inquiry-only server. By the way, replication
has been ruled out as an option due to the negative aspects placed upon the
production server. Some thoughts would be to first perform a manual
initial Informix db environment load from the production server's level 0
backup on the inquiry-only server. From that point forward, I would want
to automate a procedure to execute the same reload daily. This process
might include copying the level 0 backup (currently 7+ GB) across the
network to the inquiry-only server at night, and executing a scheduled
UNIX-type of script (utilizing ONTAPE or ONBAR?). Is this possible to
automate? If so, how? Any examples, or other ideas would be very helpful
since I am relatively new to the Informix environment. I can be reached at
jhimschoot@crowechizek.com. Thanks for your time.