Errors 212 and 131 when creating an index

Technote (troubleshooting)


Problem(Abstract)

You try to create an index but the sql fails with these errors:

-212 Cannot add index.

-131 ISAM error: no free disk space.

Symptom

You try to create an index but the sql fails with these errors:

-212 Cannot add index.

-131 ISAM error: no free disk space.

Cause

There is not sufficient disk space in the dbspace or dbspaces to create the index.


Diagnosing the problem

Determine in which dbspace or dbspaces the index will be created. If a table is not fragmented, then an index will be created in the same dbspace as the table. If a table is fragmented, then an index will follow the table's fragmentation schema. If an index is fragmented, then check the CREATE INDEX sql used to determine which dbspaces are used. onstat -d output will help you determine which dbspace or dbspaces do not have enough disk space for the creation of the index.

See the Related information section for help.


Resolving the problem


  • Add more space to the dbspace or dbspaces.
  • Choose another dbspace or dbspaces using the IN clause in the CREATE INDEX syntax.

See the Related information section for several links to information that will assist you in successfully creating an index when dealing with errors 212 and 131.

Related information

Adding space to a dbspace
CREATE INDEX syntax
Estimating index size
Where will a detached index be created?
Where will an attached index be created?
Description of onstat -d output

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

7.3, 9.4, 10.0, 11.1, 11.5, 11.7

Operating system(s):

AIX, DYNIX/ptx, Digital Unix (OSF1)(TRU64), HP-UX, IRIX, Linux, Mac OS X, Reliant UNIX, Sinix, Solaris, Windows

Reference #:

1328752

Modified date:

2012-04-16

Translate my page

Machine Translation

Content navigation