cancel
Showing results for 
Search instead for 
Did you mean: 

SQL0440N No authorized routine named "DB_GET_CFG" of type "FUNCTION" havin

Former Member
0 Kudos

Hi all, With reference to the following thread i was trouble shooting my sap system , I nitially i had a licensing issue on DB2 and now issue got resolved and DB is succesfully up and running

But when i try to start application i was hit with the below error , i have pasted dev_w0 log and infact R3trans -d also returns the same error lines

I couldn't understand why DB collation went wromg suddenly, Please share any inputs

C Database code page is ok.

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

C &+ DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0440N No authorized routine named "DB_GET_CF

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

C &+

C &+ SELECT COUNT() FROM TABLE( DB_GET_CFG() ) AS X WHERE DBPARTITIONNUM = CURRENT DBPARTITIONNUM AND NAME = 'db_colln*

C &+ ame' AND VALUE = 'IDENTITY_16BIT'

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

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

C Could not check DB2 collating sequence.

C Disconnected from 'GPE'

C Disconnected: con_hdl=0 ; appl_hdl=58; appl_id="fe80::f56e:eac2:d444:37ea%13.49251.110502113701"

C Environment Handle has been released. sql_rc=0

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1505]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10651]

M

M Info for wp 0

M

M pid = 1584

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server GDIDES_GPE_00 on host GDIDES (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Mon May 02 17:07:01 2011

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10916

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 1584) [dpnttool.c 334]

Accepted Solutions (0)

Answers (1)

Answers (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

It looks like the problem with you db2 client driver. What is the version of your database and client ?

Thanks

Sunny

Former Member
0 Kudos

Hi sunny,

db version - DB2/LUW:V9.7 FP3:RDBMS:DB2/LUW:D51040240

db client - DB2/LUW:V9.7 FP3:CLI/JDBC-DRIVER:DB2/LUW:CD51040241

O/S WIN 2008 R2..

Thanks,

Rahul

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I don't believe that's a client problem. Try the statement

db2 " SELECT COUNT(*) FROM TABLE( DB_GET_CFG() ) AS X WHERE DBPARTITIONNUM = CURRENT DBPARTITIONNUM AND NAME = 'db_collname' AND VALUE = 'IDENTITY_16BIT' "

from DB2 CLP as user db2sid . If this works as db2sid the SAP ABAP connect user may not be authorisid to execute the procedure. To check this use DB2 CLP to connect to the database using the ABAP connect user and rerun the same statement. If the command fails with SQL0440 as the connect user you can grant the autority on table function DB_GET_CFG explicitly to this user. It would determine more analysis to find out how the authority got lost.

Regards

Frank

Former Member
0 Kudos

Hi all,

I have got aand did run export file of 1 day old. I have used that a run a export on to target system and resolved the issue.

Thanks a lot,

Rahul