Migration from R18 to R19

Document ID : KB000074455
Last Modified Date : 05/04/2018
Show Technical Document Details
Introduction:
Migrating Sysview for DB2 from R18 to R19 and the DBAs are looking for the documentation for changes to the tablespaces/tables/indexes
Question:
I am migrating Sysview for DB2 from R18 to R19 and the DBAs are looking for the documentation for changes to the tablespaces/tables/indexes that are used for extracting accounting and statistical data. For example: INSIGHT.APPLICATION_DETAIL
Environment:
Z/OS DB2
Answer:
We do not specifically have any documentation that directly lists the changes between R18 and R19 re the Archive tables and their changes. 

What we do have in our Docops documentation is 
1) The tables affected 
here is a link to enhancements 
https://docops.ca.com/ca-sysview-db2/19/en/product-information/enhancements. 

2) New fields are documented within SOURCE(ARCFLDLS) member here is a link covering that https://docops.ca.com/ca-sysview-db2/19/en/configuring/archiving-component/archiving-component-members 

3) ARCFLDS also in the source library is used for archive table migration - https://docops.ca.com/ca-sysview-db2/19/en/configuring/utilities/archive-table-migration-utility-nsigmiga 

Here is a link for that. 
ARCFLDS is used to generate ALTERs and IQL/LOAD statement changes to bring your old archive tables upto date with R19.