IDS Forum

Re: connect through java using group_name con mgr

Posted By: KAMRAN HAQ
Date: Monday, 27 April 2009, at 11:56 a.m.

In Response To: Re: connect through java using group_name con mgr (PING TANG)

Sorry my mistake, I am unable to access that file through java( as it is on network ad i tried to access it without help of some web/application server).
Here is another issue I am facing.

I used following connection strings with variation in informixserver values:

A => "jdbc:informix-sqli:/cards_1015:informixserver=oltp;SQLH_TYPE=FILE;SQLH_FILE=D:\\sqlhosts"

B => "jdbc:informix-sqli:/cards_1015:informixserver=report;SQLH_TYPE=FILE;SQLH_FILE=D:\\sqlhosts"

C => "jdbc:informix-sqli:/cards_1015:informixserver=payroll;SQLH_TYPE=FILE;SQLH_FILE=D:\\sqlhosts"

With A & B I got no problem but with option C I got following error message:

Error Message
-------------
SQLState: 08004
Message: Attempt to connect to database server (com.informix.asf.IfxASFRemoteException: payroll) failed.
Error code: -908

sqlhosts
--------
ids_primary onipcshm 192.168.0.16 sqlturbo_pri
ids_secondary onipcshm 192.168.0.15 sqlturbo_sec
ids_rss onipcshm 192.168.0.14 sqlturbo_rss

oltp ontlitcp 192.168.0.16 9991
report ontlitcp 192.168.0.16 9992
payroll ontlitcp 192.168.0.16 9993

g_mach group - - e=ids_net_rss
ids_net_primary ontlitcp 192.168.0.16 sql_net_primary g=g_mach
ids_net_secondary ontlitcp 192.168.0.15 sql_net_secondary g=g_mach
ids_net_rss ontlitcp 192.168.0.14 sql_net_rss g=g_mach

cmsm.cfg
--------
# Connection Manager name
NAME cm_test

SLA oltp=PRIMARY
SLA report=HDR
SLA payroll=RSS
FOC HDR+RSS,0
SLA_WORKERS 16
DEBUG 1 # debug information
LOGFILE /export/informix11-50-3/tmp/cmlog.log

cmlog.log
---------
Mon Apr 27 21:38:54 2009
21:38:54 IBM Informix Connection Manager
21:38:54 Connection Manager name is cm_test
21:38:54 Starting Connection Manager...
21:38:56 Current max open fd is 32767
21:38:56 switch to daemon mode
21:38:56 new daemon pid is 8569 [cmsm_main.c:2525]
21:38:56 fcntl(/export/informix11-50-3/tmp/cmsm.pid.cm_test) success errno = 0 [cmsm_main.c:1781]
21:38:56 dbservername = ids_primary
21:38:56 nettype = onipcshm
21:38:56 hostname = 192.168.0.16
21:38:56 servicename = sqlturbo_pri
21:38:56 options =
21:38:56 create new thread 4 for ids_primary [cmsm_sla.c:557]
21:38:56 CONNECT to sysmaster@ids_primary|onipcshm|192.168.0.16|sqlturbo_pri [cmsm_server.ec:123]
21:38:56 listener oltp initializing
21:38:56 listener report initializing
21:38:56 listener payroll initializing
21:38:56 Listener payroll=RSS is active with 16 worker threads
21:38:56 Listener oltp=PRIMARY is active with 16 worker threads
21:38:56 Listener report=HDR is active with 16 worker threads
21:38:56 CONNECT to sysmaster@ids_primary|onipcshm|192.168.0.16|sqlturbo_pri SQLCODE = (0,0,) [cmsm_server.ec:139]
21:38:56 Connection Manager successfully connected to ids_primary
21:38:56 ids_primary protocols = 1 [cmsm_server.ec:1147]
21:38:56 adding ids_primary alias ids_net_primary with protocol ontlitcp 1 [cmsm_server.ec:1237]
21:38:56 fetch sysconfig_cursor sqlcode = (100,0,) [cmsm_server.ec:1187]
21:38:56 Adding server ids_net_secondary [cmsm_server.ec:1572]
21:38:56 create new thread 55 for ids_net_secondary [cmsm_sla.c:557]
21:38:56 CONNECT to sysmaster@ids_net_secondary|ontlitcp|192.168.0.15|sql_net_secondary USER informix [cmsm_server.ec:123]
21:38:56 Adding server ids_primary [cmsm_server.ec:1572]
21:38:56 Arbitrator FOC string = HDR+RSS,0
21:38:56 Arbitrator setting primary name = ids_primary [cmsm_arb.c:518]
21:38:56 FOC[0] = HDR
21:38:56 FOC[1] = RSS
21:38:56 FOC timeout = 0
21:38:56 CONNECT to sysmaster@ids_net_secondary|ontlitcp|192.168.0.15|sql_net_secondary SQLCODE = (0,0,) [cmsm_server.ec:139]
21:38:56 Connection Manager successfully connected to ids_net_secondary
21:38:56 ids_net_secondary protocols = 1 [cmsm_server.ec:1147]
21:38:56 fetch sysconfig_cursor sqlcode = (100,0,) [cmsm_server.ec:1187]
21:38:56 Arbitrator FOC string = HDR+RSS,0
21:38:56 Arbitrator setting primary name = ids_net_primary [cmsm_arb.c:518]
21:38:56 FOC[0] = HDR
21:38:56 FOC[1] = RSS
21:38:56 FOC timeout = 0
21:38:56 get ids_net_secondary CM_ADM event 8:3 cm_test [cmsm_server.ec:1042]
21:38:57 Connection Manager started successfully
21:39:22 SLA oltp redirect SQLI client from 192.168.33.220 to ids_net_primary 192.168.0.16.9202 [cmsm_main.c:1247]
21:39:45 SLA report redirect SQLI client from 192.168.33.220 to ids_net_secondary 192.168.0.15.8202 [cmsm_main.c:1247]
21:39:56 Warning: no server returned for SLA payroll [cmsm_sla.c:1184]
21:39:56 SLA payroll cannot find database server for SQLI client [cmsm_main.c:1234]

Messages In This Thread

• connect through java using group_name con mgr
  KAMRAN HAQ -- Wednesday, 22 April 2009, at 7:20 a.m.
  • Re: connect through java using group_name con mgr
    PING TANG -- Wednesday, 22 April 2009, at 5:32 p.m.
    • Re: connect through java using group_name con mgr
      KAMRAN HAQ -- Thursday, 23 April 2009, at 5:59 a.m.
      • Re: connect through java using group_name con mgr
        JIM XIAO -- Thursday, 23 April 2009, at 10:54 a.m.
      • Re: connect through java using group_name con mgr
        PING TANG -- Thursday, 23 April 2009, at 1:18 p.m.
        • Re: connect through java using group_name con mgr
          KAMRAN HAQ -- Friday, 24 April 2009, at 12:48 p.m.
          • Re: connect through java using group_name con mgr
            PING TANG -- Friday, 24 April 2009, at 1:31 p.m.
            • Re: connect through java using group_name con mgr
              KAMRAN HAQ -- Monday, 27 April 2009, at 11:56 a.m.
              • Re: connect through java using group_name con mgr
                PING TANG -- Monday, 27 April 2009, at 1:31 p.m.
  • Re: connect through java using group_name con mgr
    PING TANG -- Wednesday, 22 April 2009, at 5:40 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.