RE: DBEXPORT question
Posted in 1997
Topics: Performance & Tuning, Storage & Space Management, Migration, Import/Export & Data Conversion, Jobs, Consulting & Announcements
Hi Kerry, If you are using RAID 5 there is no sense to create more than one dbspace for data because all the data is written in all five disks and you can't control it. About the temp dbspace, you should consider don't use the RAID 5 to store it because I think the RAID is too expensive and you don't need its high availability to protect the temp area . And the last but not the least, you should have at least 32 Mb of RAID cache if you don't want to have bad performance in the writing operations. Regards, Ivan ---------- De: Kerry[SMTP:dino@ix.netcom.com] Enviada em: Sabado, 21 de Junho de 1997 11:46 Para: informix-list@rmy.emory.edu Assunto: DBEXPORT question Greetings! We are running a 5 spindle RAID Level 5 with Fast/Narrow SCSI. The data and parity are spread over the 5 drives. We have been told that we should create more than one DBSPACE for data AND for TEMP. The current problem is that we are DBEXPORT'ing from a single dbspace database in Version 5.03. Can we divide that out and DBIMPORT to multiple dbspaces on the Version 7.21 platform? Thanks! Kerry Kerry Davids Client: 414-751-1835 E-mail: dino@ix.netcom.com Sr. Consultant Pager: 888-360-5739 Pager E-mail: 0880955@pagenet.net