Cross Platform DB2 for z/OS & LUW

E09 - Synthetic DB2 for z/OS Statistics 

Oct 06, 2016 03:43 AM

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.

Attachment(s)
pptx file
IDUG EMEA 2016 Presentation - Synthetic DB2 for zOS Stati...pptx   5.40 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.