Do you Need to recreate Archive Tables when upgrading
Article ID: 105813
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem 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.