Articles & Content

Archives

E09 - Synthetic DB2 for z/OS Statistics

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2016



EXPLAIN is one of the most valuable tools for performance analysis. Like the DB2 internal SQL optimization it's also based on statistics. For new DB2 applications and those with changing data characteristics, however, there is a lack of appropriate statistics. The presentation desribes an approach how to create them synthetically for DB2 for z/OS (without the need of complex data generation) using extended data models.



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.