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