HowToForums.net Forum Index HowToForums.net
An Open Source of Knowledge
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

IBM informix high performance onconfig

 
Post new topic   Reply to topic    HowToForums.net Forum Index -> Informix
View previous topic :: View next topic  
Author Message
jacob
Site Admin
Site Admin


Joined: 16 Mar 2006
Posts: 73
Location: USA

PostPosted: Sat Oct 28, 2006 6:27 am    Post subject: IBM informix high performance onconfig Reply with quote


Below is an example Informix onconfig file according to our blood, sweet, and tears tweaking discoveries over the years.
feel free to use as a reference.


see also how to create the dbspaces and chunks in high performance mode:
http://howtoforums.net/viewtopic.php?t=91

and informix HDR:
http://howtoforums.net/viewtopic.php?t=89


[informix@ifxdb1 informix]$ cat $INFORMIXDIR/etc/onconfig.ifxdb1
Code:

#**************************************************************************
#
#                          INFORMIX SOFTWARE, INC.
#
#  Title:       onconfig
#
#**************************************************************************

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /opt/informix/db_chunks/rootdbs_chunk01   # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        2097152          # 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         rootdbs         #default Location (dbspace) of physical log
PHYSDBS         phydbs1         # modified post-install Location (dbspace) of physical log for performance
PHYSFILE        102400          # Physical log file size (Kbytes)

# Logical Log Configuration

#LOGFILES        3              # default Number of logical log files 1 to be created in rootdbs on initialization
LOGFILES        50              # Number of logical log files to change to post-install 50
LOGSIZE         20480            # Logical log size (Kbytes)

# Diagnostics

MSGPATH         /opt/informix/ifxdb1/online.log # System message log file path
CONSOLE         /dev/console    # System console message path
ALARMPROGRAM    /opt/informix/etc/log_full.sh # Alarm program path
TBLSPACE_STATS  1               # Maintain tblspace statistics

# System Archive Tape Device

TAPEDEV         /opt/informix/faketape # Tape device path
TAPEBLK         16              # Tape block size (Kbytes)
TAPESIZE        10002400           # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV        /opt/informix/faketape       # Log tape device path
LTAPEBLK        16              # Log tape block size (Kbytes)
LTAPESIZE       10002400           # 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    ifxdb1_onlds # Name of default database server
DBSERVERALIASES ifxdb1_shm,ifxdb1_hdr  # List of alternate dbservernames
NETTYPE         ipcshm,1,50,CPU # Configure poll thread(s) for nettype
NETTYPE         soctcp,1,25,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
SINGLE_CPU_VP   0               # If non-zero, limit number of cpu vps to one

VPCLASS         CPU,num=3
#NUMCPUVPS       3               # Number of user (cpu) vps
#NOAGE           0               # Process aging
#AFF_SPROC       0               # Affinity start processor
#AFF_NPROCS      0               # Affinity number of processors
#NUMAIOVPS       2               # Number of IO vps

# Shared Memory Parameters

LOCKS           400000           # Maximum number of locks
BUFFERS         16000           # Maximum number of shared buffers
PHYSBUFF        32              # Physical log buffer size (Kbytes)
LOGBUFF         32              # Logical log buffer size (Kbytes)
CLEANERS        20               # Number of buffer cleaner processes
SHMBASE         0x10000000        # Shared memory base address
SHMVIRTSIZE     786432          # initial virtual shared memory segment size
SHMADD          262144          # Size of new shared memory segments (Kbytes)
SHMTOTAL        0               # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL       300             # Check point interval (in sec)
LRUS            20              # Number of LRU queues
LRU_MAX_DIRTY   60              # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY   50              # LRU percent dirty end cleaning limit
TXTIMEOUT       0x12c             # Transaction timeout (in sec)
STACKSIZE       64

STMT_CACHE      0               # Statement cache off
# 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 15              # Default number of online worker threads

# Data Replication Variables
DRAUTO          OFF             # DR setting to define switching types on failovers
DRINTERVAL      30              # DR max time between DR buffer flushes (in sec)
DRTIMEOUT       40              # DR network timeout (in sec)
DRLOSTFOUND     /opt/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables
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)
CDR_NIFCOMPRESS 0               # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL      0,0             # Serial Column Sequence
CDR_DBSPACE                     # dbspace for syscdr database
CDR_QHDR_DBSPACE                 # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE                 # CDR queue smart blob space
CDR_QDATA_SBFLAGS 0               # Log/no-log (default no log)


# Backup/Restore variables
BAR_ACT_LOG     /opt/informix/ifxdb1/bar_act.log
                                # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG   /opt/informix/ifxdb1/bar_dbug.log
                                # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP  0
BAR_RETRY       1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE on
BAR_PROGRESS_FREQ 0

# Informix Storage Manager variables
ISM_DATA_POOL   ISMData
ISM_LOG_POOL    ISMLogs

# Read Ahead Variables
RA_PAGES        32              # Number of pages to attempt to read ahead
RA_THRESHOLD    8               # 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     tempdbs1        # 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         /tmp            # Preserve diagnostics in this directory
DUMPSHMEM       0               # 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 50              # Maximum allowed pdqpriority
DS_MAX_QUERIES  100             # Maximum number of decision support queries
DS_TOTAL_MEMORY 128000           # Decision support memory (Kbytes)
DS_MAX_SCANS    100             # Maximum number of decision support scans
DATASKIP        off             
# 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 /opt/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)

#
# 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

JVPJAVAHOME                     # JRE installation root directory
JVPHOME                         # Krakatoa installation directory
JVPPROPFILE     .jvpprops       # JVP property file
JDKVERSION                      # JDK version supported by this server
JVPJAVALIB
JVPJAVAVM       libjava.so
JVPCLASSPATH
#NUMAIOVPS       1               # Number of IO vps
NUMAIOVPS       2               # Number of IO vps
DYNAMIC_LOGS    2               
LTXHWM          70             
LTXEHWM         80             
CDR_MAX_DYNAMIC_LOGS 0               # Dynamic log addition disabled by default



for search engines
IBM Informix onconfig
onconfig tweaks tips and tricks
IBM informix memory usage
IBM Informix High-Availability Data Replication
IBM Software - Informix Dynamic Server (IDS) HDR
HowTo HDR informix
Informix backup scripts
Informix redundancy
howto automate informix
informix deployment best practices
informix guru
informix tips and tricks



Have Fun!!! Smile

"Forgiving is not a Weakness, rather a Godly Strength"
--Jacob
Back to top
Display posts from previous:   
Post new topic   Reply to topic    HowToForums.net Forum Index -> Informix All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group