Do you Need to recreate Archive Tables when upgrading
Article ID: 105813
CA Bind Analyzer for DB2 for z/OSCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
When upgrading from one release to another, do you have to recreate the Insight archive DB2 tables?
Release: Component: CIDB
It all depends. If there are significant changes like these that were implemented in R20 New Archive tables Now store DB2 audit records IDB2 accounting records Information about executed SQL statements. Then it will make sense to recreate the objects otherwise, there is no need.