| Author |
Message
|
| voyager |
 Posted: Wed Dec 28, 2005 7:51 pm Post subject: Load Balancing with 2 ICS servers |
 |
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
All,
Thank you very much for your help with my earlier posts.
We are running ICS 4.3.0.2 with SQL Server as ICS Repository and MQ 5.3.0 CSD07.
I was trying to do load balancing using another ICS server with the exact same configuration.
While I was doing load balancing by running second ICS Server (P2) which is reading
the msgs. off of external MQ Inbound queues on P1 ICS Server, the AP Queues that are on
P2 server (internal MQ) got filled up and eventually P2 ICS server got crashed.
I lost all those transactions that are stuck in CxWIPObjects table in P2 ICS server's repository.
In the first place, I have no clue why the AP Queues got filled up even though the destination
connector (JDBC) is processing the transactions with considerable speed. though the performance has decreased over couple of weeks.
I would appreciate if anyone has better suggestions about load balancing and ICS performance
issues especially with SQL Server 2000 as ICS repository. Earlier I was using DB2 UDB 8.1 as ICS repository
for ICS. But, we have switched to SQL Server 2000 repository on remote machine and the
performance has increased very much. But, there is only one issue that the AP Queues
are getting filled up fast and JDBC connector is getting behind.
I would like to know if any one has experienced similar problems.
Thank you!
_________________
voyager |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Dec 29, 2005 2:48 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Is this a supported configuration? |
|
| Back to top |
|
|
| voyager |
| Posted: Tue Jan 03, 2006 6:01 am Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
I guess YES. This configuration is supported by ICS.
Any suggestions?
Thank you!
_________________
voyager |
|
| Back to top |
|
|
| recallsunny |
| Posted: Tue Jan 03, 2006 1:56 pm Post subject: Re: Load Balancing with 2 ICS servers |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
| voyager wrote: |
| I was trying to do load balancing using another ICS server with the exact same configuration. |
I wonder if this can be classified as "Load Balancing"..... Are you running two agent connections of (similarly/uniquely named) MQ adapters pointing to 2 differently named ICS servers? How is your destination connector(JDBC) configured ?
This can only allow processing of messages in a random order (not exactly load balanced) !
We've recently upgraded to v4.3 but to my prior knowledge ( working with v4.1, 4.2.1, 4.2.2) there is no ICS load balancing feature... So it brings us back to the million $$$ question - "Is this a supported configuration in v4.3 ????????" |
|
| Back to top |
|
|
| voyager |
| Posted: Wed Jan 04, 2006 6:15 am Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
| Quote: |
I wonder if this can be classified as "Load Balancing"..... Are you running two agent
connections of (similarly/uniquely named) MQ adapters pointing to 2 differently named
ICS servers? How is your destination connector(JDBC) configured ? |
Yes, I am running two agent connections with exact same configuration and uniquely named
on two different ICS machines pointing to two different ICS server instances.
But, one set of conenctors read the messages off of MQ Inbound Queues on the same box
(say P1) and the other set of connectors on box P2 read the messages off of MQ Inbound Queues on P1.
Destination JDBC connector has exactly the same configuration and write to the same database.
ICS version is 4.3.0.2. I am not 100% sure that this configuration is supported by IBM or not.
But, I know that this works and we can achieve load balanncing by doing so.
Any suggestions/ideas greatly appreciated.
Thank you!
_________________
voyager |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Jan 04, 2006 10:34 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I didn't understand your configuration for the first time. It definitely is a load balancing scenario and there is no reason why IBM wouldn't support this type of configuration.
Anyway back to the problem:
What is your delivery transport and what all queues are getting filled. |
|
| Back to top |
|
|
| recallsunny |
| Posted: Wed Jan 04, 2006 10:42 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
| My hunch is that the JDBC two connectors are facing a deadlock situation while accessing your same db/tables, So one instance has to wait till the other adapter releases the connection. Assuming your ControllerStoreAndForward is true, your connector on P2 will wait till this deadlock situation is resolved. |
|
| Back to top |
|
|
| recallsunny |
| Posted: Wed Jan 04, 2006 10:47 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
| vennela wrote: |
I didn't understand your configuration for the first time. It definitely is a load balancing scenario and there is no reason why IBM wouldn't support this type of configuration.
|
It should be termed "Load sharing" since its Random, definitely not Load Balancing....which is logical. |
|
| Back to top |
|
|
| voyager |
| Posted: Fri Jan 06, 2006 2:17 pm Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Yes Sir,
Definetly it should be called Load sharing because the messages are picked up randomly.
But, I thought both the servers get equal share of messages. But, it may not be true.
OK, Coming to the JDBC Connectors having Dead Lock problem. I did not quite get it.
JDBC Connectors write to the same database. But, we have some intermideate table
where we insert each record and then do the processing using triggers and stored procedures
on these Intermediate tables. So, my guess is there will not be any dead lock issues with JDBC conenctors.
I have already opened a ticket with IBM on this issue and I guess they will get back to me sometime next week
 Hopefully
Thank you for your valuable suggestions once again!
_________________
voyager |
|
| Back to top |
|
|
|
|
