Re: Dynix/ptx SVM & Informix 5.X

At 06:09 PM 1/19/97 -0800, you wrote: >> >>Hi There, >> >>We will in near future upgrade our 2000/450 to a SE30, and will within >>the upgrade receive SVM. >> >>We run a 24x7 application on Informix 'raw' partitions, with Informix 5.X. >>The >>database is approx. 4 GB, with 2/3 data used once a day, and the 1/3 data >>used very frequently. >> >>We are evaluating to put Informix 'raw' partitions under SVM control, >>and wants to hear if anyone has experince with an exercise like that? Tim - We've been running on Sequent for over 7 years, most of which has been using SVM to manage physical disk configs. Informix has been running, with SVM underneath, successfully for years. We currently have a 150GB Batch host, and 90GB OLTP 24x7 host, both using SVM. SVM in my humble opion, is the only way to go....provides flexibility, reliability, with very little performance impact. If you plan to mirror, I suggest using SVM, not Informix. >>We especially want to use SVM to stribe a heavily utilised database space >>in Informix in blocks down to 4K !! - Any comments on that ? We have not used SVM in striping configurations, mostly because of recovery issues. I have considered for hot spots like logical log, but haven't tested yet. One word of caution, be very carefull in determining your stripe width, performance with striping and Informix, can go to h*ll in heartbeat. I seem to recall that a stripe width of 16K was good for Informix, but I'd talk with Sequent and/or Informix for there input before doing anything. Hope this helps. If you want more info or input, let me know. Jon ----------------------------------------------------------------------- Jon C. Vemo jon@etcscan.com Database Administration jvemo@cyberspace.com SCAN/Deluxe Payment Protection Systems, Inc. -----------------------------------------------------------------------