I have the problem that in my DB2 database (SLES, Db2 v10.5) my User Temp Tablespaces are all in state
Restore pending, Storage must be defined, Storage may be defined.
When I set off the following command
db2 list tablespace I get the following output (e.g.):
Tablespace ID = 6 Name = USERTEMP4 Type = System managed space Contents = User Temporary data State = 0x2001100 Detailed explanation: Restore pending Storage must be defined Storage may be defined
Can anybody help me to escape from this situation? I didn't start any restore recently so I'm wondering how or why the tablespaces have changed to this state.