Re: ER out of sync
informix-list-bounces@iiug.org wrote on 11/15/2010 06:46:33 AM:
> From:
>
> Cveja <nikomah@gmail.com>
>
> To:
>
> informix-list@iiug.org
>
> Date:
>
> 11/15/2010 06:50 AM
>
> Subject:
>
> Re: ER out of sync
>
> Sent by:
>
> informix-list-bounces@iiug.org
>
> On Nov 12, 7:51 pm, "Jonny...@Usenet-News.net" wrote:
> > Can you on the standby server do dbaccess / connect
> > / "Standy instance" using any of the
> > DBSERVERNAME / DBSERVERALIAS / group name
> > (obviously TCP connections only)
>
> It was possible to connect using dbaccess, and
> that was the clue that lead us to the solution.
> Thanks.
>
> I must admit it was kind of a beginner's mistake.
> We didn't use -c option for connection to the other node
> explicitly, and the wrong user was invoking the commands.
>
>
>
> On a related topic, regarding usage of cdr check repl, when the
> tables
> have large number of rows, the processing obviously takes significant
> amount
> of time. We tested table with 180k records and cdr check took 4
> minutes
> to finish.
>
> Does this command make significant impact on IDS when executed on
> large
> tables? We're planning to make a script that invokes cdr check repl
> which
> cron job would call in defined intervals, so our concern is how the
> IDS will
> handle that.
>
Definitely there will be some impact as cdr check repl has to read all the
rows from the
table on source and target to identify inconsistent rows. You could improve
the
performance of cdr check repl by using ifx_replcheck shadow column. Create
the shadow
column and then define unique index using primary key and ifx_replcheck
column.
cdr check repl will use this index to perform speedy consistency check.
More details --
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.erep.doc/ids_erp_526.htm
>
>
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
On Nov 16, 8:19 pm, Nilesh Ozarkar <nile...@us.ibm.com> wrote:
> informix-list-boun...@iiug.org wrote on 11/15/2010 06:46:33 AM:
>
>
>
> > From:
>
> > Cveja <niko...@gmail.com>
>
> > To:
>
> > informix-l...@iiug.org
>
> > Date:
>
> > 11/15/2010 06:50 AM
>
> > Subject:
>
> > Re: ER out of sync
>
> > Sent by:
>
> > informix-list-boun...@iiug.org
>
> > On Nov 12, 7:51 pm, "Jonny...@Usenet-News.net" wrote:
> > > Can you on the standby server do dbaccess / connect
> > > / "Standy instance" using any of the
> > > DBSERVERNAME / DBSERVERALIAS / group name
> > > (obviously TCP connections only)
>
> > It was possible to connect using dbaccess, and
> > that was the clue that lead us to the solution.
> > Thanks.
>
> > I must admit it was kind of a beginner's mistake.
> > We didn't use -c option for connection to the other node
> > explicitly, and the wrong user was invoking the commands.
>
> > On a related topic, regarding usage of cdr check repl, when the
> > tables
> > have large number of rows, the processing obviously takes significant
> > amount
> > of time. We tested table with 180k records and cdr check took 4
> > minutes
> > to finish.
>
> > Does this command make significant impact on IDS when executed on
> > large
> > tables? We're planning to make a script that invokes cdr check repl
> > which
> > cron job would call in defined intervals, so our concern is how the
> > IDS will
> > handle that.
>
> Definitely there will be some impact as cdr check repl has to read all the
> rows from the
> table on source and target to identify inconsistent rows. You could improve
> the
> performance of cdr check repl by using ifx_replcheck shadow column. Create
> the shadow
> column and then define unique index using primary key and ifx_replcheck
> column.
> cdr check repl will use this index to perform speedy consistency check.
> More details --http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.e...
>
Also, you can include a 'where' clause or 'since' clause in the check
to reduce the number of rows which have to be compared.
>
>
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
On Nov 17, 10:38 am, mpruet <mpru...@verizon.net> wrote: > Also, you can include a 'where' clause or 'since' clause in the check > to reduce the number of rows which have to be compared. On Nov 17, 10:38 am, mpruet <mpru...@verizon.net> wrote: > Also, you can include a 'where' clause or 'since' clause in the check > to reduce the number of rows which have to be compared. I have a question concerning the use of 'since' clause. Let's say I have a script that will call cdr check repl every ten minutes. Each time it uses the last check time for 'since' clause. As I understand it should report the inconsistencies in given time interval. Let's say there are two consecutive reads and in the first one there are problems (some rows are mismatch) and the next one ten minutes later shows no problems. How will the DBA know upon reading the last report that there were some inconsistencies? Is the last read the right one?