Hello,

DB2 V8 FP 10 running Linux RedHat 4.0.

I have created a system temporary tablespace and now I want to delete
it. However:

[db2inst1@asset4 extra]$ db2 "drop tablespace reorg"
DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned: SQL0291N State transition not allowed on table space.
SQLSTATE=55039

Diag:

2005-11-11-10.28.22.467127-120 I230628531G436 LEVEL: Error
PID : 3100 TID : 3086919360 PROC : db2agent
(RTMDB)
INSTANCE: db2inst1 NODE : 000 DB : RTMDB
APPHDL : 0-2033 APPID: *LOCAL.db2inst1.060129204323
FUNCTION: DB2 UDB, buffer pool services, sqlbDropPool, probe:905
RETCODE : ZRC=0x80020038=-2147352520=SQLB_INVALID_STATE_TRANSITION
"Invalid state transition"


db2 list tablespaces show detail

Tablespace ID = 23
Name = REORG
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 16384
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1

I have tried searching the documentation but there is nothing that
pointed me to the right direction. Can anyone suggest anything?

TIA,

Michel.

REORG is a keyword in DB2, I would not use it as a name.

Still, check whether there are any locks on the tablespace (Lock
snapshot), it might be that there is still a connection open (list
applications) and accessing the tablespace.