CA Tech Tip from Karina Pulinx, Principal Support Engineer, for May 31,2016 .
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’ .
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 that should have been
–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 now 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 must
use to avoid this problem after the upgrade .