Strange Error doing init -iv
Brett Simpson's 'oninit -iv' on IDS 9.4UC7 (32-bit) under SuSE Linux 8.1 in VMware, with root dbspace on raw devices (/dev/raw/rawN symlinked under /database), aborted with a bare 'FAILED' right after 'Initializing 4 flushers', with no explanatory message in the online.log. Responders asked for exact version/platform and directory permissions, noted that MSGPATH shouldn't sit in the same directory as the chunk links, suggested checking SHMBASE against the release notes, and pointed out that the ONCONFIG requests roughly 1.7GB+ of shared memory for a 32-bit server, which the VM may not be able to supply. The thread records no confirmed fix.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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 alternatedbservernames
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 fro
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.
> #@@N
On Sun, May 29, 2011 at 22:52, BRETT SIMPSON
<brett.simpson@actrol.com.au>wrote:
> I'm getting the error below when I try and initialize an instance
>
> oninit -iv>
Which version of IDS? Which platform?
Clearly, you should be getting some indication of what failed (either in the
online log or on stderr or both)...that is a usability bug.
> 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
> [...megasnip...]
> DBSPACETEMP # Default temp dbspaces>
--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
--90e6ba613f4455389404a4790f9f
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 thr
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 # St
That's a 32bit version. You have allocated over 1.7GB of memory, it may be
that the VM is not allowing enough memory for the instance to start up.
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 3:32 AM, Hrvoje Zokovic <hzokovic.iiug@gmail.com>wrote:
> 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)> >>
> >> # L