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.