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.

Document information


More support for:

Informix Servers

Software version:

11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1328752

Modified date:

2015-01-28

Translate my page

Content navigation