Migrating databases

I am in the process of migrating our databases from our IBM ESS to a new IBM DS4800. As we are 24x7 minimizing downtime is important. Based on past posts I decided to use the mirroring approach to moving the data: mirror all the dbspaces to the new drives, take the engine offline, rename the chunks, bring the instance back on line and break the mirrors. My practice attempts all seemed to go well and I didn't run into any issues, but I was wondering if anyone had actually used this methodology in the past and had some opinions as to why I should or should not use this approach. Any insight would be appreciated. AIX 5.3 & IDS 9.40.FC7 AIX 5.2 & IDS 9.40.FC2 Thanks, Dan _________________________________________________________________ Try Search Survival Kits: Fix up your home and better handle your cash with Live Search! http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US &source=hmtagline

A methodology I've recommended many times. Works great. Art S. Kagel ----- Original Message ----- From: Daniel Hunt <ids@iiug.org> At: 11/06 13:01:01 I am in the process of migrating our databases from our IBM ESS to a new IBM DS4800. As we are 24x7 minimizing downtime is important. Based on past posts I decided to use the mirroring approach to moving the data: mirror all the dbspaces to the new drives, take the engine offline, rename the chunks, bring the instance back on line and break the mirrors. My practice attempts all seemed to go well and I didn't run into any issues, but I was wondering if anyone had actually used this methodology in the past and had some opinions as to why I should or should not use this approach. Any insight would be appreciated. AIX 5.3 & IDS 9.40.FC7 AIX 5.2 & IDS 9.40.FC2 Thanks, Dan _________________________________________________________________ Try Search Survival Kits: Fix up your home and better handle your cash with Live Search! http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US &source=hmtagline ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Paul - I have dual fiber paths into the ESS. We take one of the paths and attach it to the switches connecting the ds4800. So the server has a path to both farms. The mirroring across the paths leaves the original database on the ESS and creates the mirrors on the ds4800. Perhaps I was unclear, the server itself will not change, just the farm where the databases reside. Does that make any more sense? Dan >From: "Paul Watson" <paul@oninit.com> >Reply-To: <paul@oninit.com> >To: <dph00@hotmail.com> >Subject: RE: Migrating databases [7740] >Date: Mon, 6 Nov 2006 12:15:13 -0600 > >Daniel > >I don't see how this will get you onto the new server. An alternate is to >use ER, replicate the system, move all the users over, break the >replication > >Cheers >Paul > >Paul Watson >Tel: +44 1414161772 >Mob: +44 7818003457 >Web: www.oninit.com > >GO FURTHER with DB2 >GET THERE FASTER with Informix. >Attend IDUG 2007 San Jose, North America >May 6-10, 2006 >Visit http://www.iiug.org/conf for more information. > > > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > > Behalf Of Daniel Hunt > > Sent: 06 November 2006 11:52 > > To: ids@iiug.org > > Subject: Migrating databases [7740] > > > > > > I am in the process of migrating our databases from our IBM > > ESS to a new IBM DS4800. As we are 24x7 minimizing downtime > > is important. Based on past posts I decided to use the > > mirroring approach to moving the data: mirror all the > > dbspaces to the new drives, take the engine offline, rename > > the chunks, bring the instance back on line and break the > > mirrors. My practice attempts all seemed to go well and I > > didn't run into any issues, but I was wondering if anyone had > > actually used this methodology in the past and had some > > opinions as to why I should or should not use this approach. > > Any insight would be appreciated. > > > > AIX 5.3 & IDS 9.40.FC7 > > AIX 5.2 & IDS 9.40.FC2 > > > > Thanks, > > Dan > > > > _________________________________________________________________ > > Try Search Survival Kits: Fix up your home and better handle > > your cash with Live Search! > > > > http://imagine-windowslive.com/search/kits/default.aspx?kit=im >prove&locale=en-US&source=hmtagline > > > > > > ************************************************************** > > ***************** > > Forum Note: Use "Reply" to post a response in the > > discussion forum. > _________________________________________________________________ Stay in touch with old friends and meet new ones with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces. live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us

Thanks Art and Paul for your input. The whole process makes so much sense and works so smoothly I was struck with a sudden feeling of "can it really be this easy?" Dan _________________________________________________________________ Add a Yahoo! contact to Windows Live Messenger for a chance to win a free trip! http://www.imagine-windowslive.com/minisites/yahoo/default.aspx?locale=en-us&hmt agline