Droping a replicate column

Posted in 2016

Jorge Valenzuela — Thu, 02 Jun 2016 18:29:14 — source: IIUG Forums & Mailing Lists

Hi, I try to drop a column from a table, and get the 19994 error. This error say I must the column from the replicate definicion before droping the column. Then I remaster the replicated table removing the column from the replication. After that I try to remove the column again and get the 19994 error again. What can I do ? Thanks in advance.

↪ replying to Jorge Valenzuela

Nagaraju Inturi — Fri, 03 Jun 2016 17:45:40 — source: IIUG Forums & Mailing Lists

Check if 'cdr list repl' command show replicate name that starts with=20 "Shadow=5F". If so, you will have to wait till the shadow replicate get=20 deleted. Shadow replicate gets deleted once replay position advance past=20 the log position when you remastered the replicate definition to remove=20 column from replicate definition. You could issue 'onmode -l' and 'onmode=20 -c' at all ER servers if you see ER not advancing replay position. 'onstat = -g ddr' command show replay position. This page has 'drop column' details: =20 https://www.ibm.com/support/knowledgecenter/SSGU8G=5F11.50.0/com.ibm.erep.d= oc/ids=5Ferp=5F247.htm Thanks & Regards, Nagaraju From: "Jorge Valenzuela" <jorgervt@gmail.com> To: ids@iiug.org Date: 06/02/2016 01:29 PM Subject: Droping a replicate column [37214] Sent by: ids-bounces@iiug.org Hi,=20 I try to drop a column from a table, and get the 19994 error.=20 This error say I must the column from the replicate definicion before=20 droping=20 the column.=20 Then I remaster the replicated table removing the column from the=20 replication.=20 After that I try to remove the column again and get the 19994 error again. = What can I do ?=20 Thanks in advance.=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

↪ replying to Nagaraju Inturi

Jorge Valenzuela — Fri, 03 Jun 2016 18:03:20 — source: IIUG Forums & Mailing Lists

Thanks. Yesterday I notice about the Shadow replicate and I delete it. After that, I could drop the column. Is there a problem if I drop the Shadow without wait to get the 20? Enviado desde mi iPhone > El 03/06/2016, a las 10:45 a.m., Nagaraju Inturi <nagaraju@us.ibm.com> escribió: > > Check if 'cdr list repl' command show replicate name that starts with=20 > "Shadow=5F". If so, you will have to wait till the shadow replicate get=20 > deleted. Shadow replicate gets deleted once replay position advance past=20 > the log position when you remastered the replicate definition to remove=20 > column from replicate definition. You could issue 'onmode -l' and 'onmode=20 > -c' at all ER servers if you see ER not advancing replay position. 'onstat = > > -g ddr' command show replay position. > > This page has 'drop column' details: > =20 > https://www.ibm.com/support/knowledgecenter/SSGU8G=5F11.50.0/com.ibm.erep.d= > oc/ids=5Ferp=5F247.htm > > Thanks & Regards, > Nagaraju > > From: "Jorge Valenzuela" <jorgervt@gmail.com> > To: ids@iiug.org > Date: 06/02/2016 01:29 PM > Subject: Droping a replicate column [37214] > Sent by: ids-bounces@iiug.org > > Hi,=20 > > I try to drop a column from a table, and get the 19994 error.=20 > > This error say I must the column from the replicate definicion before=20 > droping=20 > the column.=20 > > Then I remaster the replicated table removing the column from the=20 > replication.=20 > > After that I try to remove the column again and get the 19994 error again. = > > What can I do ?=20 > > Thanks in advance.=20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jorge Valenzuela

Nagaraju Inturi — Mon, 06 Jun 2016 06:24:10 — source: IIUG Forums & Mailing Lists

