Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

ADM12008C The product "DB2 Enterprise Server Edition" does not have a vali

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]

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question