Required packages not bound in the Bind Product Package and Plans

book

Article ID: 241113

calendar_today

Updated On:

Products

DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Applied PTFs to CA-DB2 products to upgrade DB2 function level to V12R1M503 from V12R1M100.

After Post-Install, CATALOG REPORTING except PLANs in Plan Analyzer, SQLCODE = -805 occurs for the PZA#PACK and PPA$ODDR packages.
Checked PZA#PACK and PPA$ODDR packages in the ”Bind Product Packages and Plans” joblog, but they are not selected.  

Environment

Release : 20.0

Component : DB2 Common Components

Resolution

The definition of the ISPF table contains the column names in lower-case. They are not properly converted to upper-case.

INSIBIND_FIX, PTF LU06081, which has the column names in upper-case was sent.