Re: informix parameters in onconfig file

In article <37E80BC8.A3377C80@wsisiz.edu.pl>, edem <sztuka@wsisiz.edu.pl> writes >Can anyone advise me what can i make better in onconfig file >Informix 7.30FC7 ( will be 7.31FC2 soon ) on HP-UX 11 ( machine V2500 6 >processors) >i am using kaio ( kaioon=1 ) >Any advise will be very helpful >Thanks! > >And this is my onconfig file : >#************************************************************************** > ># ># INFORMIX SOFTWARE, INC. ># ># Title: onconfig.std ># Description: Informix Dynamic Server Configuration Parameters ># >#************************************************************************** > ># Root Dbspace Configuration > >ROOTNAME rootdbs # Root dbspace name >ROOTPATH /opt/informix/chunki/r01.inf2> # Path for device containing root >dbspace >ROOTOFFSET 20 # Offset of root dbspace into device >(Kbytes) >ROOTSIZE 200000 # 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 physdbs # Location (dbspace) of physical log >PHYSFILE 50000 # Physical log file size (Kbytes)> ># Logical Log Configuration > >LOGFILES 39 # Number of logical log files >LOGSIZE 10240 # Logical log size (Kbytes)> Have more smaller logfiles since they only get backed up wen full, hence the log data is backedup sooner with smaller log files. I normally go 1000 x 250k. Remember you can have up to 32767 logfiles1 ># Diagnostics > >MSGPATH /opt/informix/inf2.log # System message log file path >CONSOLE /dev/null # System console message path >ALARMPROGRAM /opt/informix/etc/log_full.sh # Alarm program path>SYSALARMPROGRAM /opt/informix/etc/evidence.sh # System Alarm program >path >TBLSPACE_STATS 1> ># System Archive Tape Device >#TAPEDEV /dev/null >TAPEDEV /archive/archive0 >TAPEBLK 16 # Tape block size (Kbytes) Increase block size, try 64 then 126 then 256 and see if the time for archives drops. >TAPESIZE 20000000 # Maximum amount of data to put on tape >(Kbytes)> ># Log Archive Tape Device > >#LTAPEDEV /dev/null >LTAPEDEV /dev/rmt/0mn # Log tape device path >LTAPEBLK 16 # Log tape block size (Kbytes) Same here 64,128,256 >LTAPESIZE 4000000 # Max amount of data to put on log tape >(Kbytes)> ># Optical > >STAGEBLOB # Informix Dynamic Server/Optical >staging area > ># System Configuration > >SERVERNUM 2 # Unique id corresponding to a Dynamic>Server instance >DBSERVERNAME inf2 # Name of default database server>DBSERVERALIASES inf2s,inf2o,inf2r # List of alternate dbservernames >#NETTYPE sqlmux # Configure poll thread(s) for nettype >NETTYPE soctcp,5,128,CPU # Configure poll thread(s) for nettype soctcp should be on NET not CPU! >NETTYPE soctcp,5,128,NET # Configure poll thread(s) for nettype >NETTYPE ipcshm,1,32,CPU # Configure poll thread(s) for nettype >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 6 # 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> Set these to 1/6 or 0/6 depends upon machine ># Shared Memory Parameters > >LOCKS 8000000 # Maximum number of locks >BUFFERS 2000000 # Maximum number of shared buffers >NUMAIOVPS 2 # Number of IO vps >PHYSBUFF 64 # Physical log buffer size (Kbytes) >LOGBUFF 64 # Logical log buffer size (Kbytes)>LOGSMAX 500 # Maximum number of logical log files >CLEANERS 127 # Number of buffer cleaner processes Seems high, how many chunks do you have? >SHMBASE 0x0 # Shared memory base address >SHMADD 65535 # Size of new shared memory segments >(Kbytes) >SHMTOTAL 0 # Total shared memory (Kbytes). >0=>unlimited >CKPTINTVL 300 # Check point interval (in sec) >LRUS 127 # Number of LRU queues >LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning limit > >LRU_MIN_DIRTY 0 # 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 512 # Stack size (Kbytes) Default is 32, why did you increase it (recursive SPL's??). > ># System Page Size ># BUFFSIZE - Dynamic Server no longer supports this configuration >parameter. ># To determine the page size used by Dynamic Server 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 50 # 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 /opt/informix/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 /tmp/bar_act.log >BAR_MAX_BACKUP 0 >BAR_RETRY 1 >BAR_NB_XPORT_COUNT 10 >BAR_XFER_BUF_SIZE 31> ># Informix Storage Manager variables >ISM_DATA_POOL ISMData # If the data pool name is changed, be >sure to >

