I wish to know what is high water mark? how can view it? What the impact to have high water mark? Please Advise
关数据库时,alert_log提示: Shutting down instance (abort) license high water mark = 85 Instance terminated by USER, pid = 6724 其中license high water mark = 85是什么意思
书中说: truncate table order reuse storage 可以keep the storage,remove all rows,reset the high-water mark,and commit the change 请问其中的high-water mark是什么意思??
reorg及runstats后high water mark参数不降的原因是什么? 哪位有比较好的方法把这个参数值降下来? :lol: :lol: :lol: :lol:
在DB2 V7.x版本中,如果数据库文件原大小为22G,做过数据清理且做过reorg后为14G。 此时,使用db2 list tablespaces show detail命令查看表空间的大小,显示如下: Tablespace ID = 2 Name = USERSPACE1 Type = Database managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 6455296 Useable pages = 6455232 Used pages = 3336096 Free pages = 3119136 high water mark (pages) = 5...