Performance Problems with 7.30.UC7XB

Running Informix 7.30.UC7XB (for SAP) on HP-UX 10.20 -- machine is T520 w/4 processors and 1.75 Gb memory. EMC Symmetrix with HP-PB Fast/Wide SCSI connections. Experiencing cache-hit read % of < 80% (and needless to say, our users are screaming) onstat -g seg shows: Segment Summary: id key addr size ovhd class blkused blkfree 5897 1381386242 80000000 819200000 13108 V 60392 39608 5130 1381386243 c0931000 712704 620 M 80 7 6152 1381386241 c0d13000 540164096 9156 R 65932 6 Total: - - 1360076800 - - 126404 39621 onstat -p shows (a 6.5 minute sample) Informix Dynamic Server Version 7.30.UC7XB -- On-Line -- Up 02:43:58 -- 1327504 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 768443 1066750 3684443 79.14 9147 15228 38270 76.10 isamtot open start read write rewrite delete commit rollbk 1530220 5017 113613 1121266 6015 2116 2971 481 0 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 695.44 607.25 1 2 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 109937 8 1188516 0 0 5 932 81 ixda-RA idx-RA da-RA RA-pgsused lchwaits 648128 251 4837 386873 57477 environment variables that have been set (per info from SAP) NO_KEYFIRST=1 NO_SUBQF=1 SINGLESEG_OFF=1 DBBLOBBUF=64 onconfig file follows: # # C H A N G E . L O G # --------------------- # # rag-10/10/97 chg'd NUMCPUVPS from 2 to 4. # # rag-10/10/97 chg'd cause we added 768 mb mem to server. # is wuz # SHMVIRTSIZE 870000 450000 # BUFFERS 300000 210000 # # rag-10/10/97 chg'd per SAP Carl Rossini & Sari Nathans - Golive Perf.problem # # LRU_MAX_DIRTY 2 5 # LRU_MIN_DIRTY 1 3 # CLEANERS 30 40 # CKPTINTVL 600 900 (from 15 minutes to 10 minutes). # NETTYPE soctcp,1,120,CPU per Sari Nathans # # rag-10/09/97 chg'd per SAP Dave Green for SAP Golive performance problem. # # MULTIPROCESSOR 0 (cpu) 0=1 cpu, 1=2 cpu # NUMCPUVPS 1 (cpu) 1=1 cpu, 2=2 cpu # SINGLE_CPU_VP 1 (cpu) 1=1 cpu, 0=2 cpu # # rag-07/29/97 made following chenges per Sari Nathans # and EarlyWatch Subhash per Sari Nathans # new old # --- --- # LRUS 64 32 # NETTYPE soctcp,1,60,CPU soctcp,1,100,NET (and EarlyWatch) # RA_PAGES 32 8 # RA_THRESHOLD 30 4 # # # rag-06/04/97 NUMAIOVPS 10 -> 16 # Number of AIO vps. note 41360 # # mlc-03/03/97 MULTIPROCESSOR 1 (from 0) # NUMCPUVPS 2 (from 1) # SINGLE_CPU_VP 0 (from 1) # BUFFERS 210000 (from 70,000) # SHMVIRTSIZE 250000 (from 132,000) # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /informix/PRD/sapdata/physdev1/data1 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 600000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH /informix/PRD/sapdata/physdev2/data2 # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS physdbs # Location (dbspace) of physical log PHYSFILE 298894 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 200 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) rag-10/25/96 # Message Files MSGPATH /informix/PRD/online.chpfdb1.prd.log # System message log file path CONSOLE /informix/PRD/console.chpfdb1.prd.log # System console message path # System Archive Tape Device TAPEDEV /informix/tape # Tape device path rag-01/24/99 TAPESIZE 90000000 # rag-11/12/98 ##TAPEDEV /dev/tape120 # Tape device path rag-03/01/97 ##TAPESIZE 6000000 # rag-04/10/97 TAPEBLK 256 # Tape block size (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/tape120 # Log tape device path LTAPEBLK 256 # Log tape block size (Kbytes) LTAPESIZE 7000000 # Max amount of data to put on log tape (Kbytes)#LTAPEDEV /saplog/PRD # Log tape device path #LTAPEBLK 2048 # Log tape block size (Kbytes) #LTAPESIZE 4000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area # System Configuration SERVERNUM 0 # rag-02/08/96 id corresponding to a OnLineinstance DBSERVERNAME chpfdb1prdshm # Name of default database server DBSERVERALIASES chpfdb1prdtcp # List of alternate dbservernames NETTYPE ipcshm,1,60,CPU # Override sqlhosts nettype parameters NETTYPE soctcp,1,120,CPU # Override sqlhosts nettype parameters DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) # The following (3) parms relate to the number of CPU processors. # --------------------------------------------------------------- MULTIPROCESSOR 1 #(cpu) 0=1 cpu, 1=2 cpu. rag-10/11/97 NUMCPUVPS 4 #(cpu) 1=1 cpu, 2=2 cpu. rag-10/18/97 SINGLE_CPU_VP 0 #(cpu) 1=1 cpu, 0=2 cpu. rag-10/11/97 MUTEX_WAIT_LISTS 0 # If non-zero, force use of mutex wait lists NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor rag-08/25/96 AFF_NPROCS 0 # Affinity number of processors rag-08/25/96 # Shared Memory Parameters #LOCKS 768000 LOCKS 1500000 BUFFERS 210000 # Max shared buffers rag-06/12/1999 NUMAIOVPS 60 # Number of AIO vps. rag-06/12/1999 PHYSBUFF 1024 # Physical log buffer size (Kbytes) rag-08/08/96 LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 200 # Maximum number of logical log files CLEANERS 40 # Number of buffer cleaner p

Doug Agnew wrote: > > Running Informix 7.30.UC7XB (for SAP) on > HP-UX 10.20 -- machine is T520 w/4 processors and 1.75 Gb memory. EMC > Symmetrix with HP-PB Fast/Wide SCSI connections. > > Experiencing cache-hit read % of < 80% (and needless to say, our users are > screaming) > I'm assuming this is a circumstance that has just arisen (and looking at the onconfig) I'm also assuming you may have upgrade recently? We are experiencing a similar problem. Try onstat -P and see how many pages of your cache are being used for btree vs. data. This appears to be a "feature" of 7.30 that is difficult to reproduce in test situations. If this is the case, you may wish to raise an issue with Informix tech support. Dominic -- Dominic Binks/Systems Engineer/Logica-Aldiscon 400 Park Avenue/Aztec West/Bristol/BS32 4TR/United Kingdom Tel: +44 1454 614455/Fax: +44 1454 620527/Mobile: +44 498 693964 E-mail: dominic.binks@aethos.co.uk

In article <Lu4e3.2338$cW3.97@news1.mco>, "Doug Agnew" <dagnew@charlottepipe.com> wrote: > Running Informix 7.30.UC7XB (for SAP) on > HP-UX 10.20 -- machine is T520 w/4 processors and 1.75 Gb memory. EMC > Symmetrix with HP-PB Fast/Wide SCSI connections. > At first, SAP recommends RAID 5 for dbspaces. It's poor. If you are using RAID 5, migrate to RAID 0 or RAID 10 - this will _GREATLY_ improve situation. > > RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) Try to set this param to 1. It's critical for operation. > > NOAGE 0 # Process aging As far as I remember, HP-UX supports disabling priority aging. Set this to 1. > NUMAIOVPS 60 # Number of AIO vps. rag-06/12/1999 Ooops ! Why are you using AIO ? HP-UX supports KAIO, this will be faster. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.