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 .