Primary Slowness when RSS is active
On IDS 11.50FC7W1 (AIX 6.1), heavy load jobs filled a logical log every 10 seconds with the RSS secondary down, but only every 3 minutes with RSS connected — the primary was being throttled by RSS log-shipping flow control (cf. APAR IC67072). Madison Pruet pointed to the new RSS_FLOW_CONTROL onconfig parameter (check with strings; set on the primary); another poster suggested LOG_STAGING_DIR on the RSS. After patching, the poster tried several RSS_FLOW_CONTROL values and still saw throttling, though a same-server primary/RSS pair performed fine, suggesting the ~100ms network latency was involved. The thread ends with Pruet asking for machine access; no resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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
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.
do a "strings" and grep for RSS_FLOW_CONTROL. If you have that, then you have the version containing the patch. You'll need to set the value in your onconfig. There's a bit of documentation about it's use in the onconfig.std file. From: Madison Pruet/Dallas/IBM@IBMUS To: ids@iiug.org Date: 10/12/2010 03:51 PM Subject: Re: Primary Slowness when RSS is active [21658] Sent by: ids-bounces@iiug.org 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.
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.
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.
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss
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.
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.
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.
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.