Re.replication

Posted in 2003

Topics: High Availability & Replication, Storage & Space Management, SQL Development & Query Writing

Sushil Shirodkar — Wed, 07 May 2003 13:11:22 — source: IIUG Forums & Mailing Lists

Hi, In case of HDR do we have to have the same chunk paths and same size on primary as well as secondary server, I can understand that we need to have same dbspaces. Thanks in advance. Sushil... _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

↪ replying to Sushil Shirodkar

rkusenet — Wed, 07 May 2003 13:38:08 — source: IIUG Forums & Mailing Lists

Yes. Chunk paths and size , as given in the onspaces command got to be same. In fact you can not give onspaces command on the secondary server. You give it on the primary server and the secondary server automatically creates it. The only luxury you have is to create a link to the path the way you want it. As long as the path given in onspaces is a valid one, Informix will not complain. To give an e.g. On Primary server /ifmx/dbs54 may be a link to /dev/rdsk54 (raw disk) On secondary server /ifmx/dbs54 may be a link to /usr/informixdata/dbs54 (cooked file). onspaces -c -d dbspace54 -p /ifmx/dbs54 -o 0 -s 2048000 This will work. Ravi ----- Original Message ----- From: "Sushil Shir...." <sushilps@hotmail.com> To: <ids@iiug.org> Sent: Wednesday, May 07, 2003 09:11 Subject: Re.replication [1089] > Hi, > > In case of HDR do we have to have the same chunk paths and same size on > primary as well as secondary server, I can understand that we need to have > same dbspaces. > > > Thanks in advance. > Sushil... > > _________________________________________________________________ > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > >

↪ replying to Sushil Shirodkar

Madison Pruet — Wed, 07 May 2003 14:11:56 — source: IIUG Forums & Mailing Lists

Yes, the chunks will need to exist on the secondary with the same path names. However, the path names can be links. "Sushil Shir...." <sushilps@hotmail To: ids@iiug.org .com> cc: Sent by: Subject: Re.replication [1089] forum.subscriber@ iiug.org 05/07/2003 08:11 AM Hi, In case of HDR do we have to have the same chunk paths and same size on primary as well as secondary server, I can understand that we need to have same dbspaces. Thanks in advance. Sushil... _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

↪ replying to Sushil Shirodkar

Sushil Shirodkar — Wed, 07 May 2003 18:11:24 — source: IIUG Forums & Mailing Lists

Thanks Guys(Sonkin,Ravi,Keith,Pruet), Sushil... >From: Madison Pruet <mpruet@us.ibm.com> >To: "Sushil Shir...." <sushilps@hotmail.com> >CC: forum.subscriber@iiug.org, ids@iiug.org >Subject: Re: Re.replication [1089] >Date: Wed, 7 May 2003 09:07:08 -0500 >MIME-Version: 1.0 >Received: from e35.co.us.ibm.com ([32.97.110.133]) by >mc9-f16.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 7 May >2003 07:09:20 -0700 >Received: from westrelay01.boulder.ibm.com (westrelay01.boulder.ibm.com >[9.17.195.10])by e35.co.us.ibm.com (8.12.9/8.12.2) with ESMTP id >h47E9JuT262860;Wed, 7 May 2003 10:09:19 -0400 >Received: from d03nm800.boulder.ibm.com (d03av03.boulder.ibm.com >[9.17.193.83])by westrelay01.boulder.ibm.com (8.12.9/NCO/VER6.5) with ESMTP >id h47E9IGs083078;Wed, 7 May 2003 08:09:19 -0600 >X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP >X-Mailer: Lotus Notes Release 5.0.11 July 24, 2002 >Message-ID: ><OF2AD5DC56.0A5E081D-ON86256D1F.004D78D0-86256D1F.004D8EE3@us.ibm.com> >X-MIMETrack: Serialize by Router on D03NM800/03/M/IBM(Release 6.0.1 >[IBM]|April 4, 2003) at 05/07/2003 08:08:07 >Return-Path: mpruet@us.ibm.com >X-OriginalArrivalTime: 07 May 2003 14:09:20.0441 (UTC) >FILETIME=[4101F290:01C314A2] > > > > > >Yes, the chunks will need to exist on the secondary with the same path >names. However, the path names can be links. > > > > "Sushil Shir...." > <sushilps@hotmail To: ids@iiug.org > .com> cc: > Sent by: Subject: Re.replication >[1089] > forum.subscriber@ > iiug.org > > > 05/07/2003 08:11 > AM > > > > > > >Hi, > >In case of HDR do we have to have the same chunk paths and same size on >primary as well as secondary server, I can understand that we need to have >same dbspaces. > > >Thanks in advance. >Sushil... > >_________________________________________________________________ >STOP MORE SPAM with the new MSN 8 and get 2 months FREE* >http://join.msn.com/?page=features/junkmail > > > > > _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

