You must drop all tables in the dbspace before dropping the dbspace. You cannot use the DROP DBSPACE statement to drop the
predefined dbspaces SYSTEM, TEMPORARY, TEMP, TRANSLOG, or TRANSLOGMIRROR. See Predefined dbspaces.
DROP DBSPACE is prevented whenever the statement affects an object that is currently being used by another connection.