commit point 中文意思是什麼
commit point
解釋
決定點-
Traditional transaction systems use a two - phase commit approach - all of the participating resources are gathered and locked until the entire transaction can take place, at which point, the resources are finally released
傳統的事務處理系統使用兩階段提交方式，所有參與的資源都被集中起來，並在整個事務發生之前鎖定，等到事務發生后，資源被最後釋放。 -
To roll back the transaction and restore values to the last commit point before the attempted updates
回滾事務，並恢復最近的提交值（在嘗試更新之前） 。 -
If a table is dropped, its segments become immediately available for reuse at the commit point, without requiring the reorg utility to be executed
如果一個表被刪除，在執行commit之際，它的段就立即可以為其他表所用，而不需要執行reorg實用程序。 -
If all rows in a table are deleted known as a mass delete, all segments become immediately available for reuse at the commit point, without requiring the reorg utility to be executed
如果一個表中的所有行都被刪除（即mass delete ） ，則在執行commit之際，該表所有的段就立即可以為其他表所用，而不需要執行reorg實用程序。
分享友人