↪ replying to rkusenet

Support Informix — Sat, 10 May 2003 09:00:17 — source: IIUG Forums & Mailing Lists

For ifo : Even in IDS 9.40 you cannot rename a chunk while doing a cold restore for a initial HDR setup. I've tested it. On the "omode -d secondary xxx" command you will get a message in the log as "cannot change mode if renaming chunk" Yves -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: woensdag 7 mei 2003 15:38 To: ids@iiug.org Subject: Re: Re.replication [1090] Yes. Chunk paths and size , as given in the onspaces command got to be same. In fact you can not give onspaces command on the secondary server. You give it on the primary server and the secondary server automatically creates it. The only luxury you have is to create a link to the path the way you want it. As long as the path given in onspaces is a valid one, Informix will not complain. To give an e.g. On Primary server /ifmx/dbs54 may be a link to /dev/rdsk54 (raw disk) On secondary server /ifmx/dbs54 may be a link to /usr/informixdata/dbs54 (cooked file). onspaces -c -d dbspace54 -p /ifmx/dbs54 -o 0 -s 2048000 This will work. Ravi ----- Original Message ----- From: "Sushil Shir...." <sushilps@hotmail.com> To: <ids@iiug.org> Sent: Wednesday, May 07, 2003 09:11 Subject: Re.replication [1089] > Hi, > > In case of HDR do we have to have the same chunk paths and same size on > primary as well as secondary server, I can understand that we need to have > same dbspaces. > > > Thanks in advance. > Sushil... > > _________________________________________________________________ > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > ------_=_NextPart_001_01C3163D.9D5FC020 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Re.replication [1090] </TITLE> </HEAD> <BODY> For ifo : Even in IDS 9.40 you cannot rename a chunk while = doing a cold restore for a initial HDR setup. I've tested it. On the "omode -d secondary xxx" command = you will get a message in the log as "cannot change mode if = renaming chunk" Yves -----Original Message----- From: nobody@ace.iiug.org [<A = HREF=3D"mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>]</FON= T> Sent: woensdag 7 mei 2003 15:38 To: ids@iiug.org Subject: Re: Re.replication [1090] Yes. Chunk paths and size , as given in the onspaces = command got to be same. In fact you can not give onspaces command on = the secondary server. You give it on the primary server and the secondary = server automatically creates it. The only luxury you have is to create a link to the = path the way you want it. As long as the path given in onspaces = is a valid one, Informix will not complain. To give an e.g. On Primary server /ifmx/dbs54 may be a link to = /dev/rdsk54 (raw disk) On secondary server /ifmx/dbs54 may be a link to = /usr/informixdata/dbs54 (cooked file). onspaces -c -d dbspace54 -p /ifmx/dbs54 -o 0 -s = 2048000 This will work. Ravi ----- Original Message ----- From: "Sushil Shir...." = <sushilps@hotmail.com> To: <ids@iiug.org> Sent: Wednesday, May 07, 2003 09:11 Subject: Re.replication [1089] > Hi, > > In case of HDR do we have to have the same = chunk paths and  same size on > primary as well as secondary server, I can = understand that we need to have > same dbspaces. > > > Thanks in advance. > Sushil... > > = _________________________________________________________________= > STOP MORE SPAM with the new MSN 8 and get 2 = months FREE*  > <A = HREF=3D"http://join.msn.com/?page=3Dfeatures/junkmail"; = TARGET=3D"_blank">http://join.msn.com/?page=3Dfeatures/junkmail</A></FON= T> > > > </BODY> </HTML> ------_=_NextPart_001_01C3163D.9D5FC020--

Re.replication

Glossary

Your privacy choices