IDS Forum

Performance problems soctcp

Posted By: NANDO G
Date: Wednesday, 25 February 2004, at 5:02 p.m.

Good afternoon,

I have 2 computers HewlettPackard R390 Series 9000 model 800, each one with HP-ux 11 (64bits) and IDS 9.30.FC4.

At the moment I have performance problems when I make conexines between servers, that is to say, when I make a "Select" that goes of a the server "A" a server "B" like for example:

If I am in Servant "B" and attempt to make the following sentence using "isqlrf":

Select * from db@B:tab1

Although table "B" has 7 registries can be gotten to delay of 2 to 5 seconds in giving back the information, this for our system that makes many tranascciones between the servants "A" and "B" is too much time.

How can improve the type of conección or how I can use that he is more efficient; At the moment I use the parameter NETTYPE thus "NETTYPE soctcp, 4, 60, NET" Them "onconfig" of the server to see that they suggest

Thanks !

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

IDS Forum is maintained by Administrator with WebBBS 5.12.