"db2udbgirl" <db********@gmail.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...
1. Yes it is a system temporary tablespace
Name = T_0001
Type = Database managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
So to resolve the problem I think that I need to drop the default
TEMPSPACE1 tablespace show that DB2 would always use the big TEMPSPACE.
Is this assumption correct ?
Thanks,
db2udbgirl.
Yes, that will work fine if the T_0001 is large enough.
BTW, SMS is recommended for system temporary tablespaces because it takes
longer to create a table in DMS (as it optimizes space), and system
temporary tables need to be created and dropped quickly during the execution
of an SQL statement.