About compare function for PLANs between different DB2 levels

Document ID : KB000123473
Last Modified Date : 21/12/2018
Show Technical Document Details
Question:
I'm using Plan Analyzer R15.0 and DB2 V9 at present and already got the EXPLAIN(CURRENT) data of their all PLANs. How I should do to compare the EXPLAIN info in the DB2 V9 with the EXLPAIN info in the DB2 V12?
Environment:
Between different DB2 levels. 
Answer:
When you do the current explain for your DB2V9 plans and turn on the historical data options, the data are saved in the R15 PPADB2 historical data tables.
When you upgrade from R15 to R19, the data should be transferred from R15 to R19 tables. (It should be transrated in the Post-Installation process at the upgrade.)
When you do the FUTURE Explain for DB2V12 in R19, the data should be there for the comparison.