Hello,
Is there a formula/algorithm that determines how many TCP connections are
made per child process to a database server defined by sqlops' sqlcon
parameter?
ex: if i have 1 database on a database server defined by sqlcon, and i have
1 UDP child process, i notice that the child process has made 2 TCP
connections to the database server.
ex: if i have 3 databases on the same database server defined by 3 sqlcon
statements (1 pertaining to each database) and i have 4 UDP child
processes, i notice that each child process makes 4 TCP connections to the
database server.
ex: if i have 3 databases on the same database server defined by 3 sqlcon
statements (1 pertaining to each database) and i have 6 TCP child
processes, i notice that each child process makes 4 TCP connections to the
database server.
Basically wanting to know what governs the number of tcp connections a
child process makes to a particular database server.
Thank you,
Karthik