on 07-23-2014 5:53 AM
Hi SCNites,
In sm21 there is a particular log related to SQL statement, ( error in preparedstatement ). based on this log, i checked the relavent Wp and found these statements.
C Tue Jul 22 01:40:46 2014
C *** ERROR in prepareStatement[dbdb6.c, 15027] CON = 0 (BEGIN)
C &+ dsql_db6_exec( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPSID.DB2CLINETSTATS" is an undefined
C &+ name. SQLSTATE=42704
C &+
C &+ DELETE FROM DB2CLINETSTATS WHERE intervalend < current timestamp - 7 days
C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=8, read_only=0
C &+ ABAP location info: 'CL_SQL_STATEMENT==============CP', 975
C &+
C &+ ABAP location info 'CL_SQL_STATEMENT==============CP', 975
C &+
C *** ERROR in prepareStatement[dbdb6.c, 15027] (END) ".
Could some tell me where exactly the error is triggering and how to troubleshoot this.
Thanks in Advance
Rgds,
vamc.
Hi Vamsi,
Please have a look into solution described in SAP note
Note 1706054 - DB6: Collector error SQL0204N SAPTOOLS.DBH_CURR_HOSTNAME
Note 1554750 - DB6: SQL0204N when accessing a view over an existing table
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.