Properties

Name: QQQ_STAFF_MQT_TS 
Definer: USER 
Create time: 01.07.2006 
Extent size:
Prefetch size:
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 QQQ_STAFF_MQT_TS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM
     USING ('C:\DB2\NODE0000\SQL00001\QQQ_STAFF_MQT_TS')
     EXTENTSIZE 8
     PREFETCHSIZE 8
     BUFFERPOOL IBMDEFAULTBP
     OVERHEAD 12.670000
     TRANSFERRATE 0.180000
     DROPPED TABLE RECOVERY ON;
ALTER TABLESPACE SYSCATSPACE
      PREFETCHSIZE AUTOMATIC
      OVERHEAD 12.670000
      TRANSFERRATE 0.180000;
ALTER TABLESPACE TEMPSPACE1
      PREFETCHSIZE AUTOMATIC
      OVERHEAD 12.670000
      TRANSFERRATE 0.180000;
ALTER TABLESPACE USERSPACE1
      PREFETCHSIZE AUTOMATIC
      OVERHEAD 12.670000
      TRANSFERRATE 0.180000;

See Also

List of tablespaces