How to migrate old log table records when upgrading to release Database Management for Db2 for z/OS r15 or higher

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• Batch Processor
• Batch Processor
• RC/Secure for DB2 for z/OS
• RC/Update for DB2 for z/OS
• Database Analyzer for DB2 for z/OS

Issue/Introduction

Upon upgrading the Database Management Solutions for Db2 for z/OS to r15 or higher, old log table records from a release prior to r15 will no longer be available.
This affects log data for Batch Processor for DB2 for z/OS (RBP), Database Analyzer for Db2 for z/OS (PDA), RC/Secure for Db2 for z/OS (RCS), and RC/Update for Db2 for z/OS (RCU).

Resolution

Batch Processor for Db2, Database Analyzer for Db2, RC/Update for Db2, and RC/Secure for Db2 all log user activity which is stored in Db2 table PTI.PTLOG_MAIN_#.
As of r15, this table has been renamed from PTI.PTLOG_MAIN_0102 to PTI.PTLOG_MAIN_1500. Any log data in the 0102 table will no longer be available to any
subsystems that have upgraded to r15 or higher.

To maintain the old data and make it available in the upgraded release, the data can be migrated to the current release using an optional step included in the Post Installation task, 'Compare DB2 Objects'. In the JCL generated for the ssid0000 Post Install task, the optional step contains the SQL to migrate the log data from the old table, PTI.PTLOG_MAIN_0102 to the new table, PTI.PTLOG_MAIN_1500.

//*-------------------------------------------------------------------
//* INSERT OLD LOG RECORD INTO NEW LOG TABLE  OPTIONAL !!!!!!!!
//*
//* THIS STEP WILL INSERT LOG RECORDS FROM OLD LOG TABLE INTO NEW
//* LOG TABLE.
//*-------------------------------------------------------------------

Execute the SQL to insert the old log data into the current release.