Question & Answer
Question
The details provided in the document assist DBAs in reviewing the history of statistics execution on the database.
It is useful to review the details while investigating performance concerns related to ELM.
Answer
For Oracle database, there is an option to view the history of statistics collection on the database tables by using ALL_TAB_STATS_HISTORY. For more information, see the following document:
Similarly, the same details can be gathered for Db2 database by using the information provided in the following document:
https://www.ibm.com/support/pages/checking-last-time-runstats-was-run-against-database
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSPRJQ","label":"IBM Engineering Lifecycle Management Base"},"ARM Category":[{"code":"a8m0z000000CbOfAAK","label":"Jazz Team Server->Database"}],"ARM Case Number":"TS007464529","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
02 March 2022
UID
ibm16518924