论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-10-02 17:37 |只看该作者 |倒序浏览

I wish to know what is High water mark? how can view it? What the impact to have High water mark? Please Advise

文库|博客

mymm

荣誉版主

论坛徽章:: 0

2楼 [报告]

发表于 2004-10-03 19:26 |只看该作者

High water mark

在SMS中，它没有用！

在DMS中，是“Used pages ”到过的最大值！

如果想降低它：

在7.2里，只能通过导出/重建/再导入！

在8.1里，除了以上方法外，还可以用db2dart！但没测试过，这个命令在7.2里肯定不行！

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

toms1981

稍有积蓄

论坛徽章:: 0

3楼 [报告]

发表于 2004-10-04 09:15 |只看该作者

High water mark

Now 1 of the my tablespace Used pages is equal to High Water Mark means what? will it affect the performance?

Tablespace ID                      = 36
Name                               = TS251505
Type                               = Database managed space
Contents                            = Any data
State                               = 0x0000
Detailed explanation:
   Normal
Total pages                         = 500
Useable pages                      = 480
Used pages                         = 224
Free pages                         = 256
High water mark (pages)             = 224
Page size (bytes)                   = 4096
Extent size (pages)                = 32
Prefetch size (pages)             = 32
Number of containers                = 1

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

mymm

荣誉版主

论坛徽章:: 0

4楼 [报告]

发表于 2004-10-08 16:06 |只看该作者

High water mark

原帖由 "toms1981" 发表：

Tablespace ID = 36
Name = TS251505
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 500
Useable pages = 480
Used pages = 224
Free pages = 256
High water mark (pages) = 224
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1