2630088 - SQL0551N "REPLACE VIEW" for replace_HEXTORAW.sql SAP note #2465138

• Install Db2 fixpack of DB2 v10.5 or DB2 v11.1 with SAP Basis 750 -752 and run post update script ./db6_update_db.sh -d <SID>
• The db6_update_db.log results in the following error
  ************************************************************
  * ERROR:
  * ERROR: At least 1 CDS view or table function using the built-in routine HEXTORAW was found.
  * ERROR: Urgently replace this function according to SAP Note 2465138.
  * ERROR: The list of affected CDS views/tablefunctions is found in the following files:
  * ERROR: - db6_update_db.log
  * ERROR: - db6_update_db_out.log
  * ERROR: Look for labels "HEXTORAW occurence(s) in cds [views|functions]"
  * ERROR: In addition it is recommended to apply SAP Note 2511399 for CDS performance optimization.
  * ERROR:
• The SAP note 2465138 includes the script replace_HEXTORAW.sql as an attachment
• When running this script, you may hit the following error
  SQL0551N  The statement failed because the authorization ID does not have the
  required authorization or privilege to perform the operation.  Authorization
  ID: "DB2<SID>".  Operation: "REPLACE VIEW". Object: "SAP<SID>.DEMO_CDS_BINFUNC".

• An SQL statement that makes use of the SAP CDS function HEXTOBIN aborts with SQL0415N or SQL0171N.

Db2 LUW
SAP ERP 6.0
SAPK-750.....INSAPBASIS
SAPK-751.....INSAPBASIS 
SAPK-752.....INSAPBASIS

CDS, fixpack, update , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem