Did the DBA set this Onconfig Correct ?.

Any one have any Ideas as to why this box would be slow, the load is never over .5. nor is the % idle below 95%.. The only thing I can come up with is memory issues, b/c bufwaits are 20 Million +, and check points take about a minute. Cpu's : 6 Memory : 1Gig #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: INFORMIX-OnLine Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /inf_root_1 # Path for device containing root dbspace ROOTOFFSET 32 # Offset of root dbspace into device (Kbytes) ROOTSIZE 500000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters #MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRROR 1 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirroredroot MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS physx001 # Location (dbspace) of physical log PHYSFILE 370000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 33 # Number of logical log files LOGSIZE 100000 # Logical log size (Kbytes) # Diagnostics MSGPATH /informix_7/logs/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /informix_7/etc/log_full.sh # Alarm program path # System Archive Tape Device #TAPEDEV /dev/rmt/1mb # Tape device path #TAPEDEV /dev/rmt/0mbn # Tape device path TAPEDEV /dev/null # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 4000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt/1hbn # Tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 4000000 # Maximum amount of data to put on tape (Kbytes) # Optical #STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area #DBSERVERNAME nywebprd1 # Name of default database server DBSERVERNAME nywebqa1 # Name of default database server DBSERVERALIASES nywebprd1_i01p,nywebqa1_i01p#DBSERVERALIASES nywebprd1_i01p NETTYPE tlitcp,10,125,NET # Configure poll thread(s) for nettype NETTYPE ipcshm,3,300,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor #NUMCPUVPS 17 # Number of user (cpu) vps NUMCPUVPS 5 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors#AFF_SPROC 1 # Affinity start processor #AFF_NPROCS 2 # Affinity number of processors # Shared Memory Parameters LOCKS 100000 # Maximum number of locks BUFFERS 150000 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 40 # Maximum number of logical log files #CLEANERS 48 # Number of buffer cleaner processes CLEANERS 128 # Number of buffer cleaner processes SHMBASE 0xa000000 # Shared memory base address SHMVIRTSIZE 400000 # initial virtual shared memory segmentsize SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 800000 # Total shared memory (Kbytes). 0=>unlimited#CKPTINTVL 900 # Check point interval (in sec) CKPTINTVL 300 # Check point interval (in sec) LRUS 128 # Number of LRU queues LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit LTXHWM 30 # Long transaction high water markpercentage LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # 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 of offline workerthreads ON_RECVRY_THREADS 6 # Default number of online workerthreads # Data Replication Variables # DRAUTO: 0 manual, 1 retain type, 2 reverse type DRAUTO 0 # DR automatic switchover DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /usr/informix_7/etc/dr.lostfound # DR lost+found filepath # CDR Variables CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes) 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) # Backup/Restore variables BAR_ACT_LOG /informix_7/logs/bar_act.log BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 # Read Ahead Variables RA_PAGES 64 # Number of pages to attempt to readahead RA_THRESHOLD 32 # 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 tempx001:tempx002:tempx003:tempx004 # Default temp dbspaces #DBSPACETEMP t

