RE: How to moving DB to new disks/controller

Wayne, Your first plan should work great, but I would suggest a few additions. I have performed these tasks successfully many times. 1-Do the dbexport anyway. Preferably to disk--- tapes are so slow. There may be issues depending on the size of database/tables you are working with and your OS limitations. Plan for the worst and it just might not happen. 2-I have used ontape due to its simplicity. It is normally fast as it is just a glorified "dd" of the pages that are used. If your database is over 2 gig, just use links on the filesystem to store the level 0. - -tapes... I don't trust them either, unless I must... I have 0 knowledge of onbar. 3-Follow your other task. Keep in mind that the show stopper is data placement on devices. If you don't need to change (really consider this as your IO performance issues could be due to database layout) then the first option is the way to go. If you need to optimize the table layout/extent sizing, then the export/import would be the best way to go. If you need to perform the import and change the location/extent sizing of tables and indexes , let me know. I think I could dig up a script that will parse a dbexport's SQL file and insert information for location, first extent, and next extent. mac- -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Wayne Trieu Sent: Wednesday, November 17, 1999 5:05 PM To: informix-list@iiug.org Subject: How to moving DB to new disks/controller Hi all, Currently our database is on Veritas RAID5, we experience I/O problem slow on this RAID5 (many users from this group also recommended go for RAID10). So we are going to switch our database to hard RAID10 (thanks all those who have help me before). Anyway, I never done this kind of database move before, if you have any suggestion please let me know. If is possible can you give me step by step to do it, I would appreciated. Here is my two plans and don't know which one is the best choices: Choice 1: a) Do full backup using ontape and onbar b) On the new controller RAID10 partition all dbspace/chucks same size as original. c) Unlink dbspace from old disk and relink all dbspace to new disk space. d) Cold restored from the backup tape Choice 2: a) Do full backup in case need it to restore. b) I don't with tool is the best to used "onload or dbexport". using onunload or dbexport to load all databases to tape Can you some give me example of parameter I should be use. c) Created all new dbspace/chucks (rootdbs, datadbs, tempdbs llogbds.....etc). d) "oninit -i" to created new instance on new controller. c) Import the data back. using "onload" or "dbimport" Please give me example of parameter. Well, I guess this be it for the questions. If you have any comments or suggestions I would be very appreciated. Thank you all in adavance. -- Wayne Sent via Deja.com http://www.deja.com/ Before you buy.