Re: OnLine on Pyramid MIServer

> Anyone running Informix OnLine on Pyramid MIServer wih multiple processors ? > Yes > 1) > > If so have you tried to make use of the MIServers ability to schedule jobs > on different processors, this feature could be used for instance, to run > 4 concurrent dbloads of 250,000 records each instead of running one dbload > of 1,000,000 records, offcourse expecting a performance benefit of the > concurrent loads vs. the single load. > Yes, works fine. > 2) > > Have anyone tried to use logical disks ( spanning several physical > disks) as raw devices for OnLine. We expect that this could speed up writes > from shared memory to the disk. We fear though that you migth loose control > over when data actually is comitted to the disc. > Yes, works fine. We use disk stripeing of various physical disks into one logical disk to improve performance. The problem with committed data doesn't really exist as Online writes disk pages at checkpoints which may be later than the commit anyway. It is only important that your logs have been written to do the recovery. In any case a logical disk write is in this case no different to a normal disk write. In fact you should always use logical names not physical names so that in the event of a disk crash you can recover by giving a different physical drive the same logical name. > regards > -- > Ole Skanning Cheers Jim -------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 358-5911 (Work) Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home) San Mateo, CA 94402 Fax: (415) 571-6429 --------------------------------------------------------------------