RE: Informix Network Connection
Posted in 2004
Topics: Error Codes & Troubleshooting, Server Administration, Transactions, Locking & Isolation, Networking & sqlhosts Configuration, Platform-Specific Issues
Thomas,
I believe the correct network connection type for linux is tlitcp not
soctcp.
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Thomas Ronayne
Sent: Saturday, March 13, 2004 7:03 AM
To: informix-list@iiug.org
Subject: Informix Network Connection
I am unable to figure out how to make a network connection and would
appreciate someone pointing me in the right direction. On my Slackware
Linux 9.1 system, Informix Dynamic Server 7.30.U, I'm trying to get the
network connection working (so I can use PHP with Informix). The shared
memory connection works fine, but attempting to get the network
connection started is an abject failure (and, yes, I've been through the
Client/Server Communications section of the manual and I've tried
everything I can think of).
With onconfig entries
SERVERNUM 1 # Unique id corresponding to a
Dynamic Server instance
DBSERVERNAME fubar_a # Name of default database server
DBSERVERALIASES fubar_anet # Name of network databaseserver
NETTYPE ipcshm,1,100,CPU # Configure poll thread(s)
for nettype
NETTYPE soctcp,1,100,NET # Configure poll
thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No
= 0)
and sqlhost entries
fubar_a onipcshm fubar informixa
fubar_anet onsoctcp fubar informixanet
and /etc/services entries
informixa 1625/tcp # IBM Informix 7.x engine shared
informixanet 1725/tcp # IBM Informix 7.x engine network
When I execute oninit the online log shows
Sat Mar 13 09:38:53 2004
09:38:53 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/log_full.sh'
09:38:59 DR: DRAUTO is 0 (Off)
09:39:00 Informix Dynamic Server Version 7.30.U Software Serial
Number AAC#A404657
09:39:00 listener-thread: err = -27100: oserr = 2: errstr = :
Internal Communications Error: NSF subsystem error.
System error = 2.
09:39:00 Attempting to bring listener thread down
09:39:00 PANIC: Attempting to bring system down
If I comment out the DBSERVERALIASES and NETTYPE lines in onconfig,
oninit starts fine and everything works as expected.
Any help would be most appreciated.
sending to informix-list
Lello, Nick wrote:
> Thomas,
>
> I believe the correct network connection type for linux is tlitcp not
> soctcp.
For 9.40 it is onsoctcp. I have it running like that. (Suse 9.0)
It will be in release notes anyways.
Michael
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
> On Behalf Of Thomas Ronayne
> Sent: Saturday, March 13, 2004 7:03 AM
> To: informix-list@iiug.org
> Subject: Informix Network Connection
>
> I am unable to figure out how to make a network connection and would
> appreciate someone pointing me in the right direction. On my Slackware
> Linux 9.1 system, Informix Dynamic Server 7.30.U, I'm trying to get the
> network connection working (so I can use PHP with Informix). The shared
> memory connection works fine, but attempting to get the network
> connection started is an abject failure (and, yes, I've been through the
>
> Client/Server Communications section of the manual and I've tried
> everything I can think of).
>
> With onconfig entries
>
> SERVERNUM 1 # Unique id corresponding to a
> Dynamic Server instance
> DBSERVERNAME fubar_a # Name of default database server
> DBSERVERALIASES fubar_anet # Name of network database> server
> NETTYPE ipcshm,1,100,CPU # Configure poll thread(s)
> for nettype
> NETTYPE soctcp,1,100,NET # Configure poll
> thread(s) for nettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
> distributed env.
> RESIDENT 0 # Forced residency flag (Yes = 1, No
> = 0)>
> and sqlhost entries
>
> fubar_a onipcshm fubar informixa
> fubar_anet onsoctcp fubar informixanet>
> and /etc/services entries
>
> informixa 1625/tcp # IBM Informix 7.x engine shared
> informixanet 1725/tcp # IBM Informix 7.x engine network
>
> When I execute oninit the online log shows
>
> Sat Mar 13 09:38:53 2004
>
> 09:38:53 Event alarms enabled. ALARMPROG =
> '/opt/informix/etc/log_full.sh'
> 09:38:59 DR: DRAUTO is 0 (Off)
> 09:39:00 Informix Dynamic Server Version 7.30.U Software Serial
> Number AAC#A404657
> 09:39:00 listener-thread: err = -27100: oserr = 2: errstr = :
> Internal Communications Error: NSF subsystem error.
> System error = 2.
> 09:39:00 Attempting to bring listener thread down
>
> 09:39:00 PANIC: Attempting to bring system down
>
> If I comment out the DBSERVERALIASES and NETTYPE lines in onconfig,
> oninit starts fine and everything works as expected.
>
> Any help would be most appreciated.
>
>
>
> sending to informix-list