Not enough room in ROOT DBspace ✓ Answered: green (solid confidence) — Root cause (an oversized PHYSFILE/LOGFILES copied from another server vs. a too-small ROOTSIZE) was diagnosed by multiple responders, and Steven confirmed reducing logical logs let the instance initialize.

Advisory only.

Hi, I'm trying to setup a new server with the exact configuration like another one but now I just can't initialize the instance. I always receive : oninit: Not enough room in ROOT DBspace. Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K ONCONFIG: ROOTNAME ts_datadbs1 ROOTPATH /storage/chunks/ts_rootdbs ROOTOFFSET 0 ROOTSIZE 2097152MIRROR 0 MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror MIRROROFFSET 0 PHYSFILE 2048000 PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp PHYSBUFF 128 LOGFILES 106 LOGSIZE 10000 DYNAMIC_LOGS 2 LOGBUFF 64 LTXHWM 70 LTXEHWM 80 MSGPATH $INFORMIXDIR/tmp/online.log CONSOLE $INFORMIXDIR/tmp/online.con TBLTBLFIRST 0 TBLTBLNEXT 0 TBLSPACE_STATS 1 DBSPACETEMP ts_tempdbs1, ts_tempdbs2, ts_tempdbs3 SBSPACETEMP SBSPACENAME sbspace SYSSBSPACENAME sbspace ONDBSPACEDOWN 2 SERVERNUM 1 DBSERVERNAME ifx_blk DBSERVERALIASES FULL_DISK_INIT 0 NETTYPE soctcp,1,64,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NUMFDSERVERS 4 NS_CACHE host=900,service=900,user=900,group=900 MULTIPROCESSOR 1 VPCLASS cpu,num=2,noage VP_MEMORY_CACHE_KB 2048 SINGLE_CPU_VP 0 AUTO_TUNE 1 CLEANERS 8 DIRECT_IO 1 LOCKS 200000 DEF_TABLE_LOCKMODE page RESIDENT 0 SHMBASE 0x44000000L SHMVIRTSIZE 5120000 SHMADD 51200 EXTSHMADD 51200 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS CKPTINTVL 300 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp TXTIMEOUT 300 DEADLOCK_TIMEOUT 60 HETERO_COMMIT 0 TAPEDEV /dev/null TAPEBLK 32 TAPESIZE 0 LTAPEDEV /dev/tapedev LTAPEBLK 32 LTAPESIZE 0 BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_MAX_RESTORE BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 BAR_CKPTSEC_TIMEOUT 15 PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL DD_HASHSIZE 31 DD_HASHMAX 10 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 PRELOAD_DLL_FILE STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 USEOSTIME 0 STACKSIZE 64 ALLOW_NEWLINE 0 USELASTCOMMITTED "NONE" FILLFACTOR 90 MAX_FILL_DATA_PAGES 0 BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default ONLIDX_MAXMEM 5120 MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 256 DATASKIP OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 1 STATCHANGE 10 USTLOW_SAMPLE 1 BATCHEDREAD_TABLE 1 BATCHEDREAD_INDEX 1 EXPLAIN_STAT 1 IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA ADMIN_MODE_USERS SSL_KEYSTORE_LABEL TLS_VERSION PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 SQL_LOGICAL_CHAR OFF SEQ_CACHE_SIZE 10 ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE CDR_SUPPRESS_ATSRISWARN CDR_DELAY_PURGE_DTC 0 CDR_LOG_LAG_ACTION ddrblock CDR_LOG_STAGING_MAXSIZE 0 CDR_MAX_DYNAMIC_LOGS 0GRIDCOPY_DIR $INFORMIXDIR CDR_TSINSTANCEID 0 CDR_MAX_FLUSH_SIZE 50 CDR_AUTO_DISCOVER 0 CDR_MEM 0 SHARD_MEM 0 SHARD_ID 0 DRAUTO 0 DRINTERVAL 0 HDR_TXN_SCOPE NEAR_SYNC DRTIMEOUT 30 HA_ALIAS HA_FOC_ORDER SDS,HDR,RSSDRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 10 SDS_ALTERNATE NONE SDS_FLOW_CONTROL 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK FAILOVER_TX_TIMEOUT 0 TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 SMX_NUMPIPES 1 ENABLE_SNAPSHOT_COPY 0 SMX_COMPRESS 0 SMX_PING_INTERVAL 10 SMX_PING_RETRY 6 CLUSTER_TXN_SCOPE SERVER ON_RECVRY_THREADS 1 OFF_RECVRY_THREADS 10 DUMPDIR $INFORMIXDIR/tmp DUMPSHMEM 1 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh ALRM_ALL_EVENTS 0 STORAGE_FULL_ALARM 600,3SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh RAS_PLOG_SPEED 93090 RAS_LLOG_SPEED 0 EILSEQ_COMPAT_MODE 0 QSTATS 0 WSTATS 0 USERMAPPING OFF SP_AUTOEXPAND 1 SP_THRESHOLD 0 SP_WAITTIME 30 AUTOLOCATE 0 DEFAULTESCCHAR \\\\ MQSERVER MQCHLLIB MQCHLTAB REMOTE_SERVER_CFG REMOTE_USERS_CFG S6_USE_REMOTE_SERVER_CFG 0 LOW_MEMORY_RESERVE 0 LOW_MEMORY_MGR 0 GSKIT_VERSION INFORMIXCONTIME 60 INFORMIXCONRETRY 1 JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops JVPLOGFILE $INFORMIXDIR/tmp/jvp.log JVPARGS -Dcom.ibm.tools.attach.enable=no JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 BUFFERPOOL size=2K,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 BUFFERPOOL size=8K,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 The config is the same as the other server has. What could be the issue ? Thanks.

