 |
IIUG Espaņol
Problemas de desempeño con soctcp
Posted By: NANDO G
Date: Thursday, 26 February 2004, at 4:53 p.m.
Buenas tardes,
Yo tengo 2 computadores HewlettPackard R390 Series 9000 model 800, cada uno con HP-UX 11 (64bits), un solo procesador e IDS 9.30.FC4
En el momento tengo problemas de desempeño cuando realizo conexiones entre servidores, es decir, cuando hago un "select" de el Servidor "A" al servidor "B" como por ejemplo:
si desde el servidor "B" trato de hacer la siguiente sentencia usando el "dbaccess"
Select * from db@B:tab1
Anunque la tabla "tab1" contenga 7 registros la respuesta puede tomar entre 2 a 5 segundos, esto para nuestro sistema que realiza muchas transacciones entre los dos servidores es mucho tiempo.
Como puedo mejorar el desempeño de conectividad o de que otra manera puedo conectar estos servidores mas eficientemente; en el momento yo tengo el parametro NTTYPE de la siguiente forma "NETTYPE soctcp, 4, 60, NET", que cambos me sugieren que haga?
Gracias!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
onconfig SERVER A
Informix Dynamic Server Version 9.30.FC4 -- On-Line -- Up 2 days 05:57:54 -- 349728 Kbytes
Configuration File: /opt/informixids/etc/onconfig.omicron
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.omicron
# Description: Informix Dynamic Server Configuration Parameters
# Elaborado por Angel Ruiz Mayo 1 de 2003
# Actualizaciones
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/inf1/rootdbs # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 286720 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS phyv1 # Location (dbspace) of physical log
PHYSFILE 8014 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 60 # Number of logical log files
LOGSIZE 4000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /opt/informixids/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /opt/informixids/etc/log_full.sh # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/rmt/0m # Tape device path
TAPEBLK 20 # Tape block size (Kbytes)
TAPESIZE 23101440 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV sigma:/dev/rmt/0m # Log tape device path
LTAPEBLK 20 # Log tape block size (Kbytes)
LTAPESIZE 1850000 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME omicron # Name of default database server
DBSERVERALIASES omicron_sh # List of alternate dbservernames
#NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,4,60,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
#NUMCPUVPS 1 # Number of user (cpu) vps
VPCLASS cpu,num=1,noage
VPCLASS aio,num=10
#VPCLASS aio,num=5
#VPCLASS aio,num=8
SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one
#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
# Shared Memory Parameters
LOCKS 250000 # Maximum number of locks
#BUFFERS 30000 # Maximum number of shared buffers
BUFFERS 40000 # Maximum number of shared buffers
#BUFFERS 60000 # Maximum number of shared buffers
#NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 500 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 8 # Number of buffer cleaner processes
#CLEANERS 4 # Number of buffer cleaner processes
#CLEANERS 6 # Number of buffer cleaner processes
#CLEANERS 5 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 229376 # initial virtual shared memory segment size
#SHMADD 65536 # Size of new shared memory segments (Kbytes)
SHMADD 32768 # Size of new shared memory segments (Kbytes)
SHMTOTAL 383020 # Total shared memory (Kbytes). 0=>unlimited
#SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 240 # Check point interval (in sec)
DD_HASHMAX 5 # Hernando G
DD_HASHSIZE 107 # Hernando G
LRUS 20 # Number of LRU queues
#LRUS 60 # Number of LRU queues
LRU_MAX_DIRTY 3 # LRU percent dirty begin cleaning limit
#LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
#LRU_MAX_DIRTY 4 # LRU percent dirty begin cleaning limit
#LRU_MAX_DIRTY 70 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
#LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /opt/informixids/etc/dr.lostfound # DR lost+found file path
# CDR Variables
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL 0,0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE # CDR queue smart blob space
CDR_QDATA_SBFLAGS 0 # Log/no-log (default no log)
# Backup/Restore variables
BAR_ACT_LOG /opt/informixids/bar_act.log
# ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /opt/informixids/bar_dbug.log
# ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
#RA_PAGES 4 # Number of pages to attempt to read ahead
RA_PAGES 4000 # Number of pages to attempt to read ahead
#RA_THRESHOLD 2 # Number of pages left before next group
RA_THRESHOLD 2000 # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tempdbs1,tempdbs2 # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /unload/registros # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 96 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 50 # Maximum allowed pdqpriority
DS_MAX_QUERIES 2 # Maximum number of decision support queries
DS_TOTAL_MEMORY 2048 # Decision support memory (Kbytes)
DS_MAX_SCANS 120 # Maximum number of decision support scans
DS_HASHSIZE 107 # Hernando G
DS_POOLSIZE 10 # Hernando G
DATASKIP off # List of dbspaces to skip
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 1 # To hint the optimizer, vigente desde 6/Feb/2004
#OPTCOMPIND 0 # To hint the optimizer
#OPTCOMPIND 2 # To hint the optimizer
DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
SBSPACENAME # Default smartblob space name - this is where blobs
# go if no sbspace is specified when the smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
SYSSBSPACENAME # Default smartblob space for use by the Informix
# Server. This is used primarily for Informix Server
# system statistics collection.
BLOCKTIMEOUT 3600 # Default timeout for system block
SYSALARMPROGRAM /opt/informixids/etc/evidence.sh # System Alarm program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
DYNAMIC_LOGS 0
LTXHWM 70
LTXEHWM 80
STMT_CACHE 2 # Hernando G
#STMT_CACHE_HITS 10 # Hernando G
#STMT_CACHE_SIZE 1024 # Hernando G
#STMT_CACHE_NOLIMIT 0 # Hernando G
#STMT_CACHE_NUMPOOL 4 # Hernando G
PC_HASHSIZE 30 # Tamano del cache de Stores procedures
PC_POOLSIZE 300 # Numero de Stores Procedures guardados en cache
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
onconfig SERVER B
Informix Dynamic Server Version 9.30.FC4 -- On-Line -- Up 5 days 10:06:08 -- 317560 Kbytes
Configuration File: /opt/informixids/etc/onconfig.omega
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.omega
# Description: Informix Dynamic Server Configuration Parameters
# Elaborado por Angel Ruiz Mayo 1 de 2003
# Actualizacionesa
#
#==========================================================================
# CAMBIOS EN LOS PARAMETROS - HGP
#
# Parametro Valor Motivo - Fecha cambio 29-Dic-2003
# Nuevo Anterior
# LRU_MAX_DIRTY 3 4 Las escrituras a los LRUS eran
# LRU Writes Chunk Writes
# 34445 121701
# se debian balancear los LRUWrites
#
#
#==========================================================================
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/inf2/rootdbs # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 286720 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS phyv3 # Location (dbspace) of physical log
PHYSFILE 8014 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 64 # Number of logical log files
LOGSIZE 4000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /opt/informixids/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /opt/informixids/log_full.sh # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/rmt/0m # Tape device path
TAPEBLK 20 # Tape block size (Kbytes)
TAPESIZE 23101440 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV ipsilon:/dev/rmt/0m # Log tape device path
LTAPEBLK 20 # Log tape block size (Kbytes)
LTAPESIZE 1850000 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine instance
DBSERVERNAME omega # Name of default database server
DBSERVERALIASES omega_sh # List of alternate dbservernames
#NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,4,60,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
#NUMCPUVPS 1 # Number of user (cpu) vps
VPCLASS cpu,num=1,noage
VPCLASS aio,num=5
#VPCLASS aio,num=6
SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one
#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
# Shared Memory Parameters
LOCKS 250000 # Maximum number of locks
BUFFERS 40000 # Maximum number of shared buffers
#BUFFERS 30000 # Maximum number of shared buffers
#NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 800 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 4 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 196608 # initial virtual shared memory segment size
#SHMVIRTSIZE 131072 # initial virtual shared memory segment size
#SHMVIRTSIZE 65536 # initial virtual shared memory segment size
SHMADD 32768 # Size of new shared memory segments (Kbytes)
SHMTOTAL 383620 # Total shared memory (Kbytes). 0=>unlimited ( 2 bloques de 32
768)
#SHMTOTAL 350852 # Total shared memory (Kbytes). 0=>unlimited
#SHMTOTAL 263668 # Total shared memory (Kbytes). 0=>unlimited
#SHMTOTAL 259544 # Total shared memory (Kbytes). 0=>unlimited
#SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 240 # Check point interval (in sec)
DD_HASHMAX 5 #
DD_HASHSIZE 107 #
LRUS 20 # Number of LRU queues
#LRUS 60 # Number of LRU queues
#LRU_MAX_DIRTY 4 # LRU percent dirty begin cleaning limit
#LRU_MAX_DIRTY 3 # Cambiado el 5/Dic/2003
LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /opt/informixids/dr.lostfound # DR lost+found file path
# CDR Variables
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL 0,0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE # CDR queue smart blob space
CDR_QDATA_SBFLAGS 0 # Log/no-log (default no log)
# Backup/Restore variables
BAR_ACT_LOG /opt/informixids/bar_act.log
# ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /opt/informixids/bar_dbug.log
# ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES 4000 # Number of pages to attempt to read ahead
#RA_PAGES 4 # Number of pages to attempt to read ahead
RA_THRESHOLD 2000 # Number of pages left before next group
#RA_THRESHOLD 3996 # Number of pages left before next group
#RA_THRESHOLD 2 # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tempdbs1 # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /unload/registros # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 96 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 50 # Maximum allowed pdqpriority
DS_MAX_QUERIES 2 # Maximum number of decision support queries
DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
DS_MAX_SCANS 60 # Maximum number of decision support scans
DS_HASHSIZE 107 #
DS_POOLSIZE 10 #
DATASKIP off # List of dbspaces to skip
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 1 # To hint the optimizer
#OPTCOMPIND 0 # To hint the optimizer
DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
SBSPACENAME # Default smartblob space name - this is where blobs
# go if no sbspace is specified when the smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
SYSSBSPACENAME # Default smartblob space for use by the Informix
# Server. This is used primarily for Informix Server
# system statistics collection.
BLOCKTIMEOUT 3600 # Default timeout for system block
SYSALARMPROGRAM /opt/informixids/etc/evidence.sh # System Alarm program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
DYNAMIC_LOGS 0
LTXHWM 70
LTXEHWM 80
STMT_CACHE 2 # Hernando G
#STMT_CACHE_HITS 10 # Hernando G
#STMT_CACHE_SIZE 1024 # Hernando G
#STMT_CACHE_NOLIMIT 0 # Hernando G
#STMT_CACHE_NUMPOOL 4 # Hernando G
PC_HASHSIZE 30 # Tamano del cache de Stores procedures
PC_POOLSIZE 300 # Numero de Stores Procedures guardados en cache
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
onstat -g ntu
Informix Dynamic Server Version 9.30.FC4 -- On-Line -- Up 5 days 10:09:10 -- 317560 Kbytes
global network information:
#netscb connects read write q-free q-limits q-exceed alloc/max
166/ 473 3687 3253187 3263596 47/ 142 142/ 10 612/ 0 209/ 209
Individual thread network information (basic):
netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp
c00000000bc14d68 soctcp sqlexec 23165 6 5 16 15 0/ 1 1/ 1 0/ 0
c000000012111050 soctcp sqlexec 23164 95 8 35 35 0/ 1 1/ 1 0/ 0
c000000012d22340 soctcp sqlexec 23162 81 6 389 396 0/ 1 1/ 1 0/ 0
c0000000118c7c38 soctcp sqlexec 23160 10 5 87 87 0/ 1 0/ 1 0/ 0
c0000000118ed9f8 soctcp sqlexec 23160 17 7 74 74 1/ 1 0/ 1 0/ 0
c00000000926bc90 soctcp sqlexec 23157 48 8 259 266 0/ 1 1/ 1 0/ 0
c00000000f63e8a0 soctcp sqlexec 23156 34 7 27 26 0/ 1 1/ 1 0/ 0
c0000000111884d0 soctcp sqlexec 23153 66 7 653 654 0/ 1 1/ 1 0/ 0
c000000009098d28 soctcp sqlexec 23149 118 7 16 16 0/ 1 1/ 1 0/ 0
c00000000f7838a0 soctcp sqlexec 23144 108 6 317 317 0/ 1 1/ 1 0/ 0
c000000011af80d8 soctcp sqlexec 23140 88 6 63 63 0/ 1 0/ 1 0/ 0
c000000012c2b620 soctcp sqlexec 23141 68 5 243 243 0/ 1 0/ 1 0/ 0
c000000011ccf028 soctcp sqlexec 23141 38 8 630 630 0/ 1 1/ 1 0/ 1
c000000013220558 soctcp sqlexec 23140 100 7 142 142 0/ 1 1/ 1 0/ 0
c00000000f9cfd60 soctcp sqlexec 23139 36 5 239 239 0/ 1 1/ 1 0/ 1
c00000000ba7a8a0 soctcp sqlexec 23126 109 7 9 9 0/ 1 0/ 1 0/ 0
c00000000f169118 soctcp sqlexec 23127 63 7 149 149 0/ 1 0/ 1 0/ 0
c0000000111d0c88 soctcp sqlexec 23127 56 6 332 332 0/ 1 1/ 1 0/ 0
c00000001259e428 soctcp sqlexec 23126 53 5 549 549 0/ 1 1/ 1 0/ 0
c00000000af2fc98 soctcp sqlexec 23123 11 6 55 55 0/ 1 0/ 1 0/ 0
c00000000a8c4028 soctcp sqlexec 23100 4 5 1497 1497 0/ 1 0/ 1 0/ 0
c000000012205050 soctcp sqlexec 23123 5 8 124 124 0/ 1 1/ 1 0/ 0
c000000011bbd028 soctcp sqlexec 23121 58 6 343 343 0/ 1 1/ 1 0/ 0
c000000011af83d8 soctcp sqlexec 23116 45 8 404 404 0/ 1 1/ 1 0/ 0
c0000000113c0068 soctcp sqlexec 23114 16 5 84 84 0/ 1 1/ 1 0/ 0
c00000000bd06a18 soctcp sqlexec 23110 111 5 75 75 0/ 1 0/ 1 0/ 0
c00000000d3d75b0 soctcp sqlexec 23110 76 8 174 174 0/ 1 1/ 1 0/ 0
c00000000b9cb858 soctcp sqlexec 23100 9 5 1759 1762 0/ 1 1/ 1 0/ 1
c0000000117d5b28 soctcp sqlexec 23065 65 8 342 342 0/ 1 0/ 1 0/ 0
c00000000ba7acd0 soctcp sqlexec 23093 86 7 19 23 0/ 1 1/ 1 0/ 0
c000000009eb5d30 soctcp sqlexec 23092 144 6 62 62 0/ 1 1/ 1 0/ 0
c00000000edc6ce0 soctcp sqlexec 23043 72 7 705 705 0/ 1 0/ 1 0/ 0
c000000011230bb8 soctcp sqlexec 23087 166 8 375 375 0/ 1 0/ 1 0/ 0
c0000000130eac20 soctcp sqlexec 23087 165 7 940 940 0/ 1 1/ 1 0/ 1
c000000010fc4378 soctcp sqlexec 23078 143 7 96 96 0/ 1 0/ 1 0/ 0
c000000012c67050 soctcp sqlexec 23078 35 5 50 50 0/ 1 1/ 1 0/ 0
c00000000d28ec88 soctcp sqlexec 23055 107 7 788 788 0/ 1 0/ 1 0/ 0
c00000000f6e1c10 soctcp sqlexec 22979 103 6 881 881 0/ 1 0/ 1 0/ 0
c00000001239c028 soctcp sqlexec 23071 102 5 47 47 0/ 1 1/ 1 0/ 0
c00000000f48cd30 soctcp sqlexec 23064 168 7 9 9 0/ 1 0/ 1 0/ 0
c000000011850cd0 soctcp sqlexec 23065 99 5 451 451 0/ 1 1/ 1 0/ 0
c0000000111881f0 soctcp sqlexec 23064 33 8 95 95 0/ 1 1/ 1 0/ 0
c000000010f02c58 soctcp sqlexec 23062 47 7 31 31 0/ 1 0/ 1 0/ 0
c000000012fcc8a0 soctcp sqlexec 23062 167 8 413 413 0/ 1 1/ 1 0/ 0
c0000000129f86f0 soctcp sqlexec 23055 28 8 1393 1393 0/ 1 1/ 1 0/ 1
c000000010b13608 soctcp sqlexec 23054 157 7 855 855 0/ 1 0/ 1 0/ 0
c00000000e0c9090 soctcp sqlexec 23054 155 6 1521 1521 0/ 1 1/ 1 0/ 0
c00000000d6154c0 soctcp sqlexec 23004 85 8 648 648 0/ 1 0/ 1 0/ 0
c000000012143cf8 soctcp sqlexec 23053 82 7 946 946 0/ 1 0/ 1 0/ 0
c00000000d84f158 soctcp sqlexec 23053 148 6 1425 1425 0/ 1 1/ 1 0/ 0
c00000000f70dc30 soctcp sqlexec 23051 147 8 681 681 0/ 1 0/ 1 0/ 0
c000000011c138a0 soctcp sqlexec 23051 145 7 808 808 0/ 1 1/ 1 0/ 0
c00000001223ad18 soctcp sqlexec 23050 149 5 63 75 0/ 1 0/ 1 0/ 1
c000000011bf9028 soctcp sqlexec 23043 105 8 850 850 0/ 1 1/ 1 0/ 0
c00000001109ab68 soctcp sqlexec 23028 20 8 1900 1900 0/ 1 0/ 1 0/ 0
c00000000f6917c0 soctcp sqlexec 23028 27 5 6641 6641 0/ 1 1/ 1 0/ 1
c00000000f8848c8 soctcp sqlexec 23018 41 7 325 325 0/ 1 0/ 1 0/ 0
c0000000126aa050 soctcp sqlexec 23018 67 6 275 275 0/ 1 1/ 1 0/ 0
c00000000bac6cc0 soctcp sqlexec 23014 125 7 59 59 0/ 1 0/ 1 0/ 0
c00000000dde7d10 soctcp sqlexec 23015 140 6 263 268 0/ 1 1/ 1 0/ 0
c00000000edc5498 soctcp sqlexec 23014 87 5 954 954 0/ 1 1/ 1 0/ 0
c00000000f58f9a0 soctcp sqlexec 23013 116 8 287 287 0/ 1 1/ 1 0/ 1
c000000012a61be8 soctcp sqlexec 23007 91 5 84 84 0/ 1 0/ 1 0/ 0
c00000000a49a3e0 soctcp sqlexec 23007 90 8 154 154 0/ 1 1/ 1 0/ 0
c00000000f3e98a0 soctcp sqlexec 23004 40 5 709 709 0/ 1 1/ 1 0/ 0
c00000000ed99c10 soctcp sqlexec 22997 78 6 1052 1054 0/ 1 1/ 1 0/ 0
c0000000090c1028 soctcp sqlexec 22989 92 7 17 18 0/ 1 1/ 1 0/ 0
c0000000124a21d0 soctcp sqlexec 22988 96 6 200 200 0/ 1 1/ 1 0/ 0
c0000000122a3050 soctcp sqlexec 22983 26 5 29 29 0/ 1 1/ 1 0/ 0
c000000011eca050 soctcp sqlexec 22982 8 8 59 59 0/ 1 1/ 1 0/ 0
c000000012d84280 soctcp sqlexec 22979 62 5 2191 2191 0/ 1 1/ 1 0/ 1
c00000000bac2398 soctcp sqlexec 22958 189 7 370 369 0/ 1 1/ 1 0/ 0
c00000000eec3d48 soctcp sqlexec 22951 186 8 802 802 0/ 1 0/ 1 0/ 0
c000000012c688a0 soctcp sqlexec 22952 113 7 290 297 0/ 1 1/ 1 0/ 0
c00000000bd4a8c8 soctcp sqlexec 22951 13 5 2059 2059 0/ 1 1/ 1 0/ 0
c000000008f2d8a0 soctcp sqlexec 22929 135 8 596 596 0/ 1 0/ 1 0/ 0
c0000000115e4d28 soctcp sqlexec 22936 141 5 1496 1496 0/ 1 0/ 1 0/ 0
c00000000d23ad18 soctcp sqlexec 22936 59 8 2791 2791 0/ 1 1/ 1 0/ 0
c00000000b17fc68 soctcp sqlexec 22929 57 8 1081 1083 0/ 1 1/ 1 0/ 0
c000000012be3150 soctcp sqlexec 22920 123 7 834 834 0/ 1 0/ 1 0/ 0
c000000011de5028 soctcp sqlexec 22920 126 7 1261 1261 0/ 1 1/ 1 0/ 0
c000000012e42cb8 soctcp sqlexec 22897 43 6 710 712 0/ 1 0/ 1 0/ 0
c000000010bf2510 soctcp sqlexec 22897 31 5 1200 1200 0/ 1 1/ 1 0/ 0
c00000001288cfb8 soctcp sqlexec 22895 139 8 1276 1276 0/ 1 0/ 1 0/ 0
c000000012de27d8 soctcp sqlexec 22895 115 6 2155 2155 0/ 1 1/ 1 0/ 0
c00000001127e028 soctcp sqlexec 22889 112 7 1791 1791 0/ 1 0/ 1 0/ 0
c00000000c4e0888 soctcp sqlexec 22889 23 8 3424 3424 0/ 1 1/ 1 0/ 0
c00000000888c6e8 soctcp sqlexec 22853 196 6 1439 1439 0/ 1 0/ 1 0/ 0
c000000012a9dd48 soctcp sqlexec 22853 42 5 1685 1685 0/ 1 1/ 1 0/ 0
c000000012de2d10 soctcp sqlexec 22850 194 8 1777 1761 0/ 2 1/ 1 0/ 0
c000000008ee8160 soctcp sqlexec 22834 159 6 3491 3491 0/ 1 0/ 1 0/ 0
c00000001109a8a0 soctcp sqlexec 22834 114 6 9820 9820 0/ 1 1/ 1 0/ 1
c00000000c307700 soctcp sqlexec 22827 177 5 1401 1401 0/ 1 0/ 1 0/ 0
c000000009b33c80 soctcp sqlexec 22827 150 8 3177 3177 0/ 1 1/ 1 0/ 0
c000000012b86c80 soctcp sqlexec 22795 183 5 1355 1355 0/ 1 1/ 1 0/ 0
c0000000111442e8 soctcp sqlexec 22768 133 6 114 114 0/ 1 1/ 1 0/ 0
c00000000f88fa60 soctcp sqlexec 22767 3 5 59 59 0/ 1 1/ 1 0/ 0
c00000001214f918 soctcp sqlexec 22762 124 8 6629 6629 0/ 1 0/ 1 0/ 0
c000000012056d50 soctcp sqlexec 22762 117 5 7931 7931 0/ 1 1/ 1 0/ 0
c000000012850028 soctcp sqlexec 22683 160 7 755 755 0/ 1 0/ 1 0/ 0
c00000000f169450 soctcp sqlexec 22683 71 5 1651 1651 0/ 1 1/ 1 0/ 0
c000000011d7a050 soctcp sqlexec 22658 138 5 263 263 0/ 1 0/ 1 0/ 0
c00000000bd07238 soctcp sqlexec 22658 132 8 132 132 0/ 1 1/ 1 0/ 0
c0000000113c0400 soctcp sqlexec 22575 14 5 2116 2147 0/ 2 1/ 1 0/ 0
c000000010e1f028 soctcp sqlexec 22560 32 5 24740 24742 0/ 1 1/ 1 0/ 0
c00000000f88f720 soctcp sqlexec 22555 18 8 295 302 0/ 1 1/ 1 0/ 0
c00000000f7ee050 soctcp sqlexec 22491 77 6 5337 5337 0/ 1 0/ 1 0/ 0
c0000000131cfbc8 soctcp sqlexec 22491 24 6 7585 7585 0/ 1 1/ 1 0/ 0
c000000011ec6050 soctcp sqlexec 22479 12 6 2667 2667 0/ 1 0/ 1 0/ 0
c00000001186b9f8 soctcp sqlexec 22479 69 8 4285 4285 0/ 1 1/ 1 0/ 0
c000000012056028 soctcp sqlexec 22453 64 6 1421 1421 0/ 1 1/ 1 0/ 0
c00000000f763458 soctcp sqlexec 22390 134 6 14 14 0/ 1 1/ 1 0/ 0
c00000000a988be8 soctcp sqlexec 22389 2 5 44 44 0/ 1 1/ 1 0/ 0
c000000010dbe028 soctcp sqlexec 22352 84 7 5672 5673 0/ 1 1/ 1 0/ 0
c00000000b3bfb88 soctcp sqlexec 22352 55 6 9308 9307 0/ 1 1/ 1 0/ 0
c0000000123b3b30 soctcp sqlexec 22348 142 6 84 84 0/ 1 1/ 1 0/ 0
c0000000129243b8 soctcp sqlexec 22347 83 5 49 49 0/ 1 1/ 1 0/ 0
c000000012111310 soctcp sqlexec 22143 119 6 297 297 0/ 1 0/ 1 0/ 0
c0000000116f9c80 soctcp sqlexec 22144 98 5 655 655 1/ 1 0/ 1 0/ 0
c00000001239c2e8 soctcp sqlexec 22143 70 8 9058 9332 0/ 1 1/ 1 0/ 0
c000000011282c58 soctcp sqlexec 22035 131 8 35 35 0/ 1 1/ 1 0/ 0
c00000000abdbbf8 soctcp sqlexec 21961 104 8 219 219 0/ 1 1/ 1 0/ 0
c000000011e95c80 soctcp sqlexec 21960 21 7 424 424 0/ 1 1/ 1 0/ 0
c0000000126afcf8 soctcp ontape 21915 44 7 210 209 0/ 1 1/ 1 0/ 0
c00000000a578050 soctcp sqlexec 21863 25 8 1431 1431 0/ 1 0/ 1 0/ 0
c000000011bf9748 soctcp sqlexec 21864 15 5 1250 1258 0/ 1 1/ 1 0/ 0
c0000000129fb740 soctcp sqlexec 21863 30 8 58580 58787 0/ 1 1/ 1 0/ 0
c000000010fc4028 soctcp srvinfx 21728 101 6 120 120 0/ 1 1/ 1 0/ 0
c000000010e3eeb8 soctcp sqlexec 21708 121 5 1580 1615 0/ 1 1/ 1 0/ 0
c00000000a498028 soctcp sqlexec 21706 39 5 1792 2038 0/ 1 1/ 1 0/ 0
c000000010fa0458 soctcp sqlexec 21705 61 8 272 279 0/ 1 1/ 1 0/ 0
c00000000f56a078 soctcp sqlexec 21478 7 8 25340 25339 0/ 1 1/ 1 0/ 0
c000000011f62230 soctcp sqlexec 21471 106 6 2201 2237 0/ 2 1/ 1 0/ 0
c000000011ccf308 soctcp sqlexec 21134 29 7 53 53 0/ 1 1/ 1 0/ 0
c00000000bd00078 soctcp sqlexec 21121 146 6 3821 3821 0/ 1 1/ 1 0/ 0
c00000001106f8a0 soctcp sqlexec 21120 93 5 79 79 0/ 1 1/ 1 0/ 0
c00000000a8418c8 soctcp sqlexec 21045 89 8 298 298 0/ 1 1/ 1 0/ 0
c00000000c9391e8 soctcp sqlexec 21043 129 6 199 199 0/ 1 1/ 1 0/ 0
c0000000121f6480 soctcp sqlexec 21011 163 8 323 323 0/ 1 0/ 1 0/ 0
c00000000bac68a0 soctcp sqlexec 21012 51 5 1429 1549 0/ 1 1/ 1 0/ 0
c00000000cc788d8 soctcp sqlexec 21011 154 8 4139 4270 0/ 1 1/ 1 0/ 0
c00000000f70d288 soctcp sqlexec 20828 180 5 206 206 0/ 1 0/ 1 0/ 0
c00000000d8707b8 soctcp sqlexec 20829 170 8 767 775 0/ 1 1/ 1 0/ 0
c000000010e35858 soctcp sqlexec 20828 174 7 2015 2138 0/ 1 1/ 1 0/ 0
c000000011aab430 soctcp sqlexec 20513 127 8 760 760 0/ 1 1/ 1 0/ 0
c0000000120bdb00 soctcp sqlexec 20431 120 5 159 160 0/ 1 1/ 1 0/ 0
c00000000b9f2828 soctcp sqlexec 20422 37 8 434 441 0/ 1 1/ 1 0/ 0
c000000011d6ac58 soctcp sqlexec 20398 52 7 835 835 0/ 1 1/ 1 0/ 0
c00000000f3e9b68 soctcp sqlexec 20397 79 6 84 84 0/ 1 1/ 1 0/ 0
c000000012fb1b88 soctcp sqlexec 20023 54 8 1736 1736 0/ 1 0/ 1 0/ 0
c00000000f004260 soctcp sqlexec 20024 74 6 3952 3976 0/ 1 1/ 1 0/ 0
c00000000d809ab8 soctcp sqlexec 20023 73 5 88767 89066 0/ 1 1/ 1 0/ 0
c0000000111ba028 soctcp sqlexec 19973 60 6 144 144 0/ 1 1/ 1 0/ 0
c00000000a7a22b0 soctcp sqlexec 19972 46 5 129 129 0/ 1 1/ 1 0/ 0
c000000010f73c80 soctcp sqlexec 19968 50 7 6961 6961 0/ 1 1/ 1 0/ 0
c00000000f676888 soctcp sqlexec 19967 49 6 69 69 0/ 1 1/ 1 0/ 0
c00000000bac2778 soctcp sqlexec 19960 19 8 734 734 0/ 1 1/ 1 0/ 0
c000000012d8f050 soctcp sqlexec 19959 22 7 64 64 0/ 1 1/ 1 0/ 0
c00000000862fb20 ipcshm sm_discon 11 0 0 0 0 0/ 0 0/ 0 0/ 0
c00000000862da40 ipcshm sm_listen 9 0 0 0 0 0/ 0 0/ 0 0/ 0
c000000008617028 soctcp soctcplst 7 1 5 3687 0 0/ 0 0/ 0 0/ 0
c0000000085ed028 ipcshm sm_poll 6 0 0 0 0 0/ 0 0/ 0 0/ 0
c000000008576cb0 soctcp soctcppoll 5 0 8 704370 0 0/ 0 0/ 0 0/ 0
c0000000085769f0 soctcp soctcppoll 4 0 7 769458 0 0/ 0 0/ 0 0/ 0
c000000008576560 soctcp soctcppoll 3 0 6 962473 0 0/ 0 0/ 0 0/ 0
c00000000855b028 soctcp soctcppoll 2 0 5 815509 0 0/ 0 0/ 0 0/ 0
Messages In This Thread
- Problemas de desempeño con soctcp
NANDO G -- Thursday, 26 February 2004, at 4:53 p.m.
IIUG Espaņol is maintained by Administrator with WebBBS 5.12.
|
|
