Re: ontape: bad performance

Obnoxio The Chav wrote: > Tarcisio Gouveia said: >>Recently we changed the hardware, OS and db version. >> >>INFORMIX7.31.FC6X2 DEC-UNIX4.0E to INFORMIX7.31.FD2X2 OSF1 V5.1 >> >> After the change, the backup time was very good taking 3 hours for >> 500 GB in a HP STORAGEWORKS ULTRIUM drive. Any days later the >> performance degradated, now it takes aproximately 4 days during the >> week, and 2 days at weekend. >> >>Where can be the problem ? > > Well, it could be the hardware, OS or db version. And, if the trouble is in the DBMS rather than the OS or HW, it could, conceivably, be the very old archive page problem... I think the current version of IDS 7.31 should be FD6, not FD2 (though FD2 should be better than the previous FC6). Check the performance of the storage system without involving IDS. If that is running slow, you've reduced the problem to one of the OS or the HW. If that runs fast, you've probably reduced the problem to the DB. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/