Skip to content

ERR-110F0 Unable to extend the tablespace (SYS_TBS_MEM_DIC) because the database would be larger than MEM_MAX_DB_SIZE(12582912K)#

Version#

All versions

Explanation#

INSERT/UPDATE/DELETE statements cannot be executed on memory tablespaces.

Only the SELECT statement is executable.

Cause#

This error occurs when the total sum of memory tablespaces (SYS_TBS_MEM_DIC+SYS_TBS_MEM_DATA+USER_MEMORY_TABLESPACE) exceeds MEM_MAX_DB_SIZE.

Action#

MEM_MAX_DB_SIZE is the maximum amount of memory that can be used by memory tablespaces.

For further information, refer to the Altibase Monitoring Queries Guide.

The tablespace area cannot be returned unless a table is dropped. (The COMPACT command can return the blank page, but the effect is negligible.)

Therefore, if MEM_MAX_DB_SIZE is set lower than the actual amount, change the value of MEM_MAX_DB_SIZE from $ALTIBASE_HOME/conf/altibase.properties and restart the Altibase server process.

It is recommended to set the maximum value of MEM_MAX_DB_SIZE as the sum of VOLATILE_MAX_DB_SIZE and MEM_MAX_DB_SIZE within 60 to 70 percent of the physical memory.

  • Checking MEM_MAX_DB_SIZE

    iSQL> SELECT value1 FROM v$property WHERE name = 'MEM_MAX_DB_SIZE';
    VALUE1                          
    ----------------------------------
    33554432                        
    1 row selected.
    

    The above example shows the maximum size (bytes) that can be used.

  • Checking Usage

    iSQL> SELECT SPACE_NAME, MAXSIZE, ALLOC_PAGE_COUNT*32*1024 FROM V$MEM_TABLESPACES;
    SPACE_NAME                      MAXSIZE              ALLOC_PAGE_COUNT*32*1024 
    ----------------------------------------------------------------------------------
    SYS_TBS_MEM_DIC                 140737488322560      8421376                
    SYS_TBS_MEM_DATA                140737488322560      8421376                
    MEM_TBS                         140737488322560      12615680               
    3 rows selected.
    

    The above example shows the current usage of the memory tablespace. There are 29,458,432 bytes allocated in total.

    A maxsize value of 140737488322560 means unlimited.

    For SYS_TBS_MEM_DIC and SYS_TBS_MEM_DATA, they have not reached MAXSIZE but the error has occurred because the sum of all the memory tablespaces has almost reached MEM_MAX_DB_SIZE.

    The current sum shows the value of 899(29458432/32/1024) pages and the actual MEM_MAX_DB_SIZE is 1024(33554432/32/1024) pages. Thus, there are still 125 pages that can be allocated. However, as the default value of EXPAND_CHUNK_PAGE_COUNT (the number of pages by which to increase the size of the memory tablespace) is 128, it means that all the pages are currently being used. (The error occurs when MEM_MAX_DB_SIZE is exceeded because the transaction tried to expand.)

    Note

    Each memory tablespace has its own MAXSIZE. This error not only occurs when it has reached its MAXSIZE but also when the sum of all the memory tablespaces exceeds MEM_MAX_DB_SIZE.

  • Restarting Altibase server after increasing MEM_MAX_DB_SIZE

    $ vi $ALTIBASE_HOME/conf/altibase.properties
    ....
    ....
    UNIXDOMAIN_FILEPATH    =?/trc/cm-unix
    MEM_MAX_DB_SIZE        =  1G             <===== Change this value to the appropriate size (Using GB/MB unit)
    LOG_FILE_SIZE          =  10M
    ....
    ....
    :wq!
    
    $ server restart
    

    It needs to restart the server after modification.

  • Checkpoint Image File Size

    For in-memory databases of Altibase, any modified data from in-memory databases is saved on disk when checkpointing is executed. The disk file where memory data is saved is called the Checkpoint Image file. This file cannot be resized, which means that once it is expanded, it cannot be reduced.

    Note

    In order to reduce the Checkpoint Image file size, REORG has to be executed. This has to be done with the migration of all data, including the disk database.

Reference#

N/A