Help please (reposted)
Posted in 2000
Topics: High Availability & Replication, Performance & Tuning, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life
Hi all.
We try to configure an IDS 9.21 FC2 on Solaris 7 with HDR. The clients
though are 32-bits, so we were told to use TCP connections, not shared
memory.
For the previous version used (7.30), we were using shared memory, and
our sqlhosts on one of the servers looks like:
inf_shm onipcshm server_1 some_name
inf_tlia ontlitcp server_1 infserv_sys
otherinf_tlia ontlitcp server_1 otherserv_sys
inf_tlib ontlitcp server_2 infserv_sys
otherinf_tlib ontlitcp server_2 otherserv_sys
My questions are:
1. How does HDR know which connection to use for HDR if there are more
entries in the sqlhosts for the secondary server ?
2. Do we need to replace the shared memory connection with a new TCP
one, listening to a new port, or we can use the existing TCP connection
?
3. Are there any performance issues if we use the same TCP connection ?
Thanks in advance,
Bogdan Neagu
Bogdan Neagu wrote in message <39FDBEB1.5B9C8A1F@alcatel.com>...
>Hi all.
>
>We try to configure an IDS 9.21 FC2 on Solaris 7 with HDR. The clients
>though are 32-bits, so we were told to use TCP connections, not shared
>memory.
>
>For the previous version used (7.30), we were using shared memory, and
>our sqlhosts on one of the servers looks like:
>
>inf_shm onipcshm server_1 some_name
>inf_tlia ontlitcp server_1 infserv_sys
>otherinf_tlia ontlitcp server_1 otherserv_sys
>inf_tlib ontlitcp server_2 infserv_sys
>otherinf_tlib ontlitcp server_2 otherserv_sys>
>My questions are:
>1. How does HDR know which connection to use for HDR if there are more
>entries in the sqlhosts for the secondary server ?
HDR picks one, probably the first.
>2. Do we need to replace the shared memory connection with a new TCP
>one, listening to a new port, or we can use the existing TCP connection
>?
HDR will use the existing TCP connection. HDR has to be to a
different machine (since the chunks paths have to be the same)
and hence will not use shared memory connections
>3. Are there any performance issues if we use the same TCP connection ?
>
Nope
>Thanks in advance,
>
>Bogdan Neagu
>
>
>