Attached is the information of our HDR configuration at primary server alongwith connection manager configuration.
The attached file include how we set environment for database and connection manager, how we run the connection manager and what we got in connection manager’s log.
Problem 1: connection manager log shows that it run successfully but “onstst –g cmsm” command don’t show the information about other group members (we defined in the group in sqlhosts file).
Problem 2: We are able to connect through java application using following string
but unable to connect through following connection strings
for both “a” & “b” we get following error message
INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.
How can we connect through using group-name (g_mach)
And using connection manager group member (oltp)
Pinned topic unable to make connection to IDS using group_name or connection manager
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-05-04T12:12:54Z at 2009-05-04T12:12:54Z by ClausSamuelsen
ClausSamuelsen 120000N4RD11 Posts
Re: unable to make connection to IDS using group_name or connection manager2009-05-04T12:12:54ZThis is the accepted answer. This is the accepted answer.Looks like the problem is in your sqlhosts file.
'ids_net_primary' is set to use 'ontlitcp', while 'oltp', 'report' and 'payrole' are set to use 'onsoctcp'. Standard on Solaris is to use 'ontlitcp', but sockets is also supported. To exactly see what is supported on your system see the machine specific notes in the release directory.
It may also be that you are missing a NETTYPE line in onconfig file (not within your attachment). In order to use both tli and sockets you must have both a "NETTYPE tlitcp,1,50,NET" and "NETTYPE soctcp,1,50,NET".