Do you Need to recreate Archive Tables when upgrading

Article Id: 105813

Status: Published

Updated On: 13-07-2018 14:57

Products:

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem 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.