How to migrate old log table records when upgrading to release r15 or higher.

Document ID : KB000019540
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Upon upgrading the CA 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 CA Batch Processor for DB2 for z/OS, CA Database Analyzer for DB2 for z/OS, CA RC/Secure for DB2 for z/OS, and CA RC/Update for DB2 for z/OS.

Solution:

CA Batch Processor, CA Database Analyzer for DB2, CA RC/Update, and CA RC/Secure 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.