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
- Space is still in use
- Possibly APAR
Diagnosing the problem
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 ( across all chunks ) then drop the dbspace instead of trying to drop individual chunks. You cannot drop chunks which contain only TBLSPACE and FREE entries. This would drop some of the table extents for the TBLSPACE essentially corrupting it, this is not allowed and why the error would be returned trying to drop an empty chunk.
NOTE: This does not mean you can drop chunks that have user data in them.
How to determine which tables have byte or text (blob) data stored in a blobspace.
IC80385: DROPPING A BLOBSPACE FAILS IF NO CHECKPOINT OCCURRED BETWEEN TABLE CREATION AND DROPPING THAT TABLE'S TEXT OR BYTE COLUMN