IDS Forum

RE: Primary Slowness when RSS is active

Posted By: Madison Pruet
Date: Wednesday, 20 October 2010, at 6:23 p.m.

In Response To: RE: Primary Slowness when RSS is active (Jeff Filippi)

Sorry for not replying earlier.

I'll really need to get access to the server to figure out anything
further. Are you going to be at IOD? Would it be possible to get access
to the machine while there?

M.P.

From: "Jeff Filippi" <iiug@itdataconsulting.com>

To: ids@iiug.org

Date: 10/19/2010 12:02 PM

Subject: RE: Primary Slowness when RSS is active [21764]

Sent by: ids-bounces@iiug.org

Yes I set it on the primary.

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Madison Pruet
Sent: Tuesday, October 19, 2010 12:35 PM
To: ids@iiug.org
Subject: RE: Primary Slowness when RSS is active [21761]

Did you set it on the primary? It's the primary that controls throttling.

From: "Jeff Filippi" <iiug@itdataconsulting.com>

To: ids@iiug.org

Date: 10/19/2010 10:31 AM

Subject: RE: Primary Slowness when RSS is active [21758]

Sent by: ids-bounces@iiug.org

Hi Madison,

I applied a patch with the RSS_FLOW_CONTROL.

I tested it with the following settings, dynamically changing it during the

test:

RSS_FLOW_CONTROL 10000K,9000K

RSS_FLOW_CONTROL 0

RSS_FLOW_CONTROL -1

I am still seeing the issue of the primary being throttled by the RSS.
Even after my test finished to clear the backlog on the primary to be
applied on the RSS instance, it was taking 3 minutes 15 seconds for the RSS

to apply each logical log which were 50 mg each.

I did another test where I setup a primary and RSS instance on the same
server.
I ran the exact same test and there was no issue, the RSS kept up and
primary performance was fast, filling a 50 mg logical log in 10 seconds.

Are there any network settings that you know of that could cause the issue?

The network that we are using has a 100 ms latency.

Any other suggestions?

Thanks, Jeff

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Madison Pruet
Sent: Tuesday, October 12, 2010 4:34 PM
To: ids@iiug.org
Subject: RE: Primary Slowness when RSS is active [21662]

xC8

From: "Jeff Filippi" <iiug@itdataconsulting.com>

To: ids@iiug.org

Date: 10/12/2010 03:59 PM

Subject: RE: Primary Slowness when RSS is active [21660]

Sent by: ids-bounces@iiug.org

Hi Madison,

Next release being Panther or 11.50FC8?

Is there any way to get around the issue with the current version?

Thanks, Jeff

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Madison Pruet
Sent: Tuesday, October 12, 2010 3:51 PM
To: ids@iiug.org
Subject: Re: Primary Slowness when RSS is active [21658]

We've put in code in for the next release to allow the customer to define
the limits set for flow control. I suspect that will address your issue.

From: "Jeff Filippi" <jeff.filippi@itdataconsulting.com>

To: ids@iiug.org

Date: 10/12/2010 03:48 PM

Subject: Primary Slowness when RSS is active [21657]

Sent by: ids-bounces@iiug.org

Has anyone saw the following issue.

Informix 11.50FC7W1

AIX 6.1

I was doing some performance tests with a Primary instance and an RSS
instance.

Ran 7 load jobs to create logical log activity.

When RSS was connected, logical logs were filling every 3 minutes on
primary.

When RSS was shutdown, logical logs were filling ever 10 seconds on
primary.

No matter how many load processes I ran with RSS enabled, I was filling a
logical log every 3 minutes.

I saw this APAR IC67072 and IBM Informix support said it was fixed in FC7,
even though it looks to be the same issue I am having.

IC67072: RSS LOG SHIPPING FLOW CONTROL CONTRADICTING THE ASYNCHRONOUS RSS
MODEL

........ APAR statusOPEN

........Error description With log intense DML (insert/update/delete)
activity
on

the

primary, slow log transmission to an RSS secondary can slow down

the primary DML dramatically.

........APAR InformationAPAR numberIC67072

Reported component nameIFMX SPATIAL DB

Reported component ID5724C6100

Reported release820

StatusOPEN

Submitted date2010-03-10

Closed date

Last modified date2010-06-16

Thanks, Jeff

Jeffrey J. Filippi

Integrated Data Consulting, LLC

104 Cottonwood Dr.

Streamwood, IL 60107

630-842-3608

630-497-1762 (Fax)

jeff.filippi@itdataconsulting.com

www.itdataconsulting.com

IBM BUSINESS PARTNER

Cert-Info-Mgmt_color

****************************************************************************

***

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

****************************************************************************

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

****************************************************************************

***

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

****************************************************************************

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

****************************************************************************

***

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

****************************************************************************

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

*******************************************************************************

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

Messages In This Thread

• Primary Slowness when RSS is active
  Jeff Filippi -- Tuesday, 12 October 2010, at 4:47 p.m.
  • Re: Primary Slowness when RSS is active
    Madison Pruet -- Tuesday, 12 October 2010, at 4:50 p.m.
    • Re: Primary Slowness when RSS is active
      Madison Pruet -- Tuesday, 12 October 2010, at 4:54 p.m.
    • RE: Primary Slowness when RSS is active
      Jeff Filippi -- Tuesday, 12 October 2010, at 4:59 p.m.
      • RE: Primary Slowness when RSS is active
        Madison Pruet -- Tuesday, 12 October 2010, at 5:33 p.m.
        • RE: Primary Slowness when RSS is active
          Jeff Filippi -- Tuesday, 19 October 2010, at 12:31 p.m.
          • RE: Primary Slowness when RSS is active
            Madison Pruet -- Tuesday, 19 October 2010, at 1:35 p.m.
            • RE: Primary Slowness when RSS is active
              Jeff Filippi -- Tuesday, 19 October 2010, at 1:56 p.m.
              • RE: Primary Slowness when RSS is active
                Madison Pruet -- Wednesday, 20 October 2010, at 6:23 p.m.
  • Re: Primary Slowness when RSS is active
    KHURRAM SHAHZAD -- Friday, 15 October 2010, at 12:17 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.