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

(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

Operating system(s):

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

Reference #:

1594965

Modified date:

2013-01-15

Translate my page

Machine Translation

Content navigation