Re: System tuning
Posted in 1996
On Mon, 25 Mar 1996, Dave Kosenko wrote:
> > I can include the values that we have in ONCONFIG, or any of the onstat
> > outputs. if that would help anyone make some sense of this.
>
> The full config file would be a good start.
Here it is, sans comments.
ROOTNAME dbs00ROOTPATH /dev/rdsk/dbi00
ROOTOFFSET 0
ROOTSIZE 99968
MIRRORPATH
MIRROROFFSET 0PHYSDBS dbs01
PHYSFILE 8000
LOGFILES 15
LOGSIZE 4000MSGPATH /home/informix/online.log
CONSOLE /dev/console
ALARMPROGRAM
TAPEDEV /dev/rmt/1
TAPEBLK 32
TAPESIZE 2048000
LTAPEDEV /dev/rmt/0
LTAPEBLK 32
LTAPESIZE 525000STAGEBLOB
SERVERNUM 0
DBSERVERNAME asl3
DBSERVERALIASES
NETTYPE ipcshm,,,
NETTYPE tlitcp,,,
DEADLOCK_TIMEOUT 60
RESIDENT 1
MULTIPROCESSOR 1
NUMCPUVPS 2
SINGLE_CPU_VP 0
NOAGE 0
AFF_SPROC 0
AFF_NPROCS 0USERTHREADS 80
TRANSACTIONS 100
LOCKS 20000
BUFFERS 16384TBLSPACES 400
CHUNKS 16
NUMAIOVPSDBSPACES 16
PHYSBUFF 32
LOGBUFF 32LOGSMAX 30
CLEANERS 10
SHMBASE 0x0
SHMVIRTSIZE 16384
SHMADD 4096
SHMTOTAL 0
CKPTINTVL 300
LRUS 20
LRU_MAX_DIRTY 60
LRU_MIN_DIRTY 50
LTXHWM 50
LTXEHWM 60
TXTIMEOUT 0x12c
STACKSIZE 32
OFF_RECVRY_THREADS 10
ON_RECVRY_THREADS 1
DRAUTO 0
DRINTERVAL 30
DRTIMEOUT 30
DRLOSTFOUND /usr/informix/etc/dr.lostfound
RA_PAGES
RA_THRESHOLDDBSPACETEMP dbs08,dbs09,dbs10
DUMPDIR /tmp
DUMPSHMEM 0
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1ADTMODE 0
ADTPATH /tmp
ADTSIZE 50000
ADTERR 0
FILLFACTOR 90
USEOSTIME 0PDQPRIORITY 0
MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DATASKIP off
OPTCOMPIND 1