db2 "CREATE DATABASE SHABLON ON /data/databases USING CODESET ISO- 8859 - 1  TERRITORY DE
db2 update db cfg for SHABLON using APPLHEAPSZ  2048 
db2 update db cfg for SHABLON using DBHEAP  200000  

CREATE BUFFERPOOL LONGTEMPPOOL SIZE  21688  PAGESIZE  32  K EXTENDED STORAGE; 

 
CREATE  SYSTEM TEMPORARY  TABLESPACE LONGTEMPSPACE PAGESIZE  32  K MANAGED BY SYSTEM  USING ('/data/tmp/longtempspace_SHABLON.cont') EXTENTSIZE  32  OVERHEAD  24 . 1  PREFETCHSIZE  32  TRANSFERRATE  0 . 9  BUFFERPOOL LONGTEMPPOOL;

CREATE  LONG  TABLESPACE LONGUSERSPACE PAGESIZE  32  K  MANAGED BY DATABASE  USING ( FILE '/data/tmp/longuserspace_SHABLON'  1280 ) EXTENTSIZE  32  OVERHEAD  24 . 1  PREFETCHSIZE  256  TRANSFERRATE  0 . 9  BUFFERPOOL LONGTEMPPOOL;

CREATE  REGULAR  TABLESPACE REGULARUSERSPACE PAGESIZE  32  K  MANAGED BY DATABASE  USING ( FILE '/data/tmp/regularuserspace_SHABLON'  1280  ) EXTENTSIZE  32  OVERHEAD  24 . 1  PREFETCHSIZE  256  TRANSFERRATE  0 . 9  BUFFERPOOL LONGTEMPPOOL;

 
 -- -----------------------------------------------------------------------------------------------;
 
 -- ----------------------------TObject -------------------------------------------------------;    
 
 -- -----------------------------------------------------------------------------------------------;    
 

CREATE TABLE TObject (
 idObject BIGINT NOT NULL DEFAULT  0  ,   
 name CHAR ( 254 ) NOT NULL DEFAULT '' , 
 PRIMARY KEY(idObject)
);

CREATE SEQUENCE TObjectSEQ START WITH  1  INCREMENT BY  1  NOMAXVALUE NOCYCLE NO CACHE;

CREATE  INDEX TObjIND1 
      ON TObject (idObject DESC) PCTFREE  10  MINPCTUSED  10 ; 

 -- -----------------------------------------------------------------------------------------------;    
 
 -- ---------------------------TObjectProperties------------------------------------------;    
 
 -- -----------------------------------------------------------------------------------------------;    
 

CREATE TABLE TObjectProperties (
    idObject BIGINT NOT NULL DEFAULT  0 ,   
    idProperty BIGINT  NOT NULL DEFAULT  0  , 
    value LONG VARCHAR NOT NULL DEFAULT ''
) DATA CAPTURE NONE   IN REGULARUSERSPACE INDEX IN REGULARUSERSPACE  LONG IN LONGUSERSPACE;

CREATE  INDEX TObjPropIND1 
      ON TObjectProperties (idObject DESC) PCTFREE  10  MINPCTUSED  10 ; 

backup database SHABLON to /data/backup with  2  BUFFERS BUFFER  1024  without prompting

RESTORE DATABASE SHABLON FROM /data/backup TAKEN AT  20031117164040  TO /data/databases INTO PROJ001 WITH  2  BUFFERS BUFFER  1024  REDIRECT WITHOUT PROMPTING


SET TABLESPACE CONTAINERS FOR  5  IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (file '/data/tmp/tscon5'  2000 )  

SET TABLESPACE CONTAINERS FOR  4  IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (file '/data/tmp/tscon4'  2000 )  

SET TABLESPACE CONTAINERS FOR  3  IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH '/data/tmp/tscon3')  

RESTORE DATABASE SHABLON CONTINUE