Check for Reorganization

Use

You can use the jobs Update Statistics + Reorgcheck all tables and Update Statistics + Reorgcheck (DBSTATC) to check whether tables need to be reorganized. The jobs begin by updating the database statistics and then check whether tables need to be reorganized. For more information, see the topics Scheduling Update Statistics + Reorgcheck (DBSTATC) – DB2/CS and Scheduling Upd. Statistics + Reorgcheck All Tables – DB2/CS in the BC Computing Center Management System documentation.