Thanks all for answers ! $ onstat -g seg Informix Dynamic Server Version 7.30.FC7 -- On-Line (Prim) -- Up 05:31:56 -- 6551032 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 76800 1381517313 c000000000172000 4294705152 66664 R* 524256 0 25605 1381517314 c000000100132000 2413551616 37480 V* 115585 179038 19462 1381517315 c00000018fef0000 425984 656 M 45 7 Total: - - 6708682752 - - 639886 179045 (* segment locked in memory) onstat -d: Informix Dynamic Server Version 7.30.FC7 -- On-Line (Prim) -- Up 05:35:11 -- 6551032 Kbytes Dbspaces address number flags fchunk nchunks flags owner name c00000013230c1d8 1 1001 1 1 N informix rootdbs c000000133195f38 2 1 2 1 N informix physdbs c00000013342fc40 3 1 3 1 N informix llogdbs c00000013342fd28 4 1 4 8 N informix dbs1 c00000013342fe10 5 1 9 8 N informix dbs2 c00000013342fef8 6 1 14 8 N informix dbs3 c000000133430028 7 1 19 8 N informix dbs4 c000000133430110 8 1 24 8 N informix dbs5 c0000001334301f8 9 2001 29 1 N T informix tempdbs1 c0000001334302e0 10 2001 30 1 N T informix tempdbs2 c0000001334303c8 11 2001 31 1 N T informix tempdbs3 c0000001334304b0 12 2001 32 1 N T informix tempdbs4 c000000133430598 13 2001 33 1 N T informix tempdbs5 c000000133430680 14 2001 34 1 N T informix tempdbs6 14 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname c00000013230c2c0 1 1 10 100000 34087 PO- /opt/informix/chunki/r01.inf2 c000000133194cd0 2 2 10 100000 74947 PO- /opt/informix/chunki/p01.inf2 c000000133194dc8 3 3 10 250000 50267 PO- /opt/informix/chunki/l01.inf2 c000000133194ec0 4 4 10 950000 11 PO- /opt/informix/chunki/d11.inf2 c000000133194fb8 5 4 10 950000 5 PO- /opt/informix/chunki/d12.inf2 c0000001331950b0 6 4 10 950000 149 PO- /opt/informix/chunki/d13.inf2 c0000001331951a8 7 4 10 950000 213 PO- /opt/informix/chunki/d14.inf2 c0000001331952a0 8 4 10 950000 1 PO- /opt/informix/chunki/d15.inf2 c000000133195398 9 5 10 950000 9 PO- /opt/informix/chunki/d21.inf2 c000000133195490 10 5 10 950000 9 PO- /opt/informix/chunki/d22.inf2 c000000133195588 11 5 10 950000 1 PO- /opt/informix/chunki/d23.inf2 c000000133195680 12 5 10 950000 13 PO- /opt/informix/chunki/d24.inf2 c000000133195778 13 5 10 950000 1 PO- /opt/informix/chunki/d25.inf2 c000000133195870 14 6 10 950000 13 PO- /opt/informix/chunki/d31.inf2 c000000133195968 15 6 10 950000 1 PO- /opt/informix/chunki/d32.inf2 c000000133195a60 16 6 10 950000 13 PO- /opt/informix/chunki/d33.inf2 c000000133195b58 17 6 10 950000 15 PO- /opt/informix/chunki/d34.inf2 c000000133195c50 18 6 10 950000 1 PO- /opt/informix/chunki/d35.inf2 c000000133195d48 19 7 10 950000 13 PO- /opt/informix/chunki/d41.inf2 c000000133195e40 20 7 10 950000 5 PO- /opt/informix/chunki/d42.inf2 c00000013342e028 21 7 10 950000 9 PO- /opt/informix/chunki/d43.inf2 c00000013342e120 22 7 10 950000 1 PO- /opt/informix/chunki/d44.inf2 c00000013342e218 23 7 10 950000 1 PO- /opt/informix/chunki/d45.inf2 c00000013342e310 24 8 10 950000 13 PO- /opt/informix/chunki/d51.inf2 c00000013342e408 25 8 10 950000 1 PO- /opt/informix/chunki/d52.inf2 c00000013342e500 26 8 10 950000 25 PO- /opt/informix/chunki/d53.inf2 c00000013342e5f8 27 8 10 950000 1 PO- /opt/informix/chunki/d54.inf2 c00000013342e6f0 28 8 10 950000 1 PO- /opt/informix/chunki/d55.inf2 c00000013342e7e8 29 9 10 250000 248233 PO- /opt/informix/chunki/t01.inf2 c00000013342e8e0 30 10 10 250000 248191 PO- /opt/informix/chunki/t02.inf2 c00000013342e9d8 31 11 10 250000 248217 PO- /opt/informix/chunki/t03.inf2 c00000013342ead0 32 12 10 250000 248105 PO- /opt/informix/chunki/t04.inf2 c00000013342ebc8 33 13 10 250000 248218 PO- /opt/informix/chunki/t05.inf2 c00000013342ecc0 34 14 10 250000 248153 PO- /opt/informix/chunki/t06.inf2 c00000013342edb8 35 4 10 600000 1 PO- /opt/informix/chunki/d18.inf2 c00000013342eeb0 36 5 10 600000 1 PO- /opt/informix/chunki/d28.inf2 c00000013342efa8 37 6 10 600000 1 PO- /opt/informix/chunki/d38.inf2 c00000013342f0a0 38 7 10 600000 174841 PO- /opt/informix/chunki/d48.inf2 c00000013342f198 39 8 10 600000 1 PO- /opt/informix/chunki/d58.inf2 c00000013342f290 40 4 10 1040000 1 PO- /opt/informix/chunki/d16.inf2 c00000013342f388 41 4 10 1040000 433757 PO- /opt/informix/chunki/d17.inf2 c00000013342f480 42 5 10 1040000 449325 PO- /opt/informix/chunki/d26.inf2 c00000013342f578 43 5 10 1040000 1039997 PO- /opt/informix/chunki/d27.inf2 c00000013342f670 44 6 10 1040000 710533 PO- /opt/informix/chunki/d36.inf2 c00000013342f768 45 6 10 1040000 1039997 PO- /opt/informix/chunki/d37.inf2 c00000013342f860 46 7 10 1040000 1039997 PO- /opt/informix/chunki/d46.inf2 c00000013342f958 47 7 10 1040000 1039997 PO- /opt/informix/chunki/d47.inf2 c00000013342fa50 48 8 10 1040000 792629 PO- /opt/informix/chunki/d56.inf2 c00000013342fb48 49 8 10 1040000 1039997 PO- /opt/informix/chunki/d57.inf2 49 active, 2047 maximum David Williams wrote: > In article <37E80BC8.A3377C80@wsisiz.edu.pl>, edem > <sztuka@wsisiz.edu.pl> writes > >Can anyone advise me what can i make better in onconfig file > >Informix 7.30FC7 ( will be 7.31FC2 soon ) on HP-UX 11 ( machine V2500 6 > >processors) > >i am using kaio ( kaioon=1 ) > >Any advise will be very helpful > >Thanks! > > > >And this is my onconfig file : > >#**********************************************************

