Do you need to recreate Sysview for DB2 Archive Tables when upgrading
search cancel

Do you need to recreate Sysview for DB2 Archive Tables when upgrading

book

Article ID: 105813

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

When upgrading from one Sysview Performance Management Option for Db2 for z/OS (IDB2) release to another,
is there are requirement to recreate the IDB2 archive Db2 tables?

Resolution

If there are significant changes like these that were implemented in IDB2 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.