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]