Understanding Hold data for IDB2 PTF SO14093 after Apply

book

Article ID: 199809

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

PTF SO14093 hold data says to Re-Execute the DB2 Tools Post Install dialog and run the Archive Table Migration Utility. 
Unfortunately the Table Migration Utility does not appear to be an option off of the DB2 Tools Post Install dialog.

This batch job appears to delete existing datasets before recreating them and then running the NSIGMIGA program.
What to do?

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

'Unfortunately the Table Migration Utility does not appear to be an option off of the DB2 Tools Post Install dialog.' In the DB2 tools Post Install dialog  'Installation option: 1' for Migration, which generates NSIGMIGA utility is what was meant by Table Migration Utility.

The reason for running Post-Install is not just creating new ARCDDL, IQL and LOAD control statements which isn't needed for Archive Table update but it also updates ARCFLDLS, which is SUBSTANTIAL for migration utility. So these steps need to be followed:

1. Execute the Post-Install to get new SOURCE library. The previous SOURCE library should be in a different data set, because the SOURCE library is always deleted and created again.
2. Execute the NSIGMIGA utility with ARCFLDLS and ARCMIGSY from new SOURCE library and with original IQL and LOAD control members (not new ones!!).
3. The Migration utility will create ALTER statements for archive tables update
4. Migration utility will update also original IQL and LOAD members to new ones.