Is there anything that can be tuned in informix that would help with the backup performance of both ontape and onbar?
I have run a test with ontape to a null device on two different servers with the same size database (about 300 GB). On one server (with no users), the entire backup takes approximately 2 hours. On the other server (which is production with users logged in), the first tablespace, aside from the rootdbs took over 2 hours (there are 64 tablespaces).
This is a problem as some backups are taking almost 24 hours to perfom.
I have run a test with ontape to a null device on two different servers with the same size database (about 300 GB). On one server (with no users), the entire backup takes approximately 2 hours. On the other server (which is production with users logged in), the first tablespace, aside from the rootdbs took over 2 hours (there are 64 tablespaces).
This is a problem as some backups are taking almost 24 hours to perfom.