Original post: Hi, I'm trying to setup a new server with the exact configuration like another one but now I just can't initialize the instance. I always receive : oninit: Not enough room in ROOT DBspace. Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K ONCONFIG: ROOTNAME ts_datadbs1 ROOTPATH /storage/chunks/ts_rootdbs ROOTOFFSET 0 ROOTSIZE 2097152MIRROR 0 MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror MIRROROFFSET 0 PHYSFILE 2048000 PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp PHYSBUFF 128 LOGFILES 106 LOGSIZE 10000 Response: My guess is the server you copied this $ONCONFIG from has more then 1 chunk in it's rootdbs, or the logical/physical logs are somplace else. From just the $ONCONFIG portion listed, your 1st chunk of your rootdbs (which is all you have allocated when you do an oninit -iy) is about 2Gb, but your PHYSFILE is set to about 2gb, and then you additionally have 106 logical log files that are 10Mb each (so that ends up being another 1gb of required space). So that's why you are seeing: Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K So you need to bring the server up with smaller physical/logical log configurations, then add space, and then move the physical log or move and add the requested logical log files. Jacques Renaut IBM Informix Advanced Support

Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the exact configuration like another one > but now I just can't initialize the instance. I always receive : > > oninit: Not enough room in ROOT DBspace. > > Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K > > ONCONFIG: > > ROOTNAME ts_datadbs1 > ROOTPATH /storage/chunks/ts_rootdbs > ROOTOFFSET 0 > ROOTSIZE 2097152> MIRROR 0 > MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror > MIRROROFFSET 0 > > PHYSFILE 2048000 > PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp > PHYSBUFF 128 > > LOGFILES 106 > LOGSIZE 10000 > DYNAMIC_LOGS 2 > LOGBUFF 64 > > LTXHWM 70 > LTXEHWM 80> > MSGPATH $INFORMIXDIR/tmp/online.log > CONSOLE $INFORMIXDIR/tmp/online.con > > TBLTBLFIRST 0 > TBLTBLNEXT 0 > TBLSPACE_STATS 1> > DBSPACETEMP ts_tempdbs1, ts_tempdbs2, ts_tempdbs3 > SBSPACETEMP > > SBSPACENAME sbspace > SYSSBSPACENAME sbspace > ONDBSPACEDOWN 2 > > SERVERNUM 1 > DBSERVERNAME ifx_blk > DBSERVERALIASES > FULL_DISK_INIT 0 > > NETTYPE soctcp,1,64,NET > LISTEN_TIMEOUT 60 > MAX_INCOMPLETE_CONNECTIONS 1024 > FASTPOLL 1 > NUMFDSERVERS 4 > NS_CACHE host=900,service=900,user=900,group=900 > > MULTIPROCESSOR 1 > VPCLASS cpu,num=2,noage > VP_MEMORY_CACHE_KB 2048 > SINGLE_CPU_VP 0 > > AUTO_TUNE 1 > > CLEANERS 8 > DIRECT_IO 1 > > LOCKS 200000 > DEF_TABLE_LOCKMODE page > > RESIDENT 0 > SHMBASE 0x44000000L > SHMVIRTSIZE 5120000 > SHMADD 51200 > EXTSHMADD 51200 > SHMTOTAL 0 > SHMVIRT_ALLOCSEG 0,3 > SHMNOACCESS > > CKPTINTVL 300 > RTO_SERVER_RESTART 0 > BLOCKTIMEOUT 3600 > > CONVERSION_GUARD 2 > RESTORE_POINT_DIR $INFORMIXDIR/tmp > > TXTIMEOUT 300 > DEADLOCK_TIMEOUT 60 > HETERO_COMMIT 0 > > TAPEDEV /dev/null > TAPEBLK 32 > TAPESIZE 0 > > LTAPEDEV /dev/tapedev > LTAPEBLK 32 > LTAPESIZE 0> > BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log > BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log > BAR_DEBUG 0 > BAR_MAX_BACKUP 0 > BAR_MAX_RESTORE > BAR_RETRY 1 > BAR_NB_XPORT_COUNT 20 > BAR_XFER_BUF_SIZE 31 > RESTARTABLE_RESTORE ON > BAR_PROGRESS_FREQ 0 > BAR_BSALIB_PATH > BACKUP_FILTER > RESTORE_FILTER > BAR_PERFORMANCE 0 > BAR_CKPTSEC_TIMEOUT 15 > > PSM_DBS_POOL DBSPOOL > PSM_LOG_POOL LOGPOOL > > DD_HASHSIZE 31 > DD_HASHMAX 10 > > DS_HASHSIZE 31 > DS_POOLSIZE 127 > > PC_HASHSIZE 31 > PC_POOLSIZE 127 > PRELOAD_DLL_FILE > > STMT_CACHE 0 > STMT_CACHE_HITS 0 > STMT_CACHE_SIZE 512 > STMT_CACHE_NOLIMIT 0 > STMT_CACHE_NUMPOOL 1 > > USEOSTIME 0 > STACKSIZE 64 > ALLOW_NEWLINE 0 > USELASTCOMMITTED "NONE" > > FILLFACTOR 90 > MAX_FILL_DATA_PAGES 0 > BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default > ONLIDX_MAXMEM 5120 > > MAX_PDQPRIORITY 100 > DS_MAX_QUERIES > DS_TOTAL_MEMORY > DS_MAX_SCANS 1048576 > DS_NONPDQ_QUERY_MEM 256 > DATASKIP > > OPTCOMPIND 2 > DIRECTIVES 1 > EXT_DIRECTIVES 0 > OPT_GOAL -1 > IFX_FOLDVIEW 1 > STATCHANGE 10 > USTLOW_SAMPLE 1 > > BATCHEDREAD_TABLE 1 > BATCHEDREAD_INDEX 1 > > EXPLAIN_STAT 1 > > IFX_EXTEND_ROLE 1 > SECURITY_LOCALCONNECTION > UNSECURE_ONSTAT > ADMIN_USER_MODE_WITH_DBSA > ADMIN_MODE_USERS > SSL_KEYSTORE_LABEL > TLS_VERSION > > PLCY_POOLSIZE 127 > PLCY_HASHSIZE 31 > USRC_POOLSIZE 127 > USRC_HASHSIZE 31 > > SQL_LOGICAL_CHAR OFF > > SEQ_CACHE_SIZE 10 > > ENCRYPT_HDR > ENCRYPT_SMX > ENCRYPT_CDR 0 > ENCRYPT_CIPHERS > ENCRYPT_MAC > ENCRYPT_MACFILE > ENCRYPT_SWITCH > > CDR_EVALTHREADS 1,2 > CDR_DSLOCKWAIT 5 > CDR_QUEUEMEM 4096 > CDR_NIFCOMPRESS 0 > CDR_SERIAL 0 > CDR_DBSPACE > CDR_QHDR_DBSPACE > CDR_QDATA_SBSPACE > CDR_SUPPRESS_ATSRISWARN > CDR_DELAY_PURGE_DTC 0 > CDR_LOG_LAG_ACTION ddrblock > CDR_LOG_STAGING_MAXSIZE 0 > CDR_MAX_DYNAMIC_LOGS 0> GRIDCOPY_DIR $INFORMIXDIR > CDR_TSINSTANCEID 0 > CDR_MAX_FLUSH_SIZE 50 > CDR_AUTO_DISCOVER 0 > CDR_MEM 0 > SHARD_MEM 0 > SHARD_ID 0 > > DRAUTO 0 > DRINTERVAL 0 > HDR_TXN_SCOPE NEAR_SYNC > DRTIMEOUT 30 > HA_ALIAS > HA_FOC_ORDER SDS,HDR,RSS> DRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound > DRIDXAUTO 0 > LOG_INDEX_BUILDS > SDS_ENABLE > SDS_TIMEOUT 20 > SDS_TEMPDBS > SDS_PAGING > SDS_LOGCHECK 10 > SDS_ALTERNATE NONE > SDS_FLOW_CONTROL 0 > UPDATABLE_SECONDARY 0 > FAILOVER_CALLBACK > FAILOVER_TX_TIMEOUT 0 > TEMPTAB_NOLOG 0 > DELAY_APPLY 0 > STOP_APPLY 0 > LOG_STAGING_DIR > RSS_FLOW_CONTROL 0 > SMX_NUMPIPES 1 > ENABLE_SNAPSHOT_COPY 0 > SMX_COMPRESS 0 > SMX_PING_INTERVAL 10 > SMX_PING_RETRY 6 > CLUSTER_TXN_SCOPE SERVER > > ON_RECVRY_THREADS 1 > OFF_RECVRY_THREADS 10 > > DUMPDIR $INFORMIXDIR/tmp > DUMPSHMEM 1 > DUMPGCORE 0 > DUMPCORE 0 > DUMPCNT 1> > ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh > ALRM_ALL_EVENTS 0 > STORAGE_FULL_ALARM 600,3> SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh > > RAS_PLOG_SPEED 93090 > RAS_LLOG_SPEED 0 > > EILSEQ_COMPAT_MODE 0 > > QSTATS 0 > WSTATS 0 > > USERMAPPING OFF > > SP_AUTOEXPAND 1 > SP_THRESHOLD 0 > SP_WAITTIME 30 > > AUTOLOCATE 0 > > DEFAULTESCCHAR \\\\ > > MQSERVER > MQCHLLIB > MQCHLTAB > > REMOTE_SERVER_CFG > REMOTE_USERS_CFG > S6_USE_REMOTE_SERVER_CFG 0 > > LOW_MEMORY_RESERVE 0 > LOW_MEMORY_MGR 0> > GSKIT_VERSION > > INFORMIXCONTIME 60 > INFORMIXCONRETRY 1> > JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops > JVPLOGFILE $INFORMIXDIR/tmp/jvp.log > JVPARGS -Dcom.ibm.tools.attach.enable=no > JVPCLASSPATH> $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar > > BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 > BUFFERPOOL size=2K,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 > BUFFERPOOL size=8K,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 > > The config is the same as the other server has. What could be the issue ? > > Thanks. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

