IDS Forum

Re: Not enough room in ROOT DBspace

Posted By: Jack Parker
Date: Wednesday, 4 January 2017, at 4:21 p.m.

In Response To: Not enough room in ROOT DBspace (STEVEN AB)

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.
>
>

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.