Technote (troubleshooting)
Problem(Abstract)
You are trying to drop a space running onspaces -d but an error is returned:
Cannot drop the Space.
ISAM error: DBspace is not empty
Cause
- Space is still in use
- Possibly APAR
Diagnosing the problem
oncheck -pe
Resolving the problem
- Drop user created tables that still exist in the dbspace. Then drop the dbspace.
- If only TBLSPACE and FREE entries remain in the dbspace then drop the dbspace instead of trying to drop individual chunks. You cannot drop chunks with TBLSPACE entries but you can drop a dbspace that has only TBLSPACE and FREE entries.
How to determine which tables have byte or text (blob) data stored in a blobspace.
http://www.ibm.com/support/docview.wss?uid=swg21594966
IC80385: DROPPING A BLOBSPACE FAILS IF NO CHECKPOINT OCCURRED BETWEEN TABLE CREATION AND DROPPING THAT TABLE'S TEXT OR BYTE COLUMN
http://www.ibm.com/support/docview.wss?uid=swg1IC80385
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.