Properties

Name:	QQQ_STAFF_MQT_TS
Definer:	USER
Create time:	01.07.2006
Extent size:	8
Prefetch size:	8
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