It looks like your physical log is taking up most of your space. I would imagine that this was moved and grown in your other instance. Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of STEVEN AB Sent: Wednesday, January 04, 2017 4:10 PM To: ids@iiug.org Subject: Not enough room in ROOT DBspace [38418] Hi, I'm trying to setup a new server with the exact configuration like another one but now I just can't initialize the instance. I always receive : oninit: Not enough room in ROOT DBspace. Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K ONCONFIG: ROOTNAME ts_datadbs1 ROOTPATH /storage/chunks/ts_rootdbs ROOTOFFSET 0 ROOTSIZE 2097152MIRROR 0 MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror MIRROROFFSET 0 PHYSFILE 2048000 PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp PHYSBUFF 128 LOGFILES 106 LOGSIZE 10000 DYNAMIC_LOGS 2 LOGBUFF 64 LTXHWM 70 LTXEHWM 80 MSGPATH $INFORMIXDIR/tmp/online.log CONSOLE $INFORMIXDIR/tmp/online.con TBLTBLFIRST 0 TBLTBLNEXT 0 TBLSPACE_STATS 1 DBSPACETEMP ts_tempdbs1, ts_tempdbs2, ts_tempdbs3 SBSPACETEMP SBSPACENAME sbspace SYSSBSPACENAME sbspace ONDBSPACEDOWN 2 SERVERNUM 1 DBSERVERNAME ifx_blk DBSERVERALIASES FULL_DISK_INIT 0 NETTYPE soctcp,1,64,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NUMFDSERVERS 4 NS_CACHE host=900,service=900,user=900,group=900 MULTIPROCESSOR 1 VPCLASS cpu,num=2,noage VP_MEMORY_CACHE_KB 2048 SINGLE_CPU_VP 0 AUTO_TUNE 1 CLEANERS 8 DIRECT_IO 1 LOCKS 200000 DEF_TABLE_LOCKMODE page RESIDENT 0 SHMBASE 0x44000000L SHMVIRTSIZE 5120000 SHMADD 51200 EXTSHMADD 51200 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS CKPTINTVL 300 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp TXTIMEOUT 300 DEADLOCK_TIMEOUT 60 HETERO_COMMIT 0 TAPEDEV /dev/null TAPEBLK 32 TAPESIZE 0 LTAPEDEV /dev/tapedev LTAPEBLK 32 LTAPESIZE 0 BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_MAX_RESTORE BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 BAR_CKPTSEC_TIMEOUT 15 PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL DD_HASHSIZE 31 DD_HASHMAX 10 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 PRELOAD_DLL_FILE STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 USEOSTIME 0 STACKSIZE 64 ALLOW_NEWLINE 0 USELASTCOMMITTED "NONE" FILLFACTOR 90 MAX_FILL_DATA_PAGES 0 BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default ONLIDX_MAXMEM 5120 MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 256 DATASKIP OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 1 STATCHANGE 10 USTLOW_SAMPLE 1 BATCHEDREAD_TABLE 1 BATCHEDREAD_INDEX 1 EXPLAIN_STAT 1 IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA ADMIN_MODE_USERS SSL_KEYSTORE_LABEL TLS_VERSION PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 SQL_LOGICAL_CHAR OFF SEQ_CACHE_SIZE 10 ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE CDR_SUPPRESS_ATSRISWARN CDR_DELAY_PURGE_DTC 0 CDR_LOG_LAG_ACTION ddrblock CDR_LOG_STAGING_MAXSIZE 0 CDR_MAX_DYNAMIC_LOGS 0GRIDCOPY_DIR $INFORMIXDIR CDR_TSINSTANCEID 0 CDR_MAX_FLUSH_SIZE 50 CDR_AUTO_DISCOVER 0 CDR_MEM 0 SHARD_MEM 0 SHARD_ID 0 DRAUTO 0 DRINTERVAL 0 HDR_TXN_SCOPE NEAR_SYNC DRTIMEOUT 30 HA_ALIAS HA_FOC_ORDER SDS,HDR,RSSDRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 10 SDS_ALTERNATE NONE SDS_FLOW_CONTROL 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK FAILOVER_TX_TIMEOUT 0 TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 SMX_NUMPIPES 1 ENABLE_SNAPSHOT_COPY 0 SMX_COMPRESS 0 SMX_PING_INTERVAL 10 SMX_PING_RETRY 6 CLUSTER_TXN_SCOPE SERVER ON_RECVRY_THREADS 1 OFF_RECVRY_THREADS 10 DUMPDIR $INFORMIXDIR/tmp DUMPSHMEM 1 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh ALRM_ALL_EVENTS 0 STORAGE_FULL_ALARM 600,3 SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh RAS_PLOG_SPEED 93090 RAS_LLOG_SPEED 0 EILSEQ_COMPAT_MODE 0 QSTATS 0 WSTATS 0 USERMAPPING OFF SP_AUTOEXPAND 1 SP_THRESHOLD 0 SP_WAITTIME 30 AUTOLOCATE 0 DEFAULTESCCHAR \\\\ MQSERVER MQCHLLIB MQCHLTAB REMOTE_SERVER_CFG REMOTE_USERS_CFG S6_USE_REMOTE_SERVER_CFG 0 LOW_MEMORY_RESERVE 0 LOW_MEMORY_MGR 0 GSKIT_VERSION INFORMIXCONTIME 60 INFORMIXCONRETRY 1 JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops JVPLOGFILE $INFORMIXDIR/tmp/jvp.log JVPARGS -Dcom.ibm.tools.attach.enable=no JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 BUFFERPOOL size=2K,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 BUFFERPOOL size=8K,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 The config is the same as the other server has. What could be the issue ? Thanks. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Sorry, ROOTPATH is $INFORMIXDIR/storage/chunks/ts_rootdbs /storage/chunks is just a storage where the dbs are located and softlinks are made in $INFORMIXDIR/storage/chunks. But all the files are located in /storage/chunks

