3722218 - DB6: DBAcockpit EXPLAIN function error SQL0551N - Authorisation issue on "DROP FUNCTION" on "EXPLAIN_GET_MSGS" for USER <username>

In the DBAcockpit transaction overview, the EXPLAIN function does not work in either the SAP GUI or the Webdnypro following a database upgrade on a lower Basis level, example SAP Basis 701.

Exception CX_DB6_EXPLAIN in class CL_DB6_EXPLAIN_FACILITY method SETUP_FACILITY line 47 
      Kernel Error ID:       
      SYSID:      <SID>
      SY-SUBRC:      0  
      Reason: ADBC Error while setting up EXPLAIN facility 
      Database: 
 caused by 
 Exception CX_DBA_ADBC in class CL_DB6_EXPLAIN_FACILITY method DROP_EXPLAIN_FACILITY line 55 
      Kernel Error ID:       
      SYSID:      <SID>
      SY-SUBRC:      0  
      SQL statement: CALL SYSPROC.SYSINSTALLOBJECTS( ( SELECT 'EXPLAIN' FROM SYSIBM.SYSDUMMY1 ), 'D', CAST (NULL AS VARCHAR(128)), '<SCHEMA>' ) 
      Database: 
 caused by 
 Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT  
      Kernel Error ID:       
      DB Error:           Yes 
      SQL Code:           551- 
      SQL Message:      SQL0551N  The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.  Authorization ID: "<SCHEMA".  Operation: "DROP FUNCTION". Object: "<SCHEMA>.EXPLAIN_GET_MSGS".  SQLSTATE=42501 
      DB Object Exists:      No 
      Duplicated Key:      No 
      Internal Error:      1  
      Invalid Cursor:      No 
      Unknown Connection:      No  

Db2 LUW IBM

Performance, EXPLAIN, optimise, optimisation, long running SQL, Expensive Statement, SQL statement  , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem