Properties

Name: TSASNCA 
Definer: USER 
Create time: 01.07.2006 
Extent size: 32 
Prefetch size: -1 
Overhead: 12,67 
Transfer rate: 0,18 
Page size: 4096 
Default partition group: IBMDEFAULTGROUP 
Bufferpool: IBMDEFAULTBP 
Drop recovery:  
Description:  

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  USE=HELD_GRANTABLE 
Total: 1 autherisation(s)

SQL

CREATE REGULAR TABLESPACE TSASNCA IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
     USING (FILE 'C:\DB2\NODE0000\SQL00001\TSASNCA'2560)
     EXTENTSIZE 32
     PREFETCHSIZE AUTOMATIC
     BUFFERPOOL IBMDEFAULTBP
     OVERHEAD 12.670000
     TRANSFERRATE 0.180000
     DROPPED TABLE RECOVERY ON;

See Also

List of tablespaces