查看表空间是否自动存储、1、db2 get snapshot for tablespaces on test Tablespace Type = Database managed space Tabl...
显示全部
查看表空间是否自动存储、
1、
db2 get snapshot for tablespaces on test
Tablespace Type = Database managed space
Tablespace Content Type = All permanent data. Large table space.
Tablespace Page size (bytes) = 4096
Tablespace Extent size (pages) = 32
Automatic Prefetch size enabled = Yes
Buffer pool ID currently in use = 1
Buffer pool ID next startup = 1
Using automatic storage = Yes --使用了自动存储器
Auto-resize enabled = Yes
File system caching = No
2、使用 DB2 提供的如下快照表函数
db2 => select char((TBSP_NAME),30) as TBSP_NAME,TBSP_ID,TBSP_USING_AUTO_STORAGE from table(snap_get_tbsp('TEST',-1)) as tbsp
TBSP_NAME TBSP_ID TBSP_USING_AUTO_STORAGE
------------------------------ -------------------- -----------------------
SYSCATSPACE 0 1
TEMPSPACE1 1 1
USERSPACE1 2 1
SYSTOOLSPACE 3 1
SYSTOOLSTMPSPACE 4 1
为1则启动自动存储
如果是sms本身就是自动存储
如果是dms,就看Automatic Prefetch size enabled,区别就是dms不自动扩展,表空间满了之后需要手动处理,automatic则不需要
收起