hola ale como va tanto tiempo?
este es el error que dice
listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt.
luego de esto la base se pone en quiescent
03:00:05 (8459) connection rejected - no calls allowed for sqlexec
03:00:05 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server 2000 quiescent mode.
03:00:07 (8460) connection rejected - no calls allowed for sqlexec
03:00:07 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server 2000 quiescent mode.
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME fadu_produccion # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,7,350,NET
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 8 # 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 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
tambien probe
NETTYPE soctcp 1,350,CPU
NETTYPE soctcp,7,350,NET
entiendo que es casi 2500 conexiones.
tambien puse en ulimit -n a 65000
Me olvidaba esta en un centos
8 gigas de ram ( de los cuales solamente pude hacer poner 3 g al motor de informix )
1048576 1381386241 10000000 2034913280 276872 R* 496790 15
1081345 1381386242 894a5000 891289600 27800 V 8093 209507
Total: - - 2926202880 - - 504883 209522
igualmente en osntat -p tengo
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1786050 1862677 643734219 99.72 22751 95588 1244501 98.17
isamtot open start read write rewrite delete commit rollbk
70836144 2366668 6000462 44049232 814857 1174 41770 95182 3
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 1947.96 76.67 51 102
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
126591 0 1177472957 0 0 3 72362 101245
ixda-RA idx-RA da-RA RA-pgsused lchwaits
48438 10865 1618538 1677805 51149
veo que esta bastante bien el cache.
8 procesadores Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz
4 disco sas en raid 0.
onstat -g glo
MT global info:
sessions threads vps lngspins
16 49 21 0
sched calls thread switches yield 0 yield n yield forever
total: 93578135 5555280 88025577 62565 1076004
per sec: 119 119 0 0 60
Virtual processor summary:
class vps usercpu syscpu total
cpu 8 2033.86 45.29 2079.15
aio 2 0.60 2.04 2.64
lio 1 0.04 0.50 0.54
pio 1 0.00 0.01 0.01
adm 1 0.00 0.00 0.00
soc 7 6.65 23.48 30.13
msc 1 6.41 7.52 13.93
total 21 2047.56 78.84 2126.40
Individual virtual processors:
vp pid class usercpu syscpu total
1 5368 cpu 1612.90 37.74 1650.64
2 5369 adm 0.00 0.00 0.00
3 5370 cpu 317.60 6.52 324.12
4 5371 cpu 78.89 0.77 79.66
5 5372 cpu 20.88 0.19 21.07
6 5373 cpu 3.12 0.05 3.17
7 5374 cpu 0.46 0.02 0.48
8 5375 cpu 0.01 0.00 0.01
9 5376 cpu 0.00 0.00 0.00
10 5377 lio 0.04 0.50 0.54
11 5378 pio 0.00 0.01 0.01
12 5379 aio 0.33 1.10 1.43
13 5380 msc 6.41 7.52 13.93
14 5381 aio 0.27 0.94 1.21
15 5382 soc 1.25 4.93 6.18
16 5383 soc 0.43 1.30 1.73
17 5384 soc 2.91 10.61 13.52
18 5385 soc 0.80 2.76 3.56
19 5386 soc 0.42 1.28 1.70
20 5387 soc 0.43 1.31 1.74
21 5388 soc 0.41 1.29 1.70
tot 2047.56 78.84 2126.40