Previous Topic: -258 - TABLE FULL - DBID=nnnn INTERNAL NAME aaaNext Topic: -260 - UNIQUE CONSTRAINT constraint-name DUPLICATES KEY key-name


-259 - INDEX FULL - DBID=nnnn

Explanation

The INSERT/UPDATE request was denied because all of the space allocated for the index is being used. Although no empty blocks exist, other key values can be added if all blocks are not totally full.

The SQLSTATE that equates to this SQL return code is 57S04.

User Response

Execute the DBUTLTY EXTEND AREA=IXX function to enlarge the Index Area, or delete some of the current index entries.

When the Compound Boolean Selection temporary index fills up, the Index Area is automatically cleared when the User Requirements Table closes.