on 06-02-2011 1:05 PM
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]
Hi,
It looks like the problem with you db2 client driver. What is the version of your database and client ?
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.