Re: ONCONFIG and AIX
Hi,
I would enable KAIO, too.
Apart from KAIO the B-Tree Scanner usually benefits from some
configuration:
>From my experience increasing threshold (default: 500) reduces I/O
significantly, enabling range scans (rangesize=500), too.
BTSCANNER num=1,prio=low,threshold=50000,rangesize=500,alice=5
For bigger systems the threshold is sometimes increased to about
200000.
You may monitor the B-Tree-Scanner using onstat -C ...
Fortunately you can change the settings online, e.g.
$ onmode -C threshold 50000
$ onmode -C rangesize 500
You found out RESIDENT is supported on AIX, now.
HTH,
--
Edgar
tomcaml@yahoo.com wrote:
> Hello All,
>
> I am looking for feedback, comments, etc.
>
> We are currently on IDS 10.FC4 on HP-UX 11
> - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595
>
> I have gotten this message in the log while performing some loads/alter
> tables/indexes, etc
> in development phase.
> "13:33:20 KAIO: out of OS resources, errno = 11, pid = 282828"
>
> I decided to turn off KAIO, which is what we have in our current Prod
> OLTP system on the HP's.
> Here is my ONCONFIG - thanks!
> Tom
>
> --------------------------------------------------------
> #**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.ol_tmsdb01
> # Description: Informix Dynamic Server Configuration Parameters
> #
> #**************************************************************************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /home/informix/chunk_links/rootdbs> # Path for device containing root
> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)> #ROOTSIZE 100000 # Size of root dbspace (Kbytes) - old
> size on rp01
> 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 /home/informix/chunk_links/mirror_rootdbs
> # Path for device containing mirrored
> root
> MIRROROFFSET 0 # Offset into mirrored device (Kbytes)>
> # Physical Log Configuration
>
> PHYSDBS phylogdbs # Location (dbspace) of physical log
> PHYSFILE 200000 # Physical log file size (Kbytes) was> 17000
>
> # Logical Log Configuration
>
> LOGFILES 110 # Number of logical log files
> LOGSIZE 70000 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /home/informix/iif2000/ids_10_FC5/Online.log
> # System message log file path
> CONSOLE /dev/console # System console message path>
> # To automatically backup logical logs, edit alarmprogram.sh and set
> # BACKUPLOGS=Y
>
> ALARMPROGRAM /home/informix/iif2000/ids_10_FC5/etc/alarmprogram.sh
> # Alarm program path
> TBLSPACE_STATS 1 # Maintain tblspace statistics>
> # System Archive Tape Device
>
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 32 # Tape block size (Kbytes)
> TAPESIZE 100000000 # Maximum amount of data to put on tape
> (Kbytes)>
> # Log Archive Tape Device
>
> LTAPEDEV /dev/rmt/0m # Log tape device path
> #LTAPEDEV /dev/null
> LTAPEBLK 32 # Log tape block size (Kbytes)
> LTAPESIZE 100000000 # Max amount of data to put on log tape
> (Kbytes)>
> # Optical
>
> STAGEBLOB # Informix Dynamic Server staging area
>
> # System Configuration
>
> SERVERNUM 0 # Unique id corresponding to a OnLine> instance
> DBSERVERNAME ol_tmsdb01 # Name of default database server
> DBSERVERALIASES ol_tmsdb01_shm # List of alternate dbservernames
> NETTYPE soctcp,2,100,NET # Configure poll thread(s) for nettype
> NETTYPE ipcshm,1,50,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 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> to one
> #NUMCPUVPS
> #NOAGE 0 # Process aging
> #AFF_SPROC 0 # Affinity start processor
> #AFF_NPROCS 0 # Affinity number of processors
>
> # Shared Memory Parameters
>
> LOCKS 1400000 # Maximum number of locks # was
> 1000000 01/29/04> #NUMAIOVPS # Number of IO vps
> PHYSBUFF 64 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)
> CLEANERS 80 # Number of buffer cleaner processes> #**SHMBASE 0x0 # Shared memory base address
> SHMBASE 0x700000000000000 # Shared memory base address
> SHMVIRTSIZE 3250000 # initial virtual shared memory segment
> size # was 824 mjb 3/8/04, was 1024000 4/27/04 tl, was 1280000
> 10/16/04 tl, 3000000 3/25/06
> SHMADD 128000 # Size of new shared memory segments
> (Kbytes) # was 64000 mjb 3/8/04
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 600 # Check point interval (in sec) ## was
> 300 2004/1/29
> TXTIMEOUT 0x2 # Transaction timeout (in sec)
> STACKSIZE 128 # Stack size (Kbytes)>
> # Dynamic Logging
> # DYNAMIC_LOGS:
> # 2 : server automatically add a new logical log when necessary.
> (ON)
> # 1 : notify DBA to add new logical logs when necessary. (ON)
> # 0 : cannot add logical log on the fly. (OFF)
> #
> # When dynamic logging is on, we can have higher values for
> LTXHWM/LTXEHWM,
> # because the server can add new logical logs during long transaction
> rollback.
> # However, to limit the number of new logical logs being added,
> LTXHWM/LTXEHWM
> # can be set to smaller values.
> #
> # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller
> values
> # to avoid long transaction rollback hanging the server due to lack of
> logical
> # log space, i.e. 50/60 or lower.
>
> DYNAMIC_LOGS 2
> LTXHWM 60
> LTXEHWM 70>
> # 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