TechTip:CA SQL - SQLCODE -9 ENCRYPTION_TYPE , ENCRYPTION_METHOD

Document created by KarinaPulinx Employee on May 31, 2016
Version 1Show Document
  • View in full screen mode

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 .

Attachments

    Outcomes