System is slow ...
OS: SCO UNIX -- OPEN SERVER 5.0
IX: OWS 7.20.UC2
I have one box with OWS installed on it. This instance
contains 4 dbspaces, and 4 respective databases. All
the users connect to their respective databases
through application written using Informix 4GL (c-code
version). The users are complaining that the system
response is slow.
Any suggestions, as how to improve the performance? I
am waiting anxiously for your valueable replies, and
comments.
Thanks.
My onconfig.ows file is as follows:
$ cat onconfig.ows
#**************************************************************************
## INFORMIX SOFTWARE, INC.
#
# Title: onconfig.ows
# Description: INFORMIX-OnLine Configuration
Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /u/IFMXDATA/AKU/ROOTDBS.000
ROOTOFFSET 0 # Offset of rootdbspace into device (Kbytes)
ROOTSIZE 20000 # Size of root dbspace
(Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1,
No = 0)
MIRRORPATH
MIRROROFFSET 0 # Offset into mirrored
device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace)
of physical log
PHYSFILE 2000 # Physical log file
size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logicallog files
LOGSIZE 1000 # Logical log size
(Kbytes)
# Diagnostics
MSGPATH /u/usr/informix/etc/online.log #
System message log file path
CONSOLE /dev/console # System consolemessage path
ALARMPROGRAM /u/usr/informix/etc/log_full.sh #
Alarm program path
# System Archive Tape Device
TAPEDEV /dev/rStp0
TAPEBLK 16 # Tape block size
(Kbytes)
TAPESIZE 4000000 # Maximum amount ofdata to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null
LTAPEBLK 16 # Log tape block size
(Kbytes)
LTAPESIZE 10240 # Max amount of datato put on log tape (Kbytes)
# Optical
STAGEBLOB #
INFORMIX-OnLine/Optical staging area
# System Configuration
SERVERNUM 0 # Unique idcorresponding to a OnLine instance
DBSERVERNAME AKU # Name of default databaseserver
DBSERVERALIASES AKU_shm # List of alternatedbservernames
NETTYPE tlitcp,1,,
NETTYPE ipcshm,1,,
DEADLOCK_TIMEOUT 60 # Max time to wait oflock in distributed env.
RESIDENT 0 # Forced residency
flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 forsingle-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu)vps
SINGLE_CPU_VP 0 # If non-zero, limitnumber of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity startprocessor
AFF_NPROCS 0 # Affinity number ofprocessors
# Shared Memory Parameters
LOCKS 2000 # Maximum number oflocks
BUFFERS 200 # Maximum number ofshared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer
size (Kbytes)
LOGBUFF 32 # Logical log buffer
size (Kbytes)LOGSMAX 6 # Maximum number of
logical log files
CLEANERS 1 # Number of buffercleaner processes
SHMBASE 0x10000000L # Shared memory baseaddress
SHMVIRTSIZE 8000 # initial virtualshared memory segment size
SHMADD 8192 # Size of new sharedmemory segments (Kbytes)
SHMTOTAL 0 # Total shared memory
(Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval
(in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirtybegin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirtyend cleaning limit
LTXHWM 50 # Long transactionhigh water mark percentage
LTXEHWM 60 # Long transactionhigh water mark (exclusive)
TXTIMEOUT 300 # Transaction timeout
(in sec)
STACKSIZE 32 # 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 ofoffline worker threads
ON_RECVRY_THREADS 1 # Default number ofonline worker threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automaticswitchover
DRINTERVAL 30 # DR max time betweenDR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout
(in sec)
DRLOSTFOUND /usr/informix/etc/dr.lostfound # DRlost+found file path
# Read Ahead Variables
RA_PAGES # Number of pages toattempt to read ahead
RA_THRESHOLD # Number of pages leftbefore 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 # Default tempdbspaces
# 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 /tmp # Preserve diagnosticsin this directory
DUMPSHMEM 1 # Dump a copy ofshared memory
DUMPGCORE 0 # Dump a core imageusing 'gcore'
DUMPCORE 0 # Dump a core image
(Warning:this aborts OnLine)
DUMPCNT 1 # Number of sharedmemory or gcore dumps for
# a single user's
session
FILLFACTOR 90 # Fill factor forbuilding index