Technote (troubleshooting)

Problem(Abstract)

After you recover a dropped QMF table through the DSN1COPY utility and image copy, the REBUILD INDEX utility fails with RESOURCE NOT AVAILABLE, REASON=X'00C2010D'.

Symptom

This problem can occur when a QMF table is dropped in DB2 Version 9 or later, then the table is re-created and DSN1COPY is successfully run against an image copy. In cases such as this, the REBUILD INDEX(ALL) utility ends with RESOURCE NOT AVAILABLE, REASON=X'00C2010D'.

Cause

QMF tables were created in simple table spaces before DB2 Version 9. DB2 supports these simple table spaces in DB2 Version 9 and later. However, if a table is dropped on DB2 Version 9 or later and the table is re-created, the new table is created in a segmented table space. DB2 Versions 9 and later do not create simple table spaces.

Resolving the problem

Rather than using DSN1COPY against an image copy, use the DB2 UNLOAD utility with PK60612 (UK35132). DB2 UNLOAD can process an image copy of a table space that was non-segmented and is now defined as segmented.