SQL0440N No authorized routine named "DISK_INFO"

[Former Member]

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

[Former Member]

Hello,

Try and update the kernel to the latest patch (150) and dbsl library patch as well.

Also update the db6pmudf patch 19. Please go through the following notes and related notes as well.

Note 334777 - DB6: Missing user-defined functions

Note 978319 - DB6: Incorrectly cataloged table functions

Note 921488 - DB6: db6pmudf - latest patch (currently 19)

Note 1124987 - DB6: Availability of administration functions

And what is the version and patch level of DB2 ?

Thanks

[Former Member]

Hi, Thanks for reply.

I have read all the SAP notes mentioned above..

Only option I can try is probably upgrade my kernel to latest one.

DB2 database level is 9.1 FP 7

[Frank-Martin]

Hi,

I do not believe this is a kernel related problem. The SAPTOOLS functions may not have been initialized correctly. Try

db2 invoke db2sap

as db2 instance owner.

Regards

Frank

[Former Member]

Hi Frank.

I have tried the command at the time of posting the thread...

Since the errors were generated every hour due to standard background job scheduled. Till now th error have not occured.

Let see I will be monitoring for today...

just wanted to know if there could be any other cause.

Thanks,

Sagar