[fpereira]

Hi,

I have a problem with an application that runs for a very long time and makes serveral connections to the DB server during the execution. After more or less 24h of execution, and a lot of connections and queries performed, I obtain the error listener-thread: err = -27001 in the DB server and the application stops with identical error message.
Any ideias of what could be wrong ?

Informix IDS 2000 9.21 running on a W2K server with SP4. The server has 2 CPUs and 1GB RAM. The application is running on the same server.

Thanks

Fernando

# IFMX Server LOG
....
11:29:14 Fuzzy Checkpoint Completed: duration was 0 seconds, 6 buffers not flushed.
11:29:14 Checkpoint loguniq 15056, logpos 0x9706c

11:31:59 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt.

11:54:14 Fuzzy Checkpoint Completed: duration was 0 seconds, 6 buffers not flushed.
11:54:14 Checkpoint loguniq 15056, logpos 0x9a06c
.....


# Client application error log
««« ERROR: System.Data.OleDb.OleDbException: XIX000:53oftware caused connection abort
XIX000:-27001:Read error occurred during connection attempt.



# Informix configurations


NETTYPE soctcp,4,,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

NOAGE 0 # Process aging
AFF_SPROC 1 # Affinity start processor
AFF_NPROCS 2 # Affinity number of processors

# Shared Memory Parameters

LOCKS 20000 # Maximum number of locks
BUFFERS 100000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
LOGSMAX 200 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0xc000000 # Shared memory base address
SHMVIRTSIZE 524288 # initial virtual shared memory segment size
SHMADD 51200 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited

[rnealejr]

How many connections are established against the informix instance ? Also, what is the main method for connecting to the server (tcp/ip,shm...) ? Do you have only 1 NETTYPE line in your onconfig file ?

[fpereira]

Originally posted by rnealejr
How many connections are established against the informix instance ? Also, what is the main method for connecting to the server (tcp/ip,shm...) ? Do you have only 1 NETTYPE line in your onconfig file ?

The main method for connecting tcp/ip, and there is only one NETTYPE in onconfig. There may be a big number of connections to this instance, because there are other applications connecting to it (including a WEB based application).

[rnealejr]

Monitor the connections being used and adjust your nettype settings. Also, change your vp class in your nettype from net to cpu.