Hi,

When I increase the size of rootdbs again same error occurs, this time it requires again more size than I defined.

I use cooked file. I'm sending my onconfig file.Informix 9.21, hp-ux 11.00

-----------------------------------------------------------

#:/tmp> oninit -iv

This action will initialize Informix Dynamic Server 2000;
any existing Informix Dynamic Server 2000 databases will NOT be accessible -
Do you wish to continue (y/n)? y
Checking group membership to determine server run modesucceeded
Reading configuration file '/usr/local/informix/9.21/etc/onconfig.testdb'...succeeded
Creating /INFORMIXTMP/.infxdirs ... succeeded
Creating infos file "/usr/local/informix/9.21/etc/.infos.test_shm" ... "/usr/local/informix/9.21/etc
/.conf.test_shm" ... succeeded
Writing to infos file ... succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1122 kbytes...succeeded
Creating buffer pool 1998 kbytes...succeeded
Creating buffer pool 6 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 6 IO vps...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 6 'soctcp' listener threads...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Starting tracing...succeeded
Initializing 30 flushers...succeeded
oninit: Not enough room in ROOT DBspace.
Requested 111638K, ONCONFIG value 'ROOTSIZE' 110000K.
oninit: Fatal error in shared memory initialization

------------------------------------------------------------
onconfig file

# Root Dbspace Configuration

ROOTNAME testrootdbs # Root dbspace name
#ROOTPATH /usr/testdb/testdbchunk1 # Path for device containing root dbspace
ROOTPATH /tmp/testdbchk1 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 110000 # 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 testphydbs # Location (dbspace) of physical log
PHYSFILE 110000 # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES 3 # Number of logical log files
LOGSIZE 200 # Logical log size (Kbytes)
# Diagnostics

MSGPATH /usr/local/informix/online.log.testdb
CONSOLE /usr/local/informix/online.log.testdb
ALARMPROGRAM /usr/local/informix/9.21/etc/log_full.sh
TBLSPACE_STATS 1 # Maintain tblspace statistics
STMT_CACHE 2 # Disable SQL statement caching
STMT_CACHE_SIZE 4096

# System Archive Tape Device

TAPEDEV /dev/null # Tape device path
TAPEBLK 1024 # 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 1024 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB # Informix Dynamic Server 2000 staging area
# System Configuration

SERVERNUM 199 # Unique id corresponding to a OnLine instance
DBSERVERNAME test_shm # Name of default database server
#DBSERVERALIASES test_tcp # List of alternate dbservernames
NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,6,400,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)

LOCKS 2000 # Maximum number of locks
BUFFERS 1000 # Maximum number of shared buffers
NUMAIOVPS 6 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
LOGSMAX 100 # Maximum number of logical log files
CLEANERS 30 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 8192 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
n sec)
STACKSIZE 64 # Stack size (Kbytes)


# Data Replication Variables
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /usr/local/informix/9.21/etc/dr.lostfound


DBSPACETEMP tmp01,tmp02,tmp03,tmp04,tmp05,tmp06,tmp07,tmp08,tm p09

# 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/local/informix/dump
# 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 75 # Maximum allowed pdqpriority
DS_MAX_QUERIES 32 # Maximum number of decision support queries
DS_TOTAL_MEMORY 8000 # Decision support memory (Kbytes)
DS_MAX_SCANS 65536 # Maximum number of decision support scans
DATASKIP off # 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 0 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
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/local/informix/9.21/etc/evidence.sh

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
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.

--------------------------------------------------------------
error.log:

Tue May 11 19:02:00 2004

19:02:00 Event alarms enabled. ALARMPROG = '/usr/local/informix/9.21/etc/log_full.sh'
19:02:00 Dynamically allocated new virtual shared memory segment (size 8196KB)
19:02:00 Booting Language <c> from module <>
19:02:00 Loading Module <CNULL>
19:02:00 Booting Language <builtin> from module <>
19:02:00 Loading Module <BUILTINNULL>
19:02:06 Dynamically allocated new message shared memory segment (size 1196KB)
19:02:06 Informix Dynamic Server 2000 Version 9.21.FC3
19:02:06 Dynamically allocated new virtual shared memory segment (size 8192KB)
19:02:10 Informix Dynamic Server 2000 Stopped.

19:02:10 mt_shm_remove: WARNING: may not have removed all/correct segments

Hi,

Please change PHYSFILE 110000 to PHYSFILE 5000, and star-up.

Gustavo.

Hi gustavo,

Thanks for the answer. I couldn't initialize it with oninit -iv , but yesterdat I used onmonitor and I could create my instance.

PS: LOGFILES=3 LOGSIZE=200 was not enough even to create sysmaster and sysutils. So LOGFILES * LOGSIZE should be not smaller than 3MB for even a very simple/small database.

increase LOGFILES,LOGSIZE,LOCKS,BUFFERS

PHYSLOG is taking up the whole rootdbs, decrease the size, or increase the size of rootdbs