Re: What's issue that we have to concern if we want to implement HDR

I recently implemented HDR with Informix DS 7.30 UC5/7 on HP-UX 10.20. I encountered 3 problems: 1) I couldn't use tape drive on remote hosts to do cold restore with onarchive (fo first installation of HDR); 2) HDR impose additional locks for building indexes on primary server. To avoid errors like -244 you need use SET LOCK MODE TO WAIT n for all sessions that modify data. 3) Informix Admin Guide says that if you use asynchronous mode of HDR anddatabase with unbuffered log, all data modifications will be sent to secondary server after executing of COMMIT statement. But I saw delay equals to DRINTERVAL value (like for database with buffered log) in my case. -- Andrew Svikhnushin Inist Ltd. E-mail: san@inist.ru Korbsin Jaroonjetjumnong <KorbsinJ@tac.co.th> wrote in message news:7lbup2$hqt$1@news.xmission.com... > > > > Dear all... > > > > We have a plan to implement HDR in the next year. > > Our system is SUN E6000 (8CPU and 2 GB Mem) on INFORMIX7.31 UC2 and > > SOLARIS2.6. > > Database size now is about 80-100GB > > Now We are in the Feasibility Study and Testing phase to make sure > > that no significant factor that effected the performance of overall system > > after we have up HDR to production. > > Can anyone give me some suggestion , recommendation cases or issues > > that we should concern or some scenario that we should test it before , > > and How to avoid the problem that may be occured? > > > > Best Regards > > Korbsin J.