Data Maintenance Process
The data maintenance process starts with the RUNSTATS utility. After performing RUNSTATS, a DBA can analyze the statistics to determine if a REORG is necessary or the REORG utility can review the statistics collected, and use the REORG triggers to determine if a REORG is needed.
If reorganization is needed, use the REORG utility on the selected objects and then do RUNSTATS and REBIND. You must perform a REBIND on any packages affected by the above operations, so they can take advantage of the benefits of the new physical organization and updated statistics. After performing subsequent update, insert, and delete operations, as part of the data maintenance process, repeat by first executing the RUNSTATS utility.
Establish ...
Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
