Topic
  • 1 reply
  • Latest Post - ‏2009-05-04T12:12:54Z by ClausSamuelsen
Omer_Saeed_Khan
Omer_Saeed_Khan
2 Posts

Pinned topic unable to make connection to IDS using group_name or connection manager

‏2009-04-22T11:14:38Z |
Hi

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

jdbc:informix-sqli://192.168.0.16:9022/cards:informixserver=ids_net_primary

but unable to connect through following connection strings

a) jdbc:informix-sqli://192.168.0.16:9022/cards:informixserver=oltp

b) jdbc:informix-sqli://192.168.0.16:9022/cards:informixserver=g_mach

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)
Updated on 2009-05-04T12:12:54Z at 2009-05-04T12:12:54Z by ClausSamuelsen
  • ClausSamuelsen
    ClausSamuelsen
    11 Posts

    Re: unable to make connection to IDS using group_name or connection manager

    ‏2009-05-04T12:12:54Z  
    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".

    Regards
    Claus