我的DB2 数据库版本是9.5 的,当前有一个表空间USERSPACE1是DMS 自动扩展管理,但当前使用率已经95%了还没自动扩展,请大家帮给各建议。
收起方法很多啦, 例如 get snapshot for tablepaces. 这是我的一个test system
关心两件事:auto extend and max size
Tablespace name = USERSPACE1
Tablespace ID = 2
Tablespace Type = Database managed space
Tablespace Content Type = All permanent data. Large table space.
Tablespace Page size (bytes) = 8192
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
Tablespace State = 0x\'00000000\'
Detailed explanation:
Normal
Tablespace Prefetch size (pages) = 32
Total number of pages = 4096
Number of usable pages = 4064
Number of used pages = 1824
Number of pending free pages = 0
Number of free pages = 2240
High water mark (pages) = 1824
Initial tablespace size (bytes) = 33554432
Current tablespace size (bytes) = 33554432
Maximum tablespace size (bytes) = NONE
Increase size (bytes) = AUTOMATIC
Time of last successful resize =
Last resize attempt failed = No
Rebalancer Mode = No Rebalancing
Storage paths have been dropped = No
Minimum Recovery Time = 05/12/2015 19:29:51.000000
Number of quiescers = 0
Number of containers = 1