IDS Forum

Re: ER time to define a replicate in 11.50 and....

Posted By: Madison Pruet
Date: Monday, 12 January 2015, at 1:27 p.m.

In Response To: Re: ER time to define a replicate in 11.50 and.... (FRANK)

define repl..... --classic

From: "FRANK" <yunyaoqu@gmail.com>
To: ids@iiug.org
Date: 01/12/2015 12:17 PM
Subject: Re: ER time to define a replicate in 11.50 and.... [34449]
Sent by: ids-bounces@iiug.org

OK. Today, I am able to do a test /verification on this again.

[informix@maggie ER_benchmark]$ onstat -version
Program Name: onstat
Build Version: 12.10.FC4W1X1
Build Number: N028
Build Host: lxvm-l172
Build OS: Linux 2.6.18-128.el5
Build Date: Tue Sep 16 15:07:24 CDT 2014
Build Timestamp: 16-Sep-2014.14:53:46UTC-05
GLS Version: glslib-6.00.FC4

Command file:
[informix@maggie ER_benchmark]$ more define_ds_head_repl

date

cdr define replicate --conflict=3Dignore --ats --ris my_ds_head_repl \

"noaa@g_nsofops:informix.my_ds_head" "select * from my_ds_head" \

"noaa@g_ncdcops:informix.my_ds_head" "select * from my_ds_head" \

"noaa@g_ngdcops:informix.my_ds_head" "select * from my_ds_head"
date

Running output and time:
[informix@maggie ER_benchmark]$ time define_ds_head_repl
Mon Jan 12 17:57:15 UTC 2015
Interpreting this replicate as a master replicate.
Verification of noaa@g_nsofops:informix.my_ds_head started
Verification of noaa@g_nsofops:informix.my_ds_head is successful
Verification of noaa@g_ncdcops:informix.my_ds_head started
Verification of noaa@g_ncdcops:informix.my_ds_head is successful
Verification of noaa@g_ngdcops:informix.my_ds_head started
Verification of noaa@g_ngdcops:informix.my_ds_head is successful
Mon Jan 12 17:57:56 UTC 2015
real 0m41.826s
user 0m5.075s
sys 0m0.173s

You can see "cdr define repl " command takes more than 40 seconds . It
only took a 2 or 3 seconds in 11.50.

Seems the new table verification process takes time (which is not neede=
d
in 11.50 ?)

Can the verification process be disabled ? or other options ? ( we have=

hundred of tables which could save huge time)

Yes. all other types of connections( dbaccess ...) are running very fas=
t
.. Actually this is the same environment we used for 11.50 which run al=
l
fast.

Thanks
Frank

On Tue, Nov 25, 2014 at 3:07 PM, FRANK <yunyaoqu@gmail.com> wrote:

> Fernando,
> I should be able to answer the questions next , the env now is change=
d
> and need setup again.
>
> Thanks for your response, will verify all things and let you know nex=
t.
>
> Thanks
> Frank
>
>
> On Tue, Nov 25, 2014 at 2:43 PM, Fernando Nunes <domusonline@gmail.co=
m>
> wrote:
>
>> When you say it's fast to connect I assume you tried from the server=

>> running 12.10. Is this correct?
>> And if you try to connecto to that server (12.10) and then do a remo=
te
>> query to the other servers? Fast?
>> Finally, did you change anything in your resolver configuration
recently?
>> (/etc/nsswitch.con , /etc/resolv.conf etc.)
>>
>> --089e013a213ef5e04f0508b42013
>>
>>
>>
>>
***********************************************************************=
********

>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>

--089e0149d2dcbaaec2050c788230

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• ER time to define a replicate in 11.50 and 12.10
  FRANK -- Tuesday, 25 November 2014, at 11:22 a.m.
  • RE: ER time to define a replicate in 11.50 and 12.
    Alexandre Marini -- Tuesday, 25 November 2014, at 11:58 a.m.
    • Re: ER time to define a replicate in 11.50 and....
      FRANK -- Tuesday, 25 November 2014, at 12:29 p.m.
  • Re: ER time to define a replicate in 11.50 and 12.
    Madison Pruet -- Tuesday, 25 November 2014, at 12:40 p.m.
    • Re: ER time to define a replicate in 11.50 and....
      FRANK -- Tuesday, 25 November 2014, at 1:00 p.m.
      • Re: ER time to define a replicate in 11.50 and....
        Fernando Nunes -- Tuesday, 25 November 2014, at 2:43 p.m.
        • Re: ER time to define a replicate in 11.50 and....
          FRANK -- Tuesday, 25 November 2014, at 3:07 p.m.
        • Re: ER time to define a replicate in 11.50 and....
          FRANK -- Monday, 12 January 2015, at 1:16 p.m.
          • Re: ER time to define a replicate in 11.50 and....
            Madison Pruet -- Monday, 12 January 2015, at 1:27 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.