Getting SQLCODE = -9 running an SQL SELECT ENCRYPTION_TYPE , ENCRYPTION_METHOD FROM SYSADM.AGGREGATE

Products

• Datacom
• DATACOM - AD

Issue/Introduction

Problem: 

After upgrade from CA Datacom 12.0 to 14.0  SQL statement SELECT ENCRYPTION_TYPE , ENCRYPTION_METHOD FROM SYSADM.AGGREGATE

fails with SQLCODE -9   ‘ILLEGAL COLUMN NAME’  .

Environment:  

z/OS

Cause: 

These columns ,ENCRYPTION_TYPE and ENCRYPTION _METHOD, have been added  during the upgrade from 12.0 to 14.0 in INSTJCL(BDUPG07) .

In BDUPG07 DDCFBLD –HSD RESET has been executed but no DDCFBLD –CXX BUILD,DATA-DICT(PROD,DD,PRIV)

which is required to update the DDD-TABLE in DBID 15 with the new SQL column names information .

Resolution:

Run DDCFBLD using SYSIN cards :  

-USR DATACOM-INSTALL,NEWUSER

–CXX BUILD,DATA-DICT(PROD,DD,PRIV)

Additional Information:  

CA Datacom R&D will deliver a new modified BDUPG07 member that sites that still need to upgrade to CA Datacom version 14.0

need to use to avoid this problem after the upgrade .

Environment

Release: DATABB00200-14-Datacom/AD
Component: