Do you Need to recreate Archive Tables when upgrading

book

Article ID: 105813

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector 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.