Meaning of New columns and table in the PTDB database For CA DB2 tools

Products

• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Clarify the meaning of “New columns and tables in the PTDB database may not be backward compatible if migrated from Db2 11 to Db2 12”, provide details on what impact this could have on your products should this happen, and what actions need to be taken to address these issues.

 

Environment

Release : 20.0

Component : Detector for DB2 for z/OS

Resolution

When you upgrade from Db2 11 to Db2 12 there are steps that you need to do listed under Upgrade to New Db2 Releases and Function Levels

step 5 is Regenerate and execute the following Db2 catalog customization tasks:
Compare DB2 objects.
Create required DB2 objects.

During these steps, we create new objects(tables, new columns specific to Db2 12). So if you fall back from V12 to V11 the new objects specific to v12 are not backward compatible meaning they're not compatible with V11 because they're specific to V12.