data reorganizing 资料整编
You might want to rename standard dbspaces if you are reorganizing data in an existing dbspace and see a need to change the dbspace name.
如果要在现有的 dbspace 中重新组织数据,或者认为有必要修改 dbspace 名称,那么可能需要重命名标准 dbspace。
PCTFREE indicates to DB2 what percentage of each page in the table space or index to leave free when either loading or reorganizing the data.
PCTFREE 告诉 DB2 在装载或重组数据时,表空间或索引中的每个页要留出多少百分比的空余空间。
In typical warehouse environments, recent data changes frequently while historical data is more or less static and this makes partition level reorg invaluable for reorganizing only the active data.
在典型的数据仓库环境中,最新的数据变化频繁,而历史数据变化相对较小,这使得分区级别的REORG对于针对活动数据的重组尤为重要。
应用推荐