IDS Forum

Not enough room in ROOT DBspace

Posted By: STEVEN AB
Date: Wednesday, 4 January 2017, at 4:09 p.m.

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.

Messages In This Thread

• Not enough room in ROOT DBspace
  STEVEN AB -- Wednesday, 4 January 2017, at 4:09 p.m.
  • Re: Not enough room in ROOT DBspace
    JACQUES RENAUT -- Wednesday, 4 January 2017, at 4:16 p.m.
    • Re: Not enough room in ROOT DBspace
      STEVEN AB -- Wednesday, 4 January 2017, at 4:27 p.m.
      • Re: Not enough room in ROOT DBspace
        JACQUES RENAUT -- Wednesday, 4 January 2017, at 4:45 p.m.
        • Re: Not enough room in ROOT DBspace
          STEVEN AB -- Wednesday, 4 January 2017, at 5:05 p.m.
          • Re: Not enough room in ROOT DBspace
            Jack Parker -- Wednesday, 4 January 2017, at 6:49 p.m.
            • Re: Not enough room in ROOT DBspace
              STEVEN AB -- Wednesday, 4 January 2017, at 6:57 p.m.
              • Re: Not enough room in ROOT DBspace
                Jack Parker -- Wednesday, 4 January 2017, at 7:22 p.m.
                • AW: Not enough room in ROOT DBspace
                  Habichtsberg, Reinhard -- Wednesday, 11 January 2017, at 9:11 a.m.
  • Re: Not enough room in ROOT DBspace
    Jack Parker -- Wednesday, 4 January 2017, at 4:21 p.m.
  • RE: Not enough room in ROOT DBspace
    Mueller, Daniel D. -- Wednesday, 4 January 2017, at 4:25 p.m.
  • Re: Not enough room in ROOT DBspace
    Art Kagel -- Wednesday, 4 January 2017, at 5:49 p.m.
    • Re: Not enough room in ROOT DBspace
      STEVEN AB -- Wednesday, 4 January 2017, at 6:11 p.m.
      • Re: Not enough room in ROOT DBspace
        Art Kagel -- Wednesday, 4 January 2017, at 6:30 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.