Properties

Name:	NICK_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 NICK_STAFF_MQT_TS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM
     USING ('C:\DB2\NODE0000\SQL00001\NICK_STAFF_MQT_TS')
     EXTENTSIZE 8
     PREFETCHSIZE 8
     BUFFERPOOL IBMDEFAULTBP
     OVERHEAD 12.670000
     TRANSFERRATE 0.180000
     DROPPED TABLE RECOVERY ON;

See Also

List of tablespaces