Original post: Sorry, ROOTPATH is $INFORMIXDIR/storage/chunks/ts_rootdbs /storage/chunks is just a storage where the dbs are located and softlinks are made in $INFORMIXDIR/storage/chunks. But all the files are located in /storage/chunks Response: On the server you are trying to duplicate, it's likely that the physical log and/or the logical logs are not in the rootdbs. You can verify this by looking at onstat -l and onstat -d output. In onstat -l output it would look like this: onstat -l IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line -- Up 00:15:07 --248084 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 0 64 125 4 31.25 phybegin physize phypos phyused %used 1:263 25000 11920 12 0.05 ... <stuff removed> address number flags uniqid begin size used %used 44d8af88 1 U-B---- 1 1:25263 5000 5000 100.00 44b68f68 2 U-B---- 2 1:30263 5000 5000 100.00 44c3ef40 3 U-B---- 3 1:35263 5000 5000 100.00 44c3efa8 4 U-B---- 4 1:40263 5000 5000 100.00 In the above output for the physical log you would look at the information located below the "phybegin" label. In the above output it is 1:263. So that means my physical log is in chunk 1 starting at page offset 263 into that chunk. For the logical logs, I list 4 above, you look at the data below the "begin" column. In all 4 logs, the begin info is 1:<something>. So again the 1 means chunk 1 of the system and then they all have different offsets into that chunk. So in my case, my physical and logical logs are both in chunk 1. Chunk 1 is the 1st chunk of the rootdbs. That is the only place when you initialize an instance for the 1st time (so you are doing full disk initialization) that they can be located. So since you have 3gb's worth of logical and physical log file in the $ONCONFIG file you are copying, but your ROOTSIZE is only 2 gb. That's why the server won't initialize. So for the server you are trying to copy, it must have been set up in 3 steps. First initialize the server with the -i flag...then add more space to the server with onspaces commands to add chunks and or other dbspaces, then use onparam's to add/move your logical logs, and also likely use onparams to increase the size/move your physical log. If that was done, then you can't just copy the $ONCONFIG file from the 1 server....because there is nothing in the $ONCONFIG file that tells the location of the physical and logical log. So when a server goes through disk initialization for the 1st time, the physical and logical logs are located in the 1st and currently only chunk of the rootdbs. After that they can be moved and increased in size (which change the $ONCONFIG values) which would then make using those setting in another server's $ONCONFIG file and trying to do an oninit -iy impossible to achive because the size of those entities is too big for the size configured for ROOTSIZE. Jacques Renaut IBM Informix Advanced Support

