We're running Policy Server with 2 ODBC instances of Session Stores,when the first instance goes off line, then the connections are goingto the next Session Store, and when the first instance comes backon-line, the connections doen't goes back to the first instance.
We want to know why ?
At first glance, the behavior is as expected. Even if the nomenclatureof the configuration suggest there's a loadbalancing, the followingconfiguration means failover, and not loadbalancing :
How to implement ODBC LoadBalancing for User Storehttps://comm.support.ca.com/kb/how-to-implement-odbc-loadbalancing-for-user-store/kb000016656
As such, the behavior you see is as expected and by design.
KB : KB000119929