 |
IDS Forum
Re: Strange Error doing init -iv
Posted By: Art Kagel
Date: Monday, 30 May 2011, at 8:47 a.m.
In Response To: Strange Error doing init -iv (BRETT SIMPSON)
Exact version and platform? Is SHMBASE correct according to the release
notes?
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Mon, May 30, 2011 at 1:52 AM, BRETT SIMPSON
<brett.simpson@actrol.com.au>wrote:
> Hi
>
> I'm getting the error below when I try and initialize an instance
>
> oninit -iv
>
> This action will initialize IBM Informix Dynamic Server;
> any existing IBM Informix Dynamic Server databases will NOT be accessible -
> Do you wish to continue (y/n)? y
> Checking group membership to determine server run modesucceeded
> Reading configuration file '/app/informix/etc/onconfig.actrol'...succeeded
> Creating /INFORMIXTMP/.infxdirs ... succeeded
> Creating infos file "/app/informix/etc/.infos.sage" ...
> "/app/informix/etc/.conf.sage" ... succeeded
> Writing to infos file ... succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 258180 kbytes...succeeded
> Creating buffer pool 560002 kbytes...succeeded
> Initializing rhead structure...succeeded
> Initializing ASF ...succeeded
> Initializing Dictionary Cache and SPL Routine Cache...succeeded
> Bringing up ADM VP...succeeded
> Creating VP classes...succeeded
> Onlining 3 additional cpu vps...succeeded
> Onlining 10 IO vps...succeeded
> Initialization of Encryption...succeeded
> Forking main_loop thread...succeeded
> Initializing DR structures...succeeded
> Forking 1 'ipcshm' listener threads...succeeded
> Forking 1 'soctcp' listener threads...succeeded
> Forking 1 'soctcp' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 4 flushers...succeeded
> FAILED
>
> There is nothing in online.log to explain why it stops at FAILED !!!
>
> the onconfig is below
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /database/chunk03 # Path for device containing root dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
> #ROOTSIZE 2097152 # Size of root dbspace (Kbytes)
> ROOTSIZE 4194304 # 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 # Location (dbspace) of physical log
> #PHYSDBS physlogdbs # Location (dbspace) of physical log
> # PHYSFILE 200000 # Physical log file size (Kbytes)
> #PHYSFILE 10000000 # Physical log file size (Kbytes)
> #PHYSFILE 10485760 # Physical log file size (Kbytes)
>
> # Logical Log Configuration
>
> #LOGFILES 2500 # Number of logical log files
> #LOGSIZE 1000010485760 # Logical log size (Kbytes)
>
> # Diagnostics
>
> MSGPATH /database/online.log # System message log file path
> CONSOLE /dev/null # System console message path
>
> # To automatically backup logical logs, edit alarmprogram.sh and set
> # BACKUPLOGS=Y
> ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path
> TBLSPACE_STATS 1 # Maintain tblspace statistics
>
> # System Archive Tape Device
>
> #TAPEDEV /dev/nst0 # Tape device path
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 128 # Tape block size (Kbytes)
> TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes)
>
> # Log Archive Tape Device
>
> LTAPEDEV /dev/zero # Log tape device path
> #LTAPEDEV /dev/null # Log tape device path
> LTAPEBLK 128 # Log tape block size (Kbytes)
> LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes)
>
> # Optical
>
> STAGEBLOB # Informix Dynamic Server staging area
>
> # System Configuration
>
> ## Change servernum away from default in case someone creates a default new
> instance!
> SERVERNUM 30 # Unique id corresponding to a OnLine instance
> ##SERVERNUM 0 # Unique id corresponding to a OnLine instance
> DBSERVERNAME sage # Name of default database server
> # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternate
> dbservernames
> DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames
> NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype
> NETTYPE soctcp,2,600,NET # Configure poll thread(s) for nettype
> # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype
> ##NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype
> # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype
> # NETTYPE ipcstr,1,400,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 4 # 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 2000000 # Maximum number of locks
> LOCKS 2500000 # Maximum number of locks
> BUFFERS 280000 # Maximum number of shared buffers
> #BUFFERS 1120000 # Maximum number of shared buffers
> #BUFFERS 560000 # Maximum number of shared buffers
> ## Raw disk in use so Informix doesn't need to manage io - one aiovp to
> kaio
> ## no kaio possible so leave NUMAIOVPS at 10
> #NUMAIOVPS 1 # Number of IO vps
> NUMAIOVPS 10 # Number of IO vps
> PHYSBUFF 256 # Physical log buffer size (Kbytes)
> LOGBUFF 256 # Logical log buffer size (Kbytes)
> ## one cleaner per disk
> CLEANERS 4 # Number of buffer cleaner processes
> ##CLEANERS 3 # Number of buffer cleaner processes
> SHMBASE 0x44000000 # Shared memory base address
> #SHMBASE 0x10000000 # Shared memory base address
> SHMVIRTSIZE 1200000 # initial virtual shared memory segment size
> SHMADD 200000 # Size of new shared memory segments (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
> CKPTINTVL 900 # Check point interval (in sec)
> ## might as well have 256 LRU's and avoid latching contention
> LRUS 128 # Number of LRU queues
> ##LRUS 200 # Number of LRU queues
> ## reduce the start time for cleaners by 1% to avoid the 4-5 second delay
> that
> is currently occuring
> LRU_MAX_DIRTY 4.500000 # LRU percent dirty begin cleaning limit
> ##LRU_MAX_DIRTY 5.500000 # LRU percent dirty begin cleaning limit
> ## reduce the stop time for cleaners by 1.5% stop to clean a little bit
> better
> LRU_MIN_DIRTY 2.000000 # LRU percent dirty end cleaning limit
> ##LRU_MIN_DIRTY 3.500000 # LRU percent dirty end cleaning limit
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # 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 70
> #LTXHWM 92
> LTXEHWM 80
> #LTXEHWM 98
>
> # 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
> ## why reduce the online recovery speed when this is the only database?
> ON_RECVRY_THREADS 10 # Default number of online worker threads
> ##ON_RECVRY_THREADS 1 # Default number of online worker threads
>
> # Data Replication Variables
> DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
> DRTIMEOUT 30 # DR network timeout (in sec)
> DRLOSTFOUND /app/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 # 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 /app/informix/bar_act.log # ON-Bar Log file - not in /tmp
> please
> BAR_DEBUG_LOG /app/informix/bar_dbug.log
>
> BAR_MAX_BACKUP 1
> BAR_RETRY 1
> BAR_NB_XPORT_COUNT 10
> BAR_XFER_BUF_SIZE 31
> RESTARTABLE_RESTORE on
> BAR_PROGRESS_FREQ 5
> #BAR_BSALIB_PATH /usr/lib/ibsad001.so
> BAR_DEBUG 0
> BAR_HISTORY 0
>
> # Informix Storage Manager variables
> #ISM_DATA_POOL ISMData
> #ISM_LOG_POOL ISMDiskLogs
>
> # Read Ahead Variables
> ## 10% opportunity for readahead gain
> RA_PAGES 84 # Number of pages to attempt to read ahead
> ##RA_PAGES 64 # Number of pages to attempt to read ahead
> ## the ra_threshold (start point) looks wrong for somewhat modern disks -
> The
> start time for readahead needs to occurr earlier
> RA_THRESHOLD 46 # Number of pages left before next group
> ##RA_THRESHOLD 16 # 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 tempdbs,tempdbs2,tempdbs3 # 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 /work/data/informix/dump
>
> # 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
> ## default of 90% fill should be used unless by default tables are add /
> read
> only
> FILLFACTOR 100 # Fill factor for building indexes
> ##FILLFACTOR 100 # 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)
> ## limit unfair allocations to maximum of 40% of box
> MAX_PDQPRIORITY 40 # Maximum allowed pdqpriority
> ##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
> 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.
> ## This should probably be 2. If 2 need to ensure statistics are current.
> OPTCOMPIND 0 # To hint the optimizer
>
> DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
>
> ONDBSPACEDOWN 0 # 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 /app/informix/etc/evidence.sh # System Alarm program path
>
> # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
> ## this looks wrong - Should be -1 so that a multi-row set is returned
> optimally (associated but different concept to optcompind)
> OPT_GOAL 0
>
> 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
>
> JDKVERSION 1.3 # JDK version supported by this server
>
> # The path to the JRE libraries relative to JVPJAVAHOME
> JVPJAVALIB /lib/i386/
>
> # The JRE libraries to use for the Java VM
>
> JVPJAVAVM hpi:server:verify: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
>
> # Default locking mode to row for newly created tables.
> DEF_TABLE_LOCKMODE ROW
> ## Should put this in to ensures sql using views is rewritten by the
> optimiser
> for the base tables rather than materialising the view
> ##IFX_FOLDVIEW 1
> ## default data dictionary caching and distributions caching must be in use
> -
> too small for 18,000 tables/indexes
> ## DD_HASHMAX 10
> ## DD_HASHSIZE 18131
> ## DS_HASHMAX 10
> ## DS_HASHSIZE 18131
> PHYSFILE 200 # Physical log file size (Kbytes)
> LOGFILES 6 # Number of logical log files
> LOGSIZE 1500 # Logical log size (Kbytes)
> LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)
> EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes)
> ISM_DATA_POOL ISMData
> ISM_LOG_POOL ISMLogs
> DBSPACETEMP # Default temp dbspaces
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec5186af414e2f804a47daf4f
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
