Skip to content

ERR-11030 ( 69680) The data file cannot be extended because the requested size is bigger than the maximum size (FID:<0%d>).#

Overview#

This document describes the cause of the ERR-11030 error that occurs in Altibase 4 when attempting to increase the size of a disk data file configured with AUTOEXTEND OFF, and explains how to resolve it.

Version#

Altibase 4

Symptom#

The following error occurs when changing the size of a data file in a disk tablespace.

iSQL> ALTER TABLESPACE user_tbs_data ALTER DATAFILE 'user001.dbf' SIZE 512M;
[ERR-11030 : The data file cannot be extended because the requested size is bigger than the maximum size (FID:0).]
iSQL> 

Cause#

In Altibase 4, when a data file is created with AUTOEXTEND OFF, the initial size specified at creation is also set as the maximum size of the data file.

Therefore, this error occurs when the data file size is changed to a value greater than this maximum size.

Resolution#

To increase the size of a data file configured with AUTOEXTEND OFF, first change AUTOEXTEND to ON, and then increase the data file size.

After changing the size, change AUTOEXTEND back to OFF if necessary.

Perform the following steps.

1) Change AUTOEXTEND to ON.

iSQL> ALTER TABLESPACE user_tbs_data ALTER DATAFILE 'user001.dbf' AUTOEXTEND ON;
Alter success.

2) Change the data file size.

iSQL> ALTER TABLESPACE user_tbs_data ALTER DATAFILE 'user001.dbf' SIZE 512M;
Alter success.

3) Change AUTOEXTEND back to OFF.

iSQL> ALTER TABLESPACE user_tbs_data ALTER DATAFILE 'user001.dbf' AUTOEXTEND OFF;
Alter success.

Reference#

In Altibase 4, when a data file is created with AUTOEXTEND OFF, the size specified at creation is set as both the current size and the maximum size.

You can check the AUTOEXTEND setting, initial size, current size, and maximum size of a data file in the V$DATAFILES performance view.

An AUTOEXTEND value of 1 means ON, and 0 means OFF.

The following example creates a disk tablespace with a data file configured with AUTOEXTEND OFF.

iSQL> CREATE TABLESPACE user_tbs_data DATAFILE 'user001.dbf' SIZE 128M;
Create success.

The current size (CURRSIZE) and maximum size (MAXSIZE) of user001.dbf are the same as the initial size (INITSIZE).

iSQL> SELECT NAME, AUTOEXTEND , INITSIZE, CURRSIZE, MAXSIZE 
        FROM V$DATAFILES 
       WHERE NAME LIKE '%user001.dbf';
NAME                                      AUTOEXTEND  INITSIZE             CURRSIZE             MAXSIZE              
---------------------------------------------------------------------------------------------------------------------------
/sas/bella/439.234/dbs/user001.dbf        0           16384                16384                16384                
1 row selected.

Starting with Altibase 5, the maximum size of a data file configured with AUTOEXTEND OFF is set to the maximum file size allowed by the operating system, and V$DATAFILES.MAXSIZE is displayed as 0.

iSQL> SELECT NAME, AUTOEXTEND , INITSIZE, CURRSIZE, MAXSIZE 
        FROM V$DATAFILES 
       WHERE NAME LIKE '%user001.dbf';
NAME                                      AUTOEXTEND  INITSIZE             CURRSIZE             MAXSIZE              
---------------------------------------------------------------------------------------------------------------------------
/sas/bella/73021/dbs/user001.dbf          0           16384                16384                0                    
1 row selected.