Db2 for z/OS and its ecosystem

 View Only

Db2 Analytics Accelerator for z/OS, Table Statistics and Query Performance

By Cj Chang posted 15 days ago

This blog highlights two technotes for Db2 Analytics Accelerator for z/OS related to query performance. 

Table Statistics and IBM Db2 Analytics Accelerator for z/OS https://www.ibm.com/support/pages/node/6621329

            This technote describes the various features in the accelerator related to table statistics collection, which is a key element component in determining the best query access plan.


Query Performance Diagnosis and IBM Db2 Analytics Accelerator for z/OS https://www.ibm.com/support/pages/node/6621333 

           This technote provides useful tips on how to identify slow running queries and how to collect diagnostic information about the queries for investigation by IBM support.

For any questions or comments please reach out to CJ Chang chihchan@us.ibm.com or Ute Baumbach bmb@de.ibm.com