REBUILD INDEX utility fails with RESOURCE NOT AVAILABLE, REASON=X'00C2010D' when recovering QMF table

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.

For more information about this issue, see the IBM Redbooks® publication DB2 9 for z/OS: Using the Utilities Suite (http://www.redbooks.ibm.com/redbooks/pdfs/sg246289.pdf), form number SG24-6289, and search for "Unloading from an image copy".


Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Query Management Facility
QMF for TSO/CICS

Software version:

9.1, 10.1

Operating system(s):

z/OS

Reference #:

1616374

Modified date:

2013-03-26

Translate my page

Machine Translation

Content navigation