Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Mapping cpuvp's to IBM virtual processors ....

Posted By: Dave Thacker
Date: Friday, 23 February 2007, at 4:18 p.m.

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.jar

# 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

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.