 |
IDS Forum
Re: Strange Error doing init -iv
Posted By: Hrvoje Zokovic
Date: Monday, 30 May 2011, at 3:32 a.m.
In Response To: Re: Strange Error doing init -iv (Hrvoje Zokovic)
Please post "ls -al /database"
In general, it is not recommended to put online log file in the same
dir as chunk links (MSGPATH)
Hrvoje
On 30.05.2011. 8:57, Brett Simpson wrote:
> Hi
>
> Yes its 9.4uc7 on Suse Linux 8.1
>
> Im doing a trial on Informix on vmware
>
> The database space is using raw disks presented by vmware.
>
>
> /database
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:34 chunk01 ->
> /dev/raw/raw1
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk02 ->
> /dev/raw/raw2
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk03 ->
> /dev/raw/raw3
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk04 ->
> /dev/raw/raw4
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk05 ->
> /dev/raw/raw5
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk06 ->
> /dev/raw/raw6
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk07 ->
> /dev/raw/raw7
> lrwxrwxrwx 1 informix informix 13 2011-05-30 05:35 chunk08 ->
> /dev/raw/raw8
>
> I'm not using vgcreate to create a volume group but am mapping the raw
> disks directly
>
> # /etc/raw
> #
> # sample configuration to bind raw devices
> # to block devices
> #
> # The format of this file is:
> # raw<N>:<blockdev>
> #
> # example:
> # ---------
> # raw1:hdb1
> #
> # this means: bind /dev/raw/raw1 to /dev/hdb1
> #
> # ...
> raw1:sdc
> raw2:sdd
> raw3:sde
> raw4:sdf
> raw5:sdg
> raw6:sdh
> raw7:sdi
> raw8:sdj
>
> INFORMIXSERVER=sage
>
> the sqlhosts is
>
> # Licensed Material - Property Of IBM
> #
> # "Restricted Materials of IBM"
> #
> # IBM Informix Dynamic Server
> # (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
> #
> # Title: sqlhosts.demo
> # Description:
> # Default sqlhosts file for running demos.
> #
> #***********************************************************************
> ***
>
> demo_on onipcshm on_hostname on_servername
> demo_se seipcpip se_hostname sqlexec
>
> sage onipcshm heidi sageshm
> sage_tcp onsoctcp heidi sage_tcp
> sage_ext onsoctcp heidi sage_ext
> sage_stream onipcstr heidi sage_stream
>
>
> Im not sure wether I should be using lvm to bind the raw disks or use
> direct (like im doing)
>
> The FAILED message in getting form oninit -iv dosnt explain the problem
> and there is no error in online.log...
>
>
> I'm not sure what the issue is.....
>
> Thanks
>
> Brett
>
>
On 30.05.2011. 8:30, Hrvoje Zokovic wrote:
> Is this 9.4? What OS? Do you have all permissions correct (e.g. "ls -l
> /database" ...)
> Hrvoje
>
> On 30.05.2011. 7:52, BRETT SIMPSON 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.
>>
>>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