In article <37E9B92D.8F1A8F74@wsisiz.edu.pl>, edem <sztuka@wsisiz.edu.pl> writes >Thanks all for answers ! > >$ onstat -g seg> >Informix Dynamic Server Version 7.30.FC7 -- On-Line (Prim) -- Up 05:31:56 -- >6551032 Kbytes > >Segment Summary: >id key addr size ovhd class blkused >blkfree >76800 1381517313 c000000000172000 4294705152 66664 R* 524256 0 >25605 1381517314 c000000100132000 2413551616 37480 V* 115585 >179038 >19462 1381517315 c00000018fef0000 425984 656 M 45 7 >Total: - - 6708682752 - - 639886 >179045 > > (* segment locked in memory) > 4Gb of RAM for resident and 2Gb virtual! what does onstat -D and onstat -g glo give? -- David Williams

onstat -g glo : Informix Dynamic Server Version 7.30.FC7 -- On-Line (Prim) -- Up 09:44:31 -- 6551032 Kbytes MT global info: sessions threads vps lngspins 487 700 12 536903 sched calls thread switches yield 0 yield n yield forever total: 101937911 84157903 21004772 290750 15888469 per sec: 5994 5766 871 31 718 Virtual processor summary: class vps usercpu syscpu total cpu 6 65909.75 10265.15 76174.90 aio 2 20.68 41.95 62.63 lio 1 3.49 12.04 15.53 pio 1 3.31 11.37 14.68 adm 1 2.80 6.99 9.79 msc 1 273.02 54.28 327.30 total 12 66213.05 10391.78 76604.83 Individual virtual processors: vp pid class usercpu syscpu total 1 3210 cpu 10898.49 2025.25 12923.74 2 3211 adm 2.80 6.99 9.79 3 3212 cpu 11165.98 1919.89 13085.87 4 3213 cpu 11038.89 1870.57 12909.46 5 3214 cpu 11055.66 1928.72 12984.38 6 3215 cpu 11173.83 1975.48 13149.31 7 3216 cpu 10576.90 545.24 11122.14 8 3217 lio 3.49 12.04 15.53 9 3218 pio 3.31 11.37 14.68 10 3219 aio 13.02 23.31 36.33 11 3220 msc 273.02 54.28 327.30 12 3221 aio 7.66 18.64 26.30 tot 66213.05 10391.78 76604.83 onstat -D: Informix Dynamic Server Version 7.30.FC7 -- On-Line (Prim) -- Up 09:44:41 -- 6551032 Kbytes Dbspaces address number flags fchunk nchunks flags owner name c00000013230c1d8 1 1001 1 1 N informix rootdbs c000000133191f38 2 1 2 1 N informix physdbs c00000013345fc40 3 1 3 1 N informix llogdbs c00000013345fd28 4 1 4 8 N informix dbs1 c00000013345fe10 5 1 9 8 N informix dbs2 c00000013345fef8 6 1 14 8 N informix dbs3 c000000133460028 7 1 19 8 N informix dbs4 c000000133460110 8 1 24 8 N informix dbs5 c0000001334601f8 9 2001 29 1 N T informix tempdbs1 c0000001334602e0 10 2001 30 1 N T informix tempdbs2 c0000001334603c8 11 2001 31 1 N T informix tempdbs3 c0000001334604b0 12 2001 32 1 N T informix tempdbs4 c000000133460598 13 2001 33 1 N T informix tempdbs5 c000000133460680 14 2001 34 1 N T informix tempdbs6 14 active, 2047 maximum Chunks address chk/dbs offset page Rd page Wr pathname c00000013230c2c0 1 1 10 1313 5654 /opt/informix/chunki/r01.inf2 c000000133190cd0 2 2 10 7 297626 /opt/informix/chunki/p01.inf2 c000000133190dc8 3 3 10 296787 279185 /opt/informix/chunki/l01.inf2 c000000133190ec0 4 4 10 24971 2870 /opt/informix/chunki/d11.inf2 c000000133190fb8 5 4 10 538170 1425 /opt/informix/chunki/d12.inf2 c0000001331910b0 6 4 10 348135 5216 /opt/informix/chunki/d13.inf2 c0000001331911a8 7 4 10 209374 4145 /opt/informix/chunki/d14.inf2 c0000001331912a0 8 4 10 228014 2284 /opt/informix/chunki/d15.inf2 c000000133191398 9 5 10 1510013 1844 /opt/informix/chunki/d21.inf2 c000000133191490 10 5 10 1272736 1371 /opt/informix/chunki/d22.inf2 c000000133191588 11 5 10 98450 380 /opt/informix/chunki/d23.inf2 c000000133191680 12 5 10 640025 965 /opt/informix/chunki/d24.inf2 c000000133191778 13 5 10 978230 882 /opt/informix/chunki/d25.inf2 c000000133191870 14 6 10 22479 2185 /opt/informix/chunki/d31.inf2 c000000133191968 15 6 10 252225 1219 /opt/informix/chunki/d32.inf2 c000000133191a60 16 6 10 339600 2043 /opt/informix/chunki/d33.inf2 c000000133191b58 17 6 10 174610 3630 /opt/informix/chunki/d34.inf2 c000000133191c50 18 6 10 121918 6739 /opt/informix/chunki/d35.inf2 c000000133191d48 19 7 10 764728 2479 /opt/informix/chunki/d41.inf2 c000000133191e40 20 7 10 148369 2908 /opt/informix/chunki/d42.inf2 c00000013345e028 21 7 10 446389 1535 /opt/informix/chunki/d43.inf2 c00000013345e120 22 7 10 570721 2927 /opt/informix/chunki/d44.inf2 c00000013345e218 23 7 10 141850 4179 /opt/informix/chunki/d45.inf2 c00000013345e310 24 8 10 746 1888 /opt/informix/chunki/d51.inf2 c00000013345e408 25 8 10 203968 2268 /opt/informix/chunki/d52.inf2 c00000013345e500 26 8 10 241619 579 /opt/informix/chunki/d53.inf2 c00000013345e5f8 27 8 10 247662 3088 /opt/informix/chunki/d54.inf2 c00000013345e6f0 28 8 10 46983 4436 /opt/informix/chunki/d55.inf2 c00000013345e7e8 29 9 10 268569 635296 /opt/informix/chunki/t01.inf2 c00000013345e8e0 30 10 10 241316 597133 /opt/informix/chunki/t02.inf2 c00000013345e9d8 31 11 10 229971 591269 /opt/informix/chunki/t03.inf2 c00000013345ead0 32 12 10 238999 597600 /opt/informix/chunki/t04.inf2 c00000013345ebc8 33 13 10 236394 598061 /opt/informix/chunki/t05.inf2 c00000013345ecc0 34 14 10 228331 593334 /opt/informix/chunki/t06.inf2 c00000013345edb8 35 4 10 49915 173 /opt/informix/chunki/d18.inf2 c00000013345eeb0 36 5 10 704220 1704 /opt/informix/chunki/d28.inf2 c00000013345efa8 37 6 10 129161 6635 /opt/informix/chunki/d38.inf2 c00000013345f0a0 38 7 10 220394 60645 /opt/informix/chunki/d48.inf2 c00000013345f198 39 8 10 70019 2611 /opt/informix/chunki/d58.inf2 c00000013345f290 40 4 10 86817 2969 /opt/informix/chunki/d16.inf2 c00000013345f388 41 4 10 83091 68699 /opt/informix/chunki/d17.inf2 c00000013345f480 42 5 10 722129 40085 /opt/informix/chunki/d26.inf2 c00000013345f578 43 5 10 1 0 /opt/informix/chunki/d27.inf2 c00000013345f670 44 6 10 124502 134742 /opt/informix/chunki/d36.inf2 c00000013345f768 45 6 10 1 0 /opt/informix/chunki/d37.inf2 c00000013345f860 46 7 10 1 0 /opt/informix/chunki/d46.inf2 c00000013345f958 47 7 10 1 0 /opt/informix/chunki/d47.inf2 c00000013345fa50 48 8 10 93405 44779 /opt/informix/chunki/d56.inf2 c00000013345fb48 49 8 10 1 0 /opt/informix/chunki/d57.inf2 49 active, 2047 maximum onstat -p : Informix Dynamic Server Version 7.30.FC7 -- On-Line (Prim) -- Up 09:48:01 -- 6 551032 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 10610767 13639