You may want to verify data across servers using 'cdr check' command. Thanks & Regards, Nagaraju From: "Jorge Valenzuela" <jorgervt@gmail.com> To: ids@iiug.org Date: 06/03/2016 01:04 PM Subject: Re: Droping a replicate column [37217] Sent by: ids-bounces@iiug.org Thanks. Yesterday I notice about the Shadow replicate and I delete it.=20 After=20 that, I could drop the column.=20 Is there a problem if I drop the Shadow without wait to get the 20?=20 Enviado desde mi iPhone=20 > El 03/06/2016, a las 10:45 a.m., Nagaraju Inturi <nagaraju@us.ibm.com>=20 escribi=F3:=20 >=20 > Check if 'cdr list repl' command show replicate name that starts with=3D2= 0=20 > "Shadow=3D5F". If so, you will have to wait till the shadow replicate=20 get=3D20=20 > deleted. Shadow replicate gets deleted once replay position advance=20 past=3D20=20 > the log position when you remastered the replicate definition to=20 remove=3D20=20 > column from replicate definition. You could issue 'onmode -l' and=20 'onmode=3D20=20 > -c' at all ER servers if you see ER not advancing replay position.=20 'onstat =3D=20 >=20 > -g ddr' command show replay position.=20 >=20 > This page has 'drop column' details:=20 > =3D20=20 >=20 https://www.ibm.com/support/knowledgecenter/SSGU8G=3D5F11.50.0/com.ibm.erep= .d=3D=20 > oc/ids=3D5Ferp=3D5F247.htm=20 >=20 > Thanks & Regards,=20 > Nagaraju=20 >=20 > From: "Jorge Valenzuela" <jorgervt@gmail.com>=20 > To: ids@iiug.org=20 > Date: 06/02/2016 01:29 PM=20 > Subject: Droping a replicate column [37214]=20 > Sent by: ids-bounces@iiug.org=20 >=20 > Hi,=3D20=20 >=20 > I try to drop a column from a table, and get the 19994 error.=3D20=20 >=20 > This error say I must the column from the replicate definicion before=3D2= 0=20 > droping=3D20=20 > the column.=3D20=20 >=20 > Then I remaster the replicated table removing the column from the=3D20=20 > replication.=3D20=20 >=20 > After that I try to remove the column again and get the 19994 error=20 again. =3D=20 >=20 > What can I do ?=3D20=20 >=20 > Thanks in advance.=3D20=20 >=20 >=20 ***************************************************************************= =3D=20 > ****=3D20=20 >=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=3D20 = >=20 >=20 >=20 ***************************************************************************= ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

↪ replying to Nagaraju Inturi

Jorge Valenzuela — Mon, 06 Jun 2016 13:34:01 — source: IIUG Forums & Mailing Lists

Thanks very much. Enviado desde mi iPhone > El 05/06/2016, a las 11:24 p.m., Nagaraju Inturi <nagaraju@us.ibm.com> escribió: > > You may want to verify data across servers using 'cdr check' command. > > Thanks & Regards, > Nagaraju > > From: "Jorge Valenzuela" <jorgervt@gmail.com> > To: ids@iiug.org > Date: 06/03/2016 01:04 PM > Subject: Re: Droping a replicate column [37217] > Sent by: ids-bounces@iiug.org > > Thanks. Yesterday I notice about the Shadow replicate and I delete it.=20 > After=20 > that, I could drop the column.=20 > > Is there a problem if I drop the Shadow without wait to get the 20?=20 > > Enviado desde mi iPhone=20 > >> El 03/06/2016, a las 10:45 a.m., Nagaraju Inturi <nagaraju@us.ibm.com>=20 > escribi=F3:=20 >> =20 >> Check if 'cdr list repl' command show replicate name that starts with=3D2= > 0=20 > >> "Shadow=3D5F". If so, you will have to wait till the shadow replicate=20 > get=3D20=20 >> deleted. Shadow replicate gets deleted once replay position advance=20 > past=3D20=20 >> the log position when you remastered the replicate definition to=20 > remove=3D20=20 >> column from replicate definition. You could issue 'onmode -l' and=20 > 'onmode=3D20=20 >> -c' at all ER servers if you see ER not advancing replay position.=20 > 'onstat =3D=20 >> =20 >> -g ddr' command show replay position.=20 >> =20 >> This page has 'drop column' details:=20 >> =3D20=20 >> =20 > https://www.ibm.com/support/knowledgecenter/SSGU8G=3D5F11.50.0/com.ibm.erep= > ..d=3D=20 > >> oc/ids=3D5Ferp=3D5F247.htm=20 >> =20 >> Thanks & Regards,=20 >> Nagaraju=20 >> =20 >> From: "Jorge Valenzuela" <jorgervt@gmail.com>=20 >> To: ids@iiug.org=20 >> Date: 06/02/2016 01:29 PM=20 >> Subject: Droping a replicate column [37214]=20 >> Sent by: ids-bounces@iiug.org=20 >> =20 >> Hi,=3D20=20 >> =20 >> I try to drop a column from a table, and get the 19994 error.=3D20=20 >> =20 >> This error say I must the column from the replicate definicion before=3D2= > 0=20 > >> droping=3D20=20 >> the column.=3D20=20 >> =20 >> Then I remaster the replicated table removing the column from the=3D20=20 >> replication.=3D20=20 >> =20 >> After that I try to remove the column again and get the 19994 error=20 > again. =3D=20 >> =20 >> What can I do ?=3D20=20 >> =20 >> Thanks in advance.=3D20=20 >> =20 >> =20 > ***************************************************************************= > =3D=20 > >> ****=3D20=20 >> =20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=3D20 = > >> =20 >> =20 >> =20 > ***************************************************************************= > ****=20 > >> Forum Note: Use "Reply" to post a response in the discussion forum.=20 >> =20 > > ***************************************************************************= > ****=20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >