REBUILD INDEX utility fails with RESOURCE NOT AVAILABLE, REASON=X'00C2010D' when recovering QMF table
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'.
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'.
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".
More support for:
DB2 Query Management Facility
QMF for TSO/CICS
Software version: 9.1, 10.1, 11.1, 11.2
Operating system(s): z/OS
Reference #: 1616374
Modified date: 08 April 2016
Translate this page: