Error log related to SQL statement

[Former Member]

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.

[former_member188883]

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