Troubleshooting
Problem
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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21328752