Articles & Content

Archives

B12 - REORG Automation with Real Time Statistics

Topic: DB2 for z/OS

Subtopic: 2015



Use DB2 real time statistics to quickly and efficiently identify disorganized tablespaces and indexspaces.
Write a view to join together all information required to determine if it's necessary to dispatch a REORG.
Query this view to generate REORG SYSIN.
Dispatch online REORG utility jobs as required.
Monitor and tune the performance of your automated REORG system.
Identify and manage tablespaces with exceptional processing requirements.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.