Recycling index version numbers
To prevent Db2 from running out of index version numbers (and to prevent subsequent ALTER statements from failing), you must recycle unused index version numbers regularly.
About this task
Db2 can store up to 16 index versions,
numbered sequentially from 0 - 15. The next consecutive version number after 15 is 1. Version number
0 is never reused, because it is reserved for the original version of the index. The versions that
are associated with schema changes that have not been applied yet are considered to be in
use,
and the range of used versions is stored in the catalog. In use versions can be recovered
from image copies of the table space, if necessary.
Version numbers are considered to be unused if the schema changes that are associated with them have been applied and no image copies contain data at those versions.
Procedure
To recycle unused index version numbers: