ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Do you Need to recreate Archive Tables when upgrading


Article ID: 105813


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS


When upgrading from one release to another, do you have to recreate the Insight archive DB2 tables?



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.