Re: suggestion reqd Perf tuning

madh wrote: > this my onconfig file. I am using Informix Dynamic Server Version > 7.31.UD6W4, HP-UX 11.11 , > no of cpus- 2, REPORT SERVER (used for creating report purposes). > Memory 1387036K(1260472k) real, 1847708K (1682688k), virtual 4262876k > free pages, > Just want see some imporovement in cpu perf. > > shall i set AFF_NPROCS = 1 , > > ROOTNAME prd_my_rootdbs # Root dbspace name> > > ROOTPATH /dev/infdevprd_my/prd_my_rootdbs.1 > > > # Path for device containing root > dbspace > ROOTOFFSET 0 # Offset of root dbspace into device > (Kbytes) > ROOTSIZE 512000 # 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 prd_my_plogdbs1 # Location (dbspace) of physical log > > > PHYSFILE 200000 # Physical log file size (Kbytes)> > > # Logical Log Configuration > > > LOGFILES 40 # Number of logical log files> > > LOGSIZE 50000 # Logical log size (Kbytes)> > > # Diagnostics > > > MPATH /usr/informix__prd_my/logs/prd_my_srv.log > > > # System message log file path > > > CONSOLE /dev/console # System console message path> > > ALARMPROGRAM /usr/informix_prd_my/etc/no_log.sh # Alarm program > path SYSALARMPROGRAM /usr/informix__prd_my/etc/evidence.sh > > > # System Alarm program path > > > TBLSPACE_STATS 1> > > # System Archive Tape Device > > > TAPEDEV /dev/null # Tape device path> > > TAPEBLK 512 # Tape block size (Kbytes)> > > TAPESIZE 80000000 # Maximum amount of data to put on tape> > (Kbytes) > > > # Log Archive Tape Device > > > LTAPEDEV /dev/null # Log tape device path> > > LTAPEBLK 512 # Log tape block size (Kbytes)> > > LTAPESIZE 8000000 # Max amount of data to put on log tape> > (Kbytes) > > > # Optical > > > STAGEBLOB # Informix Dynamic Server/Optical > staging area > > > # System Configuration > > > SERVERNUM 3 # Unique id corresponding to a Dynamic> Server in > stance > > > DBSERVERNAME prd_my_srv # Name of default database server> > > DBSERVERALIASES # List of alternate dbservernames> > > NETTYPE soctcp,2,150,NET # 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 2 # 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> > > # Shared Memory Parameters > > > LOCKS 500000 # Maximum number of locks> > > BUFFERS 100000 # Maximum number of shared buffers> > > NUMAIOVPS 30 # Number of IO vps> > > PHYSBUFF 512 # Physical log buffer size (Kbytes)> > > LOGBUFF 512 # Logical log buffer size (Kbytes)> > > LOGSMAX 100 # Maximum number of logical log files > > > CLEANERS 20 # Number of buffer cleaner processes> > > SHMBASE 0x0 # Shared memory base address> > > SHMVIRTSIZE 256000 # initial virtual shared memory segment> > size > SHMADD 128000 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). > 0=>unlimited > CKPTINTVL 1200 # Check point interval (in sec)> > > LRUS 127 # Number of LRU queues> > > LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning> limit > LRU_MIN_DIRTY 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 32 # Stack size (Kbytes)> > > # 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 > > > # 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 > > > # 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__prd_my/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 (Kb > ytes)> > > CDR_LOGDELTA 30 # % of log space allowed in queue > memory > CDR_NUMCONNECT 16 # Expected connections per server > > > CDR_NIFRETRY 300 # Connection retry (seconds) > > > CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 > none, 9 ma > x)> > > # Backup/Restore variables > > > BAR_ACT_LOG /us