Do you Need to recreate Archive Tables when upgrading
book
Article ID: 105813
calendar_today
Updated On:
Products
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
Issue/Introduction
When upgrading from one release to another, do you have to recreate the Insight archive DB2 tables?
Environment
Release: Component: CIDB
Resolution
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.