If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
We have 2 informix servers with same configurations and exact replica of every setup and configuration.They server the same application and the requests are directed thro' the load director.The servers are p03 and p04
I am observing the number of lockwaits on p03(66) are double the number of lockwaits on P04(30)
even though p03 has less number of lock requests(19408965) compared to p04(22266795).
There has been an overshoot of lockwaits on p03 from 14 to 66 during the weekend whereas as on p04 it is from 21 to 28.
Why is this inconsisytency b/w the servers.At any time they have the same number of transactions and sql's.
How do you keep the servers in sync?
66 lockwait is not much.
If the number of lockrequests is different between the servers, it means the server with the most lockreqs has the most work.
Are u sure there is no difference in config?
f.ex.
row/page locking?
The servers are exactly same in configuration and serve the same purpose.They talk to the same application and load disributed.Right now the lock waits are definately under control but was keen to know the reason why there was big difference in the number of lock waits b/w the servers.
We just found out for some reason one box was getting most of the load comapred to the other.
So much for load balancing. You should clear your stats periodically on both servers at the same time so that you can verify that the servers are being used relatively the same - so if load balancing is failing for some reason you can see it.