Looks like you're cruising now! Nearly 100% reads from cache, >90% writes are
to cache, BR=0.20 BTR=0.72, RAU=100%. Good CPU VP balance the 1st 4 are taking
about 75% of the load and it's spread fairly evenly so responsiveness should be
noticably better now. Your CLEANERS are still 6 and should be >= LRUS so that
should be 16 for best checkpoint and cache flush performance.
You are still seeing almost all CHUNK writes because of the LRU_MAX/MIN_DIRTY
settings on the buffer pool of 20/10. If your checkpoints are not exceedingly
long (I suspect they are not) and external tasks are not contending for IO
bandwidth at checkpoint times, I'd leave it. If checkpoint duration is/becomes
a problem drop those down as low as 2/1 or even 1/0.5 and you'll see LRU writes
balancing out at about 70% of total.
Art S. Kagel
----- Original Message -----
From: Dave Thacker <ids@iiug.org>
At: 2/23 16:20:11
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN
wrote:
> For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections
> efficiently but I like to keep that below ~150 myself).
I added 2.
>
> #LRUs controls contention between users. In order to read new data into a
> buffer or to write/rewrite a buffer, the user much latch the LRU in which
the
> buffer is listed in order to move the buffer to the front of the LRU's queue
> or
> to move the buffer from the LRU's clean queue to its dirty queue. More LRUS
> mean less contention for LRU resources. Some buffer contention is cause by
> insufficient buffers, but most is from LRU contention. If you have more
users
> than LRUs then more LRUs will help.
I doubled the LRU's from 8 to 16.
>
> I also notice that you have only one AIO VP configured, even if you are
using
> only RAW devices you should have 2-3 configured. Add to that 1 to 1.5 per
> COOKED chunk.
All space is raw, but I changed from 1 to 3 anyway.
>
> What else do we need to see to help? Post the following:
>
> onstat -p (again - with the time since reset)
> onstat -d
> onstat -F
> onstat -R
> onstat -g glo
> onstat -g iov
> onstat -P (at least the summaries at the end, the partnum zero line, and any
> partnum lines that have a significant % of the buffer cache allocated to
them)
> onstat -g iof
>
> A full copy of the ONCONFIG file.
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Dave Thacker <ids@iiug.org>
> At: 2/22 17:12:14
>
> On Thu, 2007-02-22 at 16:35 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN
> wrote:
> > Your assumption is partially correct. You don't NEED all 6 CPU's allocated
> to
> > CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions
to
> > CPU
> > VPs as needed so it's possible that one or a few logical CPUS will be
harder
> > hit than the others. That said there are tunables that can affect that.
For
> > example if you are using shared memory connections to the instance you
> should
> > have ipcshm poll threads running in all 6 CPU VPs or the load will not be
> > balanced as well as it could be and responsiveness will suffer. I don't
see
> > any
> > NETTYPE entries in the partial ONCONFIG you posted so you're probably
> running
> > with the default of one poll thread.
>
> NETTYPE is at default. Workload is 90% TCP/10$ SHM. What type of
> threads should I add for soctcp?
> >
> > Also note that your instance is poorly tuned. BR is over 20 and values > 7
> > indicate a slow server needing more LRUs and more CLEANERS (and possibly
> more
> > BUFFERS). Your BTR (estimated since you didn't post any BUFFERS or
> BUFFERPOOL
> > parameters) looks very high indicating that you may need more buffers.
I suspected as much. Last night increased buffers from 12000 to 100000
Today's stats look much healthier.
I'm still not seeing any LRU writes, and I'm not sure why. The output
you asked for is posted below. Thank You for helping with this!
All stats were run 305 minutes after the last stats reset (onstat -z)
===========onstat -p===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits
%cached
2919 3085 184065849 100.00 34530 55350 364888
90.54
isamtot open start read write rewrite delete
commit rollbk
157746043 1243273 12306759 107186718 41753 69057 35664
53002 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 1802.65 1566.00 47 94
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits
===========onstat -d===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags
owner name
7000000201b5e78 1 0x60001 1 1 4096 N B
informix uswdbs
7000000201b6710 2 0x68001 2 1 4096 N SB
informix replsbdbs
7000000201b68a8 3 0x60001 3 1 4096 N B
informix repltxdbs
7000000201b6a40 4 0x60001 4 1 4096 N B
informix logdbs
7000000201b6bd8 5 0x60001 5 1 4096 N B
informix physlogdbs
7000000201b6d70 6 0x42001 6 1 4096 N TB
informix tmpdbs1
700000021146028 7 0x42001 7 1 4096 N TB
informix tmpdbs2
7000000211461c0 8 0x42001 8 1 4096 N TB
informix tmpdbs3
700000021146358 9 0x42001 9 1 4096 N TB
informix tmpdbs4
7000000211464f0 10 0x60001 10 1 4096 N B
informix uswdata1
10 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages
flags pathname
7000000201b6028 1 1 0 20000 11885
PO-B /usr/informix/links/uswdbs
7000000203a8910 2 2 20000 50000 46623 46624
POSB /usr/informix/links/uswdbs
Metadata 3323 2144 3323
7000000203a8ab0 3 3 70000 50000 49907
PO-B /usr/informix/links/uswdbs
7000000203a8c50 4 4 120000 25000 24947
PO-B /usr/informix/links/uswdbs
7000000203a8df0 5 5 145000 25000 24947
PO-B /usr/informix/links/uswdbs
700000020391c50 6 6 170000 25000 24947
PO-B /usr/informix/links/uswdbs
700000020391df0 7 7 195000 25000 24947
PO-B /usr/informix/links/uswdbs
7000000201b6230 8 8 220000 25000 24947
PO-B /usr/informix/links/uswdbs
7000000201b63d0 9 9 245000 25000 24947
PO-B /usr/informix/links/uswdbs
7000000201b6570 10 10 270000 500000 294141
PO-B /usr/informix/links/uswdbs
10 active, 32766 maximum
compress seqscans
751 20 34654452 0 0 29 3340
110132
ixda-RA idx-RA da-RA RA-pgsused lchwaits
287 248 0 535 20459
===========onstat -F===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
Fg Writes LRU Writes Chunk Writes
0 0 30832
address flusher state data
700000020358760 0 I 0 = 0X0
700000020358e98 1 I 0 = 0X0
7000000203595d0 2 I 0 = 0X0
700000020359d08 3 I 0 = 0X0
70000002035a440 4 I 0 = 0X0
70000002035ab78 5 I 0 = 0X0
states: Exit Idle Chunk Lru
===========onstat -R===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
Buffer pool page size: 4096
16 buffer LRU queue pairs priority levels
# f/m pair total % of length LOW HIGH
0 f 6250 99.1% 6195 5076 1119
1 m 0.9% 55 0 55
2 f 6250 99.2% 6199 5033 1166
3 m 0.8% 51 0 51
4 f 6250 99.1% 6194 5093 1101
5 m 0.9% 56 0 56
6 f 6250 98.9% 6184 5070 1114
7 m 1.1% 66 0 66
8 f 6250 99.0% 6190 5075 1115
9 m 1.0% 60 0 60
10 f 6250 98.9% 6183 5061 1122
11 m 1.1% 67 1 66
12 f 6250 99.1% 6193 5094 1099
13 m 0.9% 57 0 57
14 f 6250 99.1% 6195 5082 1113
15 m 0.9% 55 0 55
16 F 6250 99.3% 6204 5095 1109
17 m 0.7% 46 0 46
18 f 6250 99.0% 6187 5079 1108
19 m 1.0% 63 0 63
20 f 6250 98.8% 6178 5085 1093
21 m 1.2% 72 0 72
22 f 6250 99.2% 6202 5094 1108
23 m 0.8% 48 0 48
24 f 6250 99.2% 6197 5108 1089
25 m 0.8% 53 1 52
26 f 6250 99.3% 6205 5106 1099
27 m 0.7% 45 1 44
28 f 6250 99.2% 6198 5074 1124
29 m 0.8% 52 0 52
30 f 6250 98.8% 6178 5034 1144
31 m 1.2% 72 0 72
918 dirty, 100000 queued, 100000 total, 131072 hash buckets, 4096 buffer
size
start clean at 20.000% (of pair total) dirty, or 1250 buffs dirty, stop
at
10.000%
======== onstat -g glo ===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
MT global info:
sessions threads vps lngspins
46 100 16 23
sched calls thread switches yield 0 yield n yield
forever
total: 55934614 37046463 18949885 268854 31828
per sec: 8 8 0 4 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 6 1683.30 372.62 2055.92
aio 3 0.46 0.59 1.05
shm 1 0.04 0.13 0.17
lio 1 0.17 0.21 0.38
pio 1 0.15 0.17 0.32
adm 1 0.53 0.81 1.34
soc 2 117.95 1191.38 1309.33
msc 1 0.14 0.11 0.25
total 16 1802.74 1566.02 3368.76
Individual virtual processors:
vp pid class usercpu syscpu total
1 389148 cpu 394.39 90.88 485.27
2 163988 adm 0.53 0.81 1.34
3 417888 cpu 388.37 85.45 473.82
4 356420 cpu 321.34 71.02 392.36
5 430194 cpu 244.70 53.32 298.02
6 360590 cpu 191.19 41.19 232.38
7 344252 cpu 143.31 30.76 174.07
8 401496 lio 0.17 0.21 0.38
9 422034 pio 0.15 0.17 0.32
10 442446 aio 0.16 0.21 0.37
11 368866 msc 0.14 0.11 0.25
12 434178 aio 0.15 0.18 0.33
13 495616 aio 0.15 0.20 0.35
14 339988 soc 72.75 767.65 840.40
15 507906 soc 45.20 423.73 468.93
16 491528 shm 0.04 0.13 0.17
tot 1802.74 1566.02 3368.76
=======onstat -g iov ===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
errors
kio 0 i 0.2 2843 529 2314 0 3042 0.9
0
kio 1 i 0.2 2590 547 2043 0 2873 0.9
0
kio 2 i 0.3 3908 469 3439 0 3550 1.1
0
kio 3 i 0.4 5142 530 4612 0 4830 1.1
0
kio 4 i 0.7 8838 427 8411 0 6954 1.3
0
kio 5 i 0.7 9697 365 9332 0 7277 1.3
0
msc 0 i 0.0 105 0 0 0 13045 0.0
0
aio 0 i 0.0 0 0 0 0 12940 0.0
0
aio 1 i 0.0 0 0 0 0 12940 0.0
0
aio 2 i 0.0 0 0 0 0 12940 0.0
0
pio 0 i 0.0 0 0 0 0 12940 0.0
0
lio 0 i 0.0 0 0 0 0 12940 0.0
0
===========onstat -P (edited for brevity)===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
Buffer pool page size: 4096
partnum total btree data other dirty
0 7999 4 12 7983 0
Totals: 100000 54342 36977 8681 918
Percentages:
Data 36.98
Btree 54.34
Other 8.68
===========onstat -g iof ===========
IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up
13:26:02 -- 1075472 Kbytes
AIO global files:
gfd pathname totalops dskread dskwrite io/s
3 uswdbs 3794 71 3723 0.3
4 uswdbs 0 0 0 0.0
5 uswdbs 0 0 0 0.0
6 uswdbs 0 0 0 0.0
7 uswdbs 0 0 0 0.0
8 uswdbs 0 0 0 0.0
9 uswdbs 0 0 0 0.0
10 uswdbs 0 0 0 0.0
11 uswdbs 0 0 0 0.0
12 uswdbs 29224 2796 26428 2.3
===========onconfig.usw==========
#**************************************************************************
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2006 All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME uswdbs # Root dbspace name
ROOTPATH /usr/informix/links/uswdbs # Path for device
containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 80000 # 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 uswdbs # Location (dbspace) of physical log
PHYSFILE 4000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 8 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
# Tablespace Tablespace Configuration in Root Dbspace
TBLTBLFIRST 0 # First extent size (Kbytes) (0 =
default)
TBLTBLNEXT 0 # Next extent size (Kbytes) (0 =
default)
# Security
# DBCREATE_PERMISSION:
# By default any user can create a database. Uncomment
DBCREATE_PERMISSON to
# limit database creation to a specific user. Add a new
DBCREATE_PERMISSION
# line for each permitted user.
#DBCREATE_PERMISSION informix
# DB_LIBRARY_PATH:
# When loading a (C or C++) shared object (for a UDR or UDT), IDS checks
that
# the user-specified path starts with one of the directory prefixes
listed in
# the comma-separated list of prefixes in DB_LIBRARY_PATH. The string
# "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for
# extensibility and IBM supplied blades to work correctly.
# DB_LIBRARY_PATH $INFORMIXDIR/extend
# IFX_EXTEND_ROLE:
# 0 (or off) => Disable use of EXTEND role to control who can register
# external routines.
# 1 (or on) => Enable use of EXTEND role to control who can register
# external routines. This is the default behaviour.
#
IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role.
# Diagnostics
MSGPATH /logs/online.usw.log # System message log file path
CONSOLE /logs/online.cons.log # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM /usr/informix/etc/alarmprogram.sh # Alarm program path
ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event
occur
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 32 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape
(Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 32 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape
(Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 23 # Unique id corresponding to a OnLine
instance
DBSERVERNAME usw_tcp # Name of default database server
DBSERVERALIASES usw # List of alternate dbservernames
NETTYPE soctcp,2,100,NET # 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
NUMCPUVPS 6 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps
to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 4000 # Maximum number of locks
NUMAIOVPS 3 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 6 # Number of buffer cleaner processes
SHMBASE 0x700000000000000L # Shared memory base address
SHMVIRTSIZE 655360 # initial virtual shared memory segment
size
SHMADD 65336 # Size of new shared memory segments
(Kbytes)
EXTSHMADD 8192 # Size of new extension shared memory
segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
SHMVIRT_ALLOCSEG 0 # Values between 0 and .99 are %, values
> 1 are
# KB - when this much virtual memory is
used we
# try to get a new segment. 0 means
"off". 2nd
# parameter is alarm level
CKPTINTVL 300 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 128 # Stack size (Kbytes)
# 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.
#
# In case of system configured with CDR, the difference between LTXHWM
and
# LTXEHWM should be atleast 30% so that we could minimize log overrun
issue.
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
# 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
# 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/etc/dr.lostfound # DR lost+found file
path
DRIDXAUTO 0 # DR automatic index repair. 0=off, 1=on
# CDR Variables
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 8192 # Maximum amount of memory for any CDR queue
(Kbytes)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9
max)
CDR_SERIAL 0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE repltxdbs # CDR queue dbspace (default same as
catalog)
CDR_QDATA_SBSPACE replsbdbs # List of CDR queue smart blob spaces
# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
# 0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
# Max dynamic log requests that CDR can make within one server session.
CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default
# Backup/Restore variables
BAR_ACT_LOG /usr/informix/bar_act.log # ON-Bar Log file - not in /tmp
please
BAR_DEBUG_LOG /usr/informix/bar_dbug.log # ON-Bar Debug Log - not
in /tmp please
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 31ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES # Number of pages to attempt to read
ahead
RA_THRESHOLD # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tmpdbs1:tmpdbs2:tmpdbs3:tmpdbs4 #
Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information
which
# is preserved when an unanticipated error condition (assertion failure)
occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /usr/informix/tmp # Preserve diagnostics in this
directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts
OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps
for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from
OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DS_NONPDQ_QUERY_MEM 128 # Non PDQ query memory (Kbytes)
DATASKIP # List of dbspaces to skip
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2
= WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
SBSPACENAME # Default smartblob space name - this is where
blobs
# go if no sbspace is specified when the
smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
SYSSBSPACENAME # Default smartblob space for use by the Informix
# Server. This is used primarily for Informix
Server
# system statistics collection.
BLOCKTIMEOUT 3600 # Default timeout for system block
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm
program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything
but 1)
#Create Index Online Shared Memory usage limitation
ONLIDX_MAXMEM 5120 # Per pool per index (Kbytes)
#Timeout for client connection request
LISTEN_TIMEOUT 10 # Timeout (in Seconds)
#Following are the deprecated configuration parameters, instead of these
#use BUFFERPOOL configuration parameter
#BUFFERS, LRUS, LRU_MIN_DIRTY, LRU_MAX_DIRTY
IFX_FOLDVIEW 0 # fold multiple tables or union all view with
ansi joins
#
# The following are default settings for enabling Java in the database.
# Replace all occurrences of /usr/informix with the value of
$INFORMIXDIR.
#VPCLASS jvp,num=1 # Number of JVPs to start with
JVPJAVAHOME /usr/informix/extend/krakatoa/jre # JRE
installation root directory
JVPHOME /usr/informix/extend/krakatoa # Krakatoa installation
directory
JVPPROPFILE /usr/informix/extend/krakatoa/.jvpprops # JVP property
file
JVPLOGFILE /usr/informix/jvp.log # JVP log file.
JDKVERSION 1.3 # JDK version supported by this server
# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB /bin
# The JRE libraries to use for the Java VM
JVPJAVAVM hpi:jvm:java:net:zip:jpeg
# use JVPARGS to change Java VM configuration
#To display jni call
#JVPARGS -verbose:jni
# Classpath to use upon Java VM start-up (use _g version for debugging)
#JVPCLASSPATH
/usr/informix/extend/krakatoa/krakatoa_g.jar:/usr/informix/extend/krakatoa/jdbc_
g.jar
JVPCLASSPATH
/usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.ja
r
# The following parameters are related to the buffer pool
#BUFFERPOOL
default,buffers=1000,lrus=8,lru_min_dirty=50,lru_max_dirty=60
BUFFERPOOL
size=4k,buffers=100000,lrus=16,lru_min_dirty=10,lru_max_dirty=20
DT
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
