Running onspaces -d to drop a space but see error Cannot drop the Space. ISAM error: DBspace is not empty

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 ( 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.
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:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

7.3, 9.4, 10.0, 11.1, 11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1594965

Modified date:

2014-06-09

Translate my page

Machine Translation

Content navigation