RE: ER and inplace upgrade 7.31 to 9.40

Posted in 2004

Colin Bull — Fri, 15 Oct 2004 08:57:44 +0100 — source: Usenet: comp.databases.informix

=20 =20Andrew=20Hamm=20wrote >=20Hi=20folks >=20 >=20I=20need=20to=20upgrade=207.31=20to=209.40=20on=20servers=20which=20pa= rtake=20in=20 >=20Enterprise=20Replication.=20We=20did=20a=20test=20server,=20and=20it=20= barfed=20 >=20because=20of=20a=20few=20things: >=20 >=201)=20needs=20new=20parameters=20in=20$ONCONFIG=20(minor,=20could=20hav= e=20 >=20avoided=20this=20with=20a=20bit=20of=20RTFM=20on=20the=20release=20not= es) >=20 >=202)=20lack=20of=20new=20attached=20sbspaces=20caused=20cryptic=20but=20= total=20 >=20failure.=20It=20appears=20that=20the=20sbspaces=20MUST=20be=20attached= =20to=20run=20ER? >=20 >=20We=20have=20a=20production=20server=20to=20upgrade=20next,=20so=20it=20= must=20go=20 >=20smoothly.=20The=20first=20one=20was=20a=20bit=20of=20a=20hunt-the-snar= k=20 >=20exercise=20to=20find=20out=20what=20was=20screwing=20up=20so=20it's=20= hard=20to=20 >=20draw=20simple=20rules=20after=20all=20the=20tail-chasing=20and=20confu= sion. >=20 >=20Basically,=20what's=20an=20effective=20ritual=20for=20this=20upgrade? >=20 >=20Is=20it=20true=20that=20the=20new=20sbspaces=20must=20exist?=20The=20E= R=20guide=20for=20 >=209.40=20says,=20on=20page=204-14, >=20 >=20Important:=20Before=20starting=20Enterprise=20Replication,=20you=20mus= t=20 >=20create=20at=20least=20one=20sbspace=20for=20spooled=20row=20data=20and= =20set=20the=20 >=20CDR_QDATA_SBSPACE=20configuration=20parameter=20to=20its=20location. >=20 Lot=20snipped=20.... We=20had=20a=20problem=20with=20LOCALES=20and=20syscdr.=20In=20the=20end=20= we=20found=20it=20easiest and=20safest=20to=20- Stop=20replication.=20Remove=20syscdr=20database. Move=20to=209.4 Create=20new=20sbspace=20for=20CDR_QDATA_SBSPACE=20and=20SBSPACENAME=20(=20= same=20space) When=209.4=20was=20ready=20to=20roll,=20redefine=20ER=20servers=20and=20re= plicates. Colin=20Bull ________________________________________________________________________ This=20email=20has=20been=20scanned=20for=20all=20known=20viruses=20by=20t= he=20MessageLabs=20Email Security=20System. ________________________________________________________________________ sending to informix-list