Onstat -P output

--0-1958201504-1124376709=:23030 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Id: Content-Disposition: inline Hi, I'm using IDS9.21 UC6 running on a SOlaris 8.0 Operating system. The output of the onstat -P is not acceptable and I would appreciate it if I could be helped get a better results. The system is not performing well enough. Attached is the output of the onstat -p. I have also attached the onconfig file for the database configuration. please help. Leona Ghana Telecom Limited __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-1958201504-1124376709=:23030 Content-Type: text/plain; name=profilereport Content-Description: 77641972-profilereport Content-Disposition: inline; filename=profilereport Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line (Prim) -- Up 09:07:09 -- 3063808 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 19684838 20263046 442077955 95.55 154214 585984 701015 78.00 isamtot open start read write rewrite delete commit rollbk 293317600 2211956 672535038 2439958442 467066 100815 288 7332 58 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 55320.52 1476.21 248 542 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 669902 17 16555846 0 0 166 13625 88420 ixda-RA idx-RA da-RA RA-pgsused lchwaits 1382582 2081794 4439769 7891122 5540349 --0-1958201504-1124376709=:23030 Content-Type: text/plain; name=configuration Content-Description: 1832273169-configuration Content-Disposition: inline; filename=configuration #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: Informix Dynamic Server 2000 Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/online10_1 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2097150 # 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 rootdbs # Location (dbspace) of physical log PHYSFILE 50000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 800 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr/acct/informix/log/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /usr/acct/informix/IDS9.21/etc/no_log.sh # Alarm program path TBLSPACE_STATS 0 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/rdlt1c #/dev/rdlt1c # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 70000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rdatc # /dev/rdatc # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 8000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server 2000 staging area # System Configuration SERVERNUM 2 # Unique id corresponding to a OnLine instance DBSERVERNAME gtsun2 # Name of default database server DBSERVERALIASES gtsun2net # List of alternate dbservernames NETTYPE tlitcp,2,200,NET # Configure poll thread(s) for nettype NETTYPE ipcstr,1,50,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one # NUMCPUVPS 3 # Number of user (cpu) vps # NUMAIOVPS 4 # Number of IO vps # NOAGE 1 # Process aging # AFF_SPROC 0 # Affinity start processor # AFF_NPROCS 0 # Affinity number of processors VPCLASS CPU,NUM=3 VPCLASS AIO,NUM=3 # Shared Memory Parameters LOCKS 2500000 # Maximum number of locks BUFFERS 1200000 #512000 # Maximum number of shared buffers PHYSBUFF 64 #32 # Physical log buffer size (Kbytes) LOGBUFF 128 #64 # Logical log buffer size (Kbytes)LOGSMAX 1000 # Logical log buffer size (Kbytes) CLEANERS 8 #4 # Number of buffer cleaner processes SHMBASE 0xa000000 # Shared memory base address SHMVIRTSIZE 294912 # initial virtual shared memory segment size SHMADD 32768 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 120 # Check point interval (in sec) LRUS 32 #16 # Number of LRU queues LRU_MAX_DIRTY 8 #4 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 4 #2 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water mark percentage LTXEHWM 60 # Long transaction high water mark (exclusive) 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)@@N

We need more information as requested by Jay Konigsberg otherwise we're guessing a bit. Leona Ankrah wrote: > Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line (Prim) -- Up 09:07:09 -- 3063808 Kbytes Do you still have support for version 9.21.UC6? You should consider upgrading to 9.40 or 10.00. > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 19684838 20263046 442077955 95.55 154214 585984 701015 78.00 ^^^^^ ^^^^^ Your cached reads and particularly writes are low. Is this what you're dissatisfied with? > # Read Ahead Variables > RA_PAGES 128 # Number of pages to attempt to read ahead > RA_THRESHOLD 32 # Number of pages left before next group With the big caveat that I don't know your disc architecture (please post this), you could experiment with reducing these values substantially so that fewer extra pages are read into memory when disc reads take place. Ben.

Ben Thompson wrote: > We need more information as requested by Jay Konigsberg otherwise we're > guessing a bit. > > Leona Ankrah wrote: > >> Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line (Prim) -- >> Up 09:07:09 -- 3063808 Kbytes > > > Do you still have support for version 9.21.UC6? You should consider > upgrading to 9.40 or 10.00. > >> Profile >> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >> 19684838 20263046 442077955 95.55 154214 585984 701015 78.00 > > ^^^^^ ^^^^^ > > Your cached reads and particularly writes are low. Is this what you're > dissatisfied with? 700k writes vs 442M reads (1:500+); write performance is unlikely to be a major issue, and that percentage doesn't matter. The low read cache does matter; 1 read in 20 has to go to disk; you want nearer 1 in 100 (99% cache) if you can. Given the large memory already allocated, that may be hard to do. >> # Read Ahead Variables >> RA_PAGES 128 # Number of pages to attempt to read>> ahead >> RA_THRESHOLD 32 # Number of pages left before next group> > > With the big caveat that I don't know your disc architecture (please > post this), you could experiment with reducing these values > substantially so that fewer extra pages are read into memory when disc > reads take place. > > Ben. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/