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: |
Grantor | Grantee | Authorities | |
|
SYSIBM | USER | USE=HELD_GRANTABLE |
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