Oninit cdi / Archive
Talk to an expert →

onipcshm conn failing 25592

Posted in 2010

Topics: Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues

WALDEMAR ZNOINSKI — — source: IIUG Forums & Mailing Lists

Hi there, IDS11.50FC7, SLES10.3 when I'm logged in to the linux shell (the same is with SS) with environment set to use devdub01 ids instance I'm trying to connect to devdub00 (another IDS instance on the same machine) getting 25592 error. Here are the checks: # echo $INFORMIXSERVERdevdub01 # grep devdub0[01] $INFORMIXDIR/etc/sqlhostsdevdub00 onipcshm localhost devdub00 devdub00_tcp onsoctcp *localhost 1525 devdub01 onipcshm localhost devdub01 devdub01_tcp onsoctcp *localhost ids9tcp2 devdub01_drda drsoctcp *localhost ids9tcp3 # echo $INFORMIXSQLHOSTS <blank> # ls -l $INFORMIXDIR/etc/sqlhosts -rw-r--r-- 1 informix informix 2814 2010-07-26 18:19 /informix/IDS_11.50.FC7/etc/sqlhosts # ping devdub00 PING devdub00 (172.22.20.42) 56(84) bytes of data. 64 bytes from devdub01 (172.22.20.42): icmp_seq=1 ttl=64 time=0.029 ms # grep devdub0[01] /etc/hosts 172.22.20.42 devdub01 devdub01.scoteqint.ie 172.22.20.42 devdub00 devdub00.scoteqint.ie # grep -i ipc /informix/IDS_11.50.FC7/etc/onconfig.devdub0[01] /informix/IDS_11.50.FC7/etc/onconfig.devdub00:NETTYPE ipcshm,3,35,CPU /informix/IDS_11.50.FC7/etc/onconfig.devdub01:NETTYPE ipcshm,3,35,CPU # grep -v "^#" /informix/IDS_11.50.FC7/etc/onconfig.devdub0[01]| grep SERVER /informix/IDS_11.50.FC7/etc/onconfig.devdub00:SERVERNUM 1 /informix/IDS_11.50.FC7/etc/onconfig.devdub00:DBSERVERNAME devdub00 /informix/IDS_11.50.FC7/etc/onconfig.devdub00:DBSERVERALIASES devdub00_tcp /informix/IDS_11.50.FC7/etc/onconfig.devdub00:RTO_SERVER_RESTART 0 /informix/IDS_11.50.FC7/etc/onconfig.devdub01:SERVERNUM 0 /informix/IDS_11.50.FC7/etc/onconfig.devdub01:DBSERVERNAME devdub01 /informix/IDS_11.50.FC7/etc/onconfig.devdub01:DBSERVERALIASES devdub01_tcp,devdub01_drda /informix/IDS_11.50.FC7/etc/onconfig.devdub01:RTO_SERVER_RESTART 0 The TEST that runs ok (onsoctcp): # echo "select count(*) from sei_live_dublin@devdub00_tcp:lc_current" |dbaccess sysmaster (count(*)) 1353091 The TEST that fails (onipcshm): # echo "select count(*) from sei_live_dublin@devdub00:lc_current" | dbaccesssysmaster 908: Attempt to connect to database server (devdub00, conerr=-25592, oserr=2) failed. Error in line 1Near character position 57 Does it mean it tries to use network connection instead of InterProCes? Sorry if it's something trivial - I just can't spot the problem here, thanks for any suggestions.

↪ replying to WALDEMAR ZNOINSKI
Art Kagel — — source: IIUG Forums & Mailing Lists

You cannot connect from one instance to another using shared memory connection. The connection to the remote/other server has to be either a TCP or strpip connection. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 26, 2010 at 2:06 PM, WALDEMAR ZNOINSKI <waldek@znoinski.pl>wrote: > Hi there, > IDS11.50FC7, SLES10.3 > when I'm logged in to the linux shell (the same is with SS) with > environment > set to use devdub01 ids instance I'm trying to connect to devdub00 (another > IDS instance on the same machine) getting 25592 error. > > Here are the checks: > # echo $INFORMIXSERVER> devdub01 > > # grep devdub0[01] $INFORMIXDIR/etc/sqlhosts> devdub00 onipcshm localhost devdub00 > devdub00_tcp onsoctcp *localhost 1525 > devdub01 onipcshm localhost devdub01 > devdub01_tcp onsoctcp *localhost ids9tcp2 > devdub01_drda drsoctcp *localhost ids9tcp3> > # echo $INFORMIXSQLHOSTS > <blank>> > # ls -l $INFORMIXDIR/etc/sqlhosts > -rw-r--r-- 1 informix informix 2814 2010-07-26 18:19 > /informix/IDS_11.50.FC7/etc/sqlhosts> > # ping devdub00 > PING devdub00 (172.22.20.42) 56(84) bytes of data. > 64 bytes from devdub01 (172.22.20.42): icmp_seq=1 ttl=64 time=0.029 ms > > # grep devdub0[01] /etc/hosts > 172.22.20.42 devdub01 devdub01.scoteqint.ie > 172.22.20.42 devdub00 devdub00.scoteqint.ie> > # grep -i ipc /informix/IDS_11.50.FC7/etc/onconfig.devdub0[01] > /informix/IDS_11.50.FC7/etc/onconfig.devdub00:NETTYPE ipcshm,3,35,CPU > /informix/IDS_11.50.FC7/etc/onconfig.devdub01:NETTYPE ipcshm,3,35,CPU> > # grep -v "^#" /informix/IDS_11.50.FC7/etc/onconfig.devdub0[01]| grep> SERVER > /informix/IDS_11.50.FC7/etc/onconfig.devdub00:SERVERNUM 1 > /informix/IDS_11.50.FC7/etc/onconfig.devdub00:DBSERVERNAME devdub00 > /informix/IDS_11.50.FC7/etc/onconfig.devdub00:DBSERVERALIASES devdub00_tcp > /informix/IDS_11.50.FC7/etc/onconfig.devdub00:RTO_SERVER_RESTART 0 > /informix/IDS_11.50.FC7/etc/onconfig.devdub01:SERVERNUM 0 > /informix/IDS_11.50.FC7/etc/onconfig.devdub01:DBSERVERNAME devdub01 > /informix/IDS_11.50.FC7/etc/onconfig.devdub01:DBSERVERALIASES > devdub01_tcp,devdub01_drda > /informix/IDS_11.50.FC7/etc/onconfig.devdub01:RTO_SERVER_RESTART 0 > > The TEST that runs ok (onsoctcp): > # echo "select count(*) from sei_live_dublin@devdub00_tcp:lc_current" |> dbaccess sysmaster > > (count(*)) > > 1353091 > > The TEST that fails (onipcshm): > # echo "select count(*) from sei_live_dublin@devdub00:lc_current" | > dbaccess> sysmaster > > 908: Attempt to connect to database server (devdub00, conerr=-25592, > oserr=2) > failed. > Error in line 1> Near character position 57 > > Does it mean it tries to use network connection instead of InterProCes? > Sorry if it's something trivial - I just can't spot the problem here, > thanks > for any suggestions. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f626a67265e5048c4f69be

Related threads

Glossary