Thanks Jaques, that was a good explanation. And how about the first chunk, which is the ROOTNAME. On the other server has the same pagesize and disk size like the other chunks. That means I have to start first with ROOTNAME rootdbs, add the other dbspace with different pagesize , change onconfig with new ROOTNAME and start the instance again ?

You have a 2gb physical log and 1gb of logical logs (106 × 10mb) defined. Reduce those to a small physical log and only 3 logical logs to initialize the instance. Then once you define the dbspaves for logical and physical logs you can redefine them as needed in these other dbspaces. Art On Jan 4, 2017 16:11, "STEVEN AB" <alexsuru1457@gmail.com> wrote: Hi, I'm trying to setup a new server with the exact configuration like another one but now I just can't initialize the instance. I always receive : oninit: Not enough room in ROOT DBspace. Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K ONCONFIG: ROOTNAME ts_datadbs1 ROOTPATH /storage/chunks/ts_rootdbs ROOTOFFSET 0 ROOTSIZE 2097152MIRROR 0 MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror MIRROROFFSET 0 PHYSFILE 2048000 PLOG_OVERFLOW_PATH $INFORMIXDIR/tmp PHYSBUFF 128 LOGFILES 106 LOGSIZE 10000 DYNAMIC_LOGS 2 LOGBUFF 64 LTXHWM 70 LTXEHWM 80 MSGPATH $INFORMIXDIR/tmp/online.log CONSOLE $INFORMIXDIR/tmp/online.con TBLTBLFIRST 0 TBLTBLNEXT 0 TBLSPACE_STATS 1 DBSPACETEMP ts_tempdbs1, ts_tempdbs2, ts_tempdbs3 SBSPACETEMP SBSPACENAME sbspace SYSSBSPACENAME sbspace ONDBSPACEDOWN 2 SERVERNUM 1 DBSERVERNAME ifx_blk DBSERVERALIASES FULL_DISK_INIT 0 NETTYPE soctcp,1,64,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NUMFDSERVERS 4 NS_CACHE host=900,service=900,user=900,group=900 MULTIPROCESSOR 1 VPCLASS cpu,num=2,noage VP_MEMORY_CACHE_KB 2048 SINGLE_CPU_VP 0 AUTO_TUNE 1 CLEANERS 8 DIRECT_IO 1 LOCKS 200000 DEF_TABLE_LOCKMODE page RESIDENT 0 SHMBASE 0x44000000L SHMVIRTSIZE 5120000 SHMADD 51200 EXTSHMADD 51200 SHMTOTAL 0 SHMVIRT_ALLOCSEG 0,3 SHMNOACCESS CKPTINTVL 300 RTO_SERVER_RESTART 0 BLOCKTIMEOUT 3600 CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp TXTIMEOUT 300 DEADLOCK_TIMEOUT 60 HETERO_COMMIT 0 TAPEDEV /dev/null TAPEBLK 32 TAPESIZE 0 LTAPEDEV /dev/tapedev LTAPEBLK 32 LTAPESIZE 0 BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.log BAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.log BAR_DEBUG 0 BAR_MAX_BACKUP 0 BAR_MAX_RESTORE BAR_RETRY 1 BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 BAR_CKPTSEC_TIMEOUT 15 PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL DD_HASHSIZE 31 DD_HASHMAX 10 DS_HASHSIZE 31 DS_POOLSIZE 127 PC_HASHSIZE 31 PC_POOLSIZE 127 PRELOAD_DLL_FILE STMT_CACHE 0 STMT_CACHE_HITS 0 STMT_CACHE_SIZE 512 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 USEOSTIME 0 STACKSIZE 64 ALLOW_NEWLINE 0 USELASTCOMMITTED "NONE" FILLFACTOR 90 MAX_FILL_DATA_PAGES 0 BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default ONLIDX_MAXMEM 5120 MAX_PDQPRIORITY 100 DS_MAX_QUERIES DS_TOTAL_MEMORY DS_MAX_SCANS 1048576 DS_NONPDQ_QUERY_MEM 256 DATASKIP OPTCOMPIND 2 DIRECTIVES 1 EXT_DIRECTIVES 0 OPT_GOAL -1 IFX_FOLDVIEW 1 STATCHANGE 10 USTLOW_SAMPLE 1 BATCHEDREAD_TABLE 1 BATCHEDREAD_INDEX 1 EXPLAIN_STAT 1 IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION UNSECURE_ONSTAT ADMIN_USER_MODE_WITH_DBSA ADMIN_MODE_USERS SSL_KEYSTORE_LABEL TLS_VERSION PLCY_POOLSIZE 127 PLCY_HASHSIZE 31 USRC_POOLSIZE 127 USRC_HASHSIZE 31 SQL_LOGICAL_CHAR OFF SEQ_CACHE_SIZE 10 ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 0 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE CDR_QDATA_SBSPACE CDR_SUPPRESS_ATSRISWARN CDR_DELAY_PURGE_DTC 0 CDR_LOG_LAG_ACTION ddrblock CDR_LOG_STAGING_MAXSIZE 0 CDR_MAX_DYNAMIC_LOGS 0GRIDCOPY_DIR $INFORMIXDIR CDR_TSINSTANCEID 0 CDR_MAX_FLUSH_SIZE 50 CDR_AUTO_DISCOVER 0 CDR_MEM 0 SHARD_MEM 0 SHARD_ID 0 DRAUTO 0 DRINTERVAL 0 HDR_TXN_SCOPE NEAR_SYNC DRTIMEOUT 30 HA_ALIAS HA_FOC_ORDER SDS,HDR,RSSDRLOSTFOUND $INFORMIXDIR/etc/dr.lostfound DRIDXAUTO 0 LOG_INDEX_BUILDS SDS_ENABLE SDS_TIMEOUT 20 SDS_TEMPDBS SDS_PAGING SDS_LOGCHECK 10 SDS_ALTERNATE NONE SDS_FLOW_CONTROL 0 UPDATABLE_SECONDARY 0 FAILOVER_CALLBACK FAILOVER_TX_TIMEOUT 0 TEMPTAB_NOLOG 0 DELAY_APPLY 0 STOP_APPLY 0 LOG_STAGING_DIR RSS_FLOW_CONTROL 0 SMX_NUMPIPES 1 ENABLE_SNAPSHOT_COPY 0 SMX_COMPRESS 0 SMX_PING_INTERVAL 10 SMX_PING_RETRY 6 CLUSTER_TXN_SCOPE SERVER ON_RECVRY_THREADS 1 OFF_RECVRY_THREADS 10 DUMPDIR $INFORMIXDIR/tmp DUMPSHMEM 1 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh ALRM_ALL_EVENTS 0 STORAGE_FULL_ALARM 600,3SYSALARMPROGRAM $INFORMIXDIR/etc/evidence.sh RAS_PLOG_SPEED 93090 RAS_LLOG_SPEED 0 EILSEQ_COMPAT_MODE 0 QSTATS 0 WSTATS 0 USERMAPPING OFF SP_AUTOEXPAND 1 SP_THRESHOLD 0 SP_WAITTIME 30 AUTOLOCATE 0 DEFAULTESCCHAR \\\\ MQSERVER MQCHLLIB MQCHLTAB REMOTE_SERVER_CFG REMOTE_USERS_CFG S6_USE_REMOTE_SERVER_CFG 0 LOW_MEMORY_RESERVE 0 LOW_MEMORY_MGR 0 GSKIT_VERSION INFORMIXCONTIME 60 INFORMIXCONRETRY 1 JVPPROPFILE $INFORMIXDIR/extend/krakatoa/.jvpprops JVPLOGFILE $INFORMIXDIR/tmp/jvp.log JVPARGS -Dcom.ibm.tools.attach.enable=no JVPCLASSPATH $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/ extend/krakatoa/jdbc.jar BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 BUFFERPOOL size=2K,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 BUFFERPOOL size=8K,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60.5 The config is the same as the other server has. What could be the issue ? Thanks. ************************************************************ ******************* Forum Note: Use "Reply" to post a response in the discussion forum. --047d7b86e14e8b3dc905454c9752

