error in program RSAL_BATCH_TOOL_DISPATCHING (job SAP_CCMS_MONI_BATCH_DP)

[Former Member]

Hi All,

After successfull upgrade in Support pack level 17, I am getting an error message in with a standard job SAP_CCMS_MONI_BATCH_DP. I am getting the following error messages in SM21.

Database error -440 at OPC

> SQL0440N No authorized routine named "DB6PMCF" of type

> "FUNCTION" having compatible arguments was found.

> SQLSTATE=42884

Database error -440

Database error -440 at OPC

> SQL0440N No authorized routine named "DB6PMCF" of type

> "FUNCTION" having compatible arguments was found.

> SQLSTATE=42884

Database error -440

Database error -440 at OPC

> SQL0440N No authorized routine named "DB6PMCF" of type

> "FUNCTION" having compatible arguments was found.

> SQLSTATE=42884

Database error -440

Database error -440 at OPC

> SQL0440N No authorized routine named "DB6PMCF" of type

> "FUNCTION" having compatible arguments was found.

> SQLSTATE=42884

Even after checking the error in details I found the program "RSAL_BATCH_TOOL_DISPATCHING" causing the error message. In details the error message says :

Job started

Step 001 started (program RSAL_BATCH_TOOL_DISPATCHING, variant , user ID

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: <SID>

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20091109062730',0 as DB6PMCF_PARTITION,' ','T

: ','20091106055752','700',0.0,0.0,0.0,0.0,0 FROMSYSIBM.SYSDUMMY1, TABL

: E(SAPTOOLS.DB6PMCF('/db2/SID/log_dir/') ) AS FS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 440-

: SQL Message: SQL0440N No authorized routine named "DB6PMCF" of typ

: e "FUNCTION" having compatible arguments was found. SQLSTATE=42884

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Did anybody encountered with any situstion like this...Would appreciate any early response.

DID CHECK WITH KERNEL FILES, LOOKS GOOD FOR ME. ALSO CHECKED WITH note 978319 ..

Thanks in Advance

[Former Member]

Are we sure that we have applied 978319 completely ?

If not resolved, then applying the latest fixpack might get us to the resolution. What is the current DB2 level (db2level) ?

[Former Member]

I have not yet tried to apply the note 978319.

Current DB LEVEL is as follows..

DB client lib. DB6_81

DB releases DB6 08.02.*, DB6 0

DBSL version 700.08

DBSL Patch Level 171