If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Reg:Informix Connection Problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-21-09, 04:34
rvsenthil rvsenthil is offline
Registered User
 
Join Date: Mar 2009
Posts: 22
Reg:Informix Connection Problem

Dear All,

We are running performance testing for our application. When we run for 400 users, it failed in lot of use cases.

While i go through the log, informix is not allowing new connection.
Physical memory of the server is 20GB RAM.

Error in Log;

08:01:08 hpkaioaddseg: ASYNC_ADDSEG failed, errno = 11 Resource temporarily unavailable
08:01:08 create_tcb: cannot allocate memory

08:01:08 (2030) connection rejected - too many users, or invalid user name
08:01:08 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create a user thread.


Configuration of nettype;

NETTYPE soctcp,8,300,NET
NETTYPE ipcshm,1,300,CPU

Segmant summary:

R :- 6329466880
V :- 6144000000
M :- 3248128
Total :- 12476715008


Please give me some idea to solve this issue. Is it because of configuration or web logic connection pool?

Thanks,
RV
Reply With Quote
  #2 (permalink)  
Old 04-21-09, 05:49
rootdbs rootdbs is offline
Registered User
 
Join Date: Feb 2009
Posts: 51
Post onconfig and output onstat -g seg at the time of the problem.
Reply With Quote
  #3 (permalink)  
Old 04-21-09, 08:24
rvsenthil rvsenthil is offline
Registered User
 
Join Date: Mar 2009
Posts: 22
# Shared Memory Parameters

LOCKS 6000000 # Maximum number of locks
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 512 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 128 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 6000000 # initial virtual shared memory segment size
SHMADD 2000000 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 512 # Stack size (Kbytes)

BUFFERPOOL size=2K,buffers=2500000,lrus=512,lru_min_dirty=1.0 00000,lru_max_dirty=2.000000


onstat -g seg output:-

Segment Summary:
id key addr size ovhd class blkused blkfree
6717446 1382107137 c000000003eac000 6329466880 618304 R* 1545276 4
425991 1382107138 c00000017d2ec000 6144000000 188240 V 1483967 16033
360456 1382107139 c0000002eb64c000 3248128 848 M 792 1
Total: - - 12476715008 - - 3030035 16038

(* segment locked in memory)

Regards,
RV
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On