Hi guyz,

When i executed the following code in SPUFI, i got the following ERROR message.
Code:
  DECLARE GLOBAL TEMPORARY TABLE DEPTTMP                                        
    (DEPT    SMALLINT NOT NULL                                                  
    ,NAME    CHAR(5)  NOT NULL                                                  
    )                                                                           
  ;                                                                             
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN            
         UNAVAILABLE RESOURCE. REASON 00E7009A, TYPE OF RESOURCE 200, AND       
         RESOURCE NAME TABLESPACE IN TEMPDB                                     
DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE                                
DSNT415I SQLERRP    = DSNXIDCL SQL PROCEDURE DETECTING ERROR                    
DSNT416I SQLERRD    = 15 0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION              
DSNT416I SQLERRD    = X'0000000F'  X'00000000'  X'00000000'  X'FFFFFFFF'        
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION                    
---------+---------+---------+---------+---------+---------+---------+---------+
TEMPDB database already exists with one Segmented tablespace TMPSTS01.

Can i know the reason for this ? How can i get over & resolve it ?

Thank You,
Sushanth BObby