In article <397CCD19.4729AEAF@cmgisolutions.com>, Corey Gorman <corey.gorman@cmgisolutions.com> writes > Any one have any Ideas as to why this box would be slow, the load is >never over .5. nor is the % idle below 95%.. > The only thing I can come up with is memory issues, b/c bufwaits are >20 Million +, and check points take about a minute. > > >Cpu's : 6 >Memory : 1Gig > >#************************************************************************** > ># ># INFORMIX SOFTWARE, INC. ># ># Title: onconfig.std ># Description: INFORMIX-OnLine Configuration Parameters ># >#************************************************************************** > ># Root Dbspace Configuration > >ROOTNAME rootdbs # Root dbspace name >ROOTPATH /inf_root_1> # Path for device containing root >dbspace >ROOTOFFSET 32 # Offset of root dbspace into device >(Kbytes) >ROOTSIZE 500000 # Size of root dbspace (Kbytes)> ># Disk Mirroring Configuration Parameters > >#MIRROR 0 # Mirroring flag (Yes = 1, No = 0) >MIRROR 1 # Mirroring flag (Yes = 1, No = 0) >MIRRORPATH # Path for device containing mirrored>root >MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> ># Physical Log Configuration > >PHYSDBS physx001 # Location (dbspace) of physical log >PHYSFILE 370000 # Physical log file size (Kbytes)> ># Logical Log Configuration > >LOGFILES 33 # Number of logical log files >LOGSIZE 100000 # Logical log size (Kbytes)> ># Diagnostics > >MSGPATH /informix_7/logs/online.log # System message log file >path >CONSOLE /dev/console # System console message path >ALARMPROGRAM /informix_7/etc/log_full.sh # Alarm program path> ># System Archive Tape Device > >#TAPEDEV /dev/rmt/1mb # Tape device path >#TAPEDEV /dev/rmt/0mbn # Tape device path >TAPEDEV /dev/null # Tape device path >TAPEBLK 16 # Tape block size (Kbytes) >TAPESIZE 4000000 # Maximum amount of data to put on tape >(Kbytes)> If you are using ontape for backups then set TAPEBLK=1024 ># Log Archive Tape Device >LTAPEDEV /dev/rmt/1hbn # Tape device path >LTAPEBLK 16 # Log tape block size (Kbytes) >LTAPESIZE 4000000 # Maximum amount of data to put on tape >(Kbytes)> Change LTAPEBLK to 128 ># Optical > > >#STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area > >#DBSERVERNAME nywebprd1 # Name of default database server >DBSERVERNAME nywebqa1 # Name of default database server >DBSERVERALIASES nywebprd1_i01p,nywebqa1_i01p>#DBSERVERALIASES nywebprd1_i01p > >NETTYPE tlitcp,10,125,NET # Configure poll thread(s) for nettype tlitcp,6,125,NET ^ 6 threads = number of CPUS > >NETTYPE ipcshm,3,300,CPU # Configure poll thread(s) for nettype ipcshm,6,150,CPU ^ 6 threads >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 17 # Number of user (cpu) vps >NUMCPUVPS 5 # Number of user (cpu) vps >SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps>to one > >NOAGE 1 # Process aging >AFF_SPROC 0 # Affinity start processor >AFF_NPROCS 0 # Affinity number of processors>#AFF_SPROC 1 # Affinity start processor >#AFF_NPROCS 2 # Affinity number of processors AFF_SPROC=1 AFF_NPROCS=5 pin the CPU VPS ># Shared Memory Parameters > >LOCKS 100000 # Maximum number of locks >BUFFERS 150000 # Maximum number of shared buffers >NUMAIOVPS 2 # Number of IO vps >PHYSBUFF 32 # Physical log buffer size (Kbytes) >LOGBUFF 32 # Logical log buffer size (Kbytes)>LOGSMAX 40 # Maximum number of logical log files >#CLEANERS 48 # Number of buffer cleaner processes >CLEANERS 128 # Number of buffer cleaner processes >SHMBASE 0xa000000 # Shared memory base address >SHMVIRTSIZE 400000 # initial virtual shared memory segment>size >SHMADD 200000 # Size of new shared memory segments >(Kbytes) >SHMTOTAL 800000 # Total shared memory (Kbytes). >0=>unlimited Which platform are you on? SHMTOTAL only needs to be non-zero for NCR platforms where if share memory gets close to physical memory the UNIX kernel can panic. >#CKPTINTVL 900 # Check point interval (in sec) >CKPTINTVL 300 # Check point interval (in sec) >LRUS 128 # Number of LRU queues >LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning limit > >LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit >LTXHWM 30 # Long transaction high water mark>percentage >LTXEHWM 60 # Long transaction high water mark >(exclusive) >TXTIMEOUT 0x12c # 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 of offline worker>threads >ON_RECVRY_THREADS 6 # Default number of online worker>threads > ># Data Replication Variables ># DRAUTO: 0 manual, 1 retain type, 2 reverse type >DRAUTO 0 # DR automatic switchover >DRINTERVAL 30 # DR max time between DR buffer flushes >(in sec) >DRTIMEOUT 30 # DR network timeout (in sec) >DRLOSTFOUND /usr/informix_7/etc/dr.lostfound # DR lost+found file>path > ># CDR Variables >CDR_LOGBUFFERS 2048 # size of log reading buffer pool >(Kbytes) >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)> ># Backup/Restore variables >BAR_ACT_LOG /informix_7/logs/