SQL0440N No authorized routine named "DISK_INFO"

507 Views

Hello All,

In the SM21 logs, following error messages are getting generated

Database error -440 at OPC

SQL0440N No authorized routine named "DISK_INFO" of type

"FUNCTION" having compatible arguments was found.

SQLSTATE=42884

when checked the logs... its due to standard Background job SAP_CCMS_MONI_BATCH_DP which executes program RSAL_BATCH_TOOL_DISPATCHING

The log of the background process is as below:

********************************************************************************************

ERROR in prepareStatement[dbdb6.c, 13630] CON = 0 (BEGIN)

C &+ dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/NT64] SQL0440N No authorized routine named "DISK_INFO"

C &+ of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

C &+

C &+ SELECT SUBSTR(REPLACE(REPLACE(SUBSTR(VARCHAR(CURRENT TIMESTAMP),1,19),'.',''),'-',''),1,14),0 as DB6PMCF_PARTITION

C &+ ,' ','U','20110420192320','701',0.0,0.0,0.0,0.0,0 FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DISK_INFO(LTRIM(CAST( ? AS

C &+ VARCHAR(255))))) AS FS_CONFIG

C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

C &+ ABAP location info: 'CL_SQL_STATEMENT==============CP', 383

C &+

C &+ ABAP location info 'CL_SQL_STATEMENT==============CP', 383

C &+

C *** ERROR in prepareStatement[dbdb6.c, 13630] (END)

B ***LOG BY2=> sql error -440 performing OPC [dbds#2 @ 486] [dbds 0486 ]

B ***LOG BY0=> SQL0440N No authorized routine named "DISK_INFO" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884 [dbds#2 @ 486] [dbds 0486 ]

B ***LOG BY1=> sql error -440 [dbacds#2 @ 1433] [dbacds 1433 ]

*******************************************************************************************************

I have tried executing the db2 invoke db2sap command successfully.

The current version of db6pmudf is 18.

SAP kernel is 117. SAP ECC EHP4 system.

Any ideas what could be the issue...

Thanks

Sagar