Copy History files from Release 19.0 to 20.0

book

Article ID: 196599

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite CA Database Management for DB2 for z/OS - SQL Performance Suite CA Detector for DB2 for z/OS CA-Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

We have created new **.EXCPDEF Exception file and **.HSTACCTG, **.HSTSTATS  History files for CA SYSVIEW for DB2 Release 20.0 and Release 19.0 Exception / History files we kept as such. 

After bring up CA SYSVIEW for DB2 Release 20.0 Data Collector started task and when we tried to view the Thread History in CA SYSVIEW for DB2, we could see the threads which were active after we start the Data Collector in Release 20.0, is there any possibility to display the threads which were active before Data Collector Release 20.0 was started?. 

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

In Release 20.0 you can work with same **.EXCPDEF Exceptions file as in Release 19.0. 

Release 19.0 History files are compatible with Release 20.0, so the following steps to merge data sets with IDCAMS utility should work.  
  
For the History files they can be merged in the following way. 
 
. Create a new History file for Release 20.0: R200.NEW.HSTACCTG, R200.NEW..HSTSTATS 
. Copy with IDCAMS REPRO the Release 19.0 History files R190.HSTACCTG, R190.HSTSTATS to the new History files R200.NEW.HSTACCTG, R200.NEW.HSTSTATS 
. Copy with IDCAMS REPRO the current Release 20.9 History files **.HSTACCTG, **.HSTSTATS to the new History files R200.NEW.HSTACCTG, R200.NEW.HSTSTATS 
  
On this way there will be all the Release 19.0 and Release 20.0 IFCID records merged in one set of Release 20.0 History files: R200.NEW.HSTACCTG, R200.NEW.HSTSTATS 
  
Start the CA SYSVIEW for DB2 Release 20.0 Data Collector with the new R200.NEW.HSTACCTG, R200.NEW.HSTSTATS History files.