Hi Art, I reduced the number of logical logs to 4 and it was enough. I was asking before why the chunk ts_datadbs1 is the ROOTNAME and not ts_rootdbs Thank you.

No idea. Art On Jan 4, 2017 18:11, "STEVEN AB" <alexsuru1457@gmail.com> wrote: > Hi Art, > I reduced the number of logical logs to 4 and it was enough. > I was asking before why the chunk ts_datadbs1 is the ROOTNAME and not > ts_rootdbs > > Thank you. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11423f324058a605454d294d

You don't actually have to restart. Boot the instance with the reduced physical and logical logs (6 logs is enough). Once up, create a physical log dbspace and a logical log dbspace. Move the physical log to the physcial log dbspace, you can change the size on the fly, or reset it in $ONCONFIG and reboot. Create logical logs in the logical log dbspace, drop the logical logs from the rootdbs. A nice clean way to do all of this is to connect to the sysadmin database with dbaccess and: execute function task("alter plog", "<dbspace_name>", "<size>"); execute function task("add log", "<dbspace_name>", "<size>", "<number>"); replace dbspace_name, size and number with the values you want to use. When dropping logical logs, you can't drop the current log, you have to move off of it onto your new ones: onmode -l will advance one log. That will still leave the starting login the old logs, so once you get advanced into the new logs, do an "onmode -c" to force a checkpoint and make the current log the starting log. You can do all of that from within sysadmin as well. j. On 1/4/17 5:05 PM, STEVEN AB wrote: > Thanks Jaques, that was a good explanation. > > And how about the first chunk, which is the ROOTNAME. > On the other server has the same pagesize and disk size like the other chunks. > That means I have to start first with ROOTNAME rootdbs, add the other dbspace > with different pagesize , change onconfig with new ROOTNAME and start the > instance again ? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks

You have: ROOTNAME ts_datadbs1 In your $ONCONFIG? ts_datadbs1 should then be the logical name of your first dbspace. Using the file: ROOTPATH /storage/chunks/ts_rootdbs Is that not what you see? What is the output of onstat -d? j. On 1/4/17 6:57 PM, STEVEN AB wrote: > Hi Jack, > thanks for your response. > > I already created physical and logical log dbspaces, moved the physical log to > that dbspaces and created the rest of the logical logs in the other dbspace. > > But I was wondering why the first dbspaces is the ROOTNAME > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Hi, after a little test I would say: The value of ROOTNAME is arbitrary. Usually it is rootdbs but other values are allowed. Thank you, Reinhard. -----Ursprüngliche Nachricht----- Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Im Auftrag von Jack Parker Gesendet: Donnerstag, 5. Januar 2017 01:23 An: ids@iiug.org Betreff: Re: Not enough room in ROOT DBspace [38433] You have: ROOTNAME ts_datadbs1 In your $ONCONFIG? ts_datadbs1 should then be the logical name of your first dbspace. Using the file: ROOTPATH /storage/chunks/ts_rootdbs Is that not what you see? What is the output of onstat -d? j. On 1/4/17 6:57 PM, STEVEN AB wrote: > Hi Jack, > thanks for your response. > > I already created physical and logical log dbspaces, moved the > physical log to > that dbspaces and created the rest of the logical logs in the other dbspace. > > But I was wondering why the first dbspaces is the ROOTNAME > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.