topic DBIF_RSQL_SQL_ERROR in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR

Former Member — Mon, 05 Jan 2009 14:44:28 GMT

Hi All.

I am working on a program...when we run this program as a job it runs for sometime and then it gets cancel and when I went to st22 i saw the short dump with this message DBIF_RSQL_SQL_ERROR and when I talk to my basis team they said that the problem is our jobs are not getting commited in time and The active log is full and is held by application handle. So can you please tell me how can i take care of this.

Thanks,

Rajeev

Re: DBIF_RSQL_SQL_ERROR

former_member191735 — Mon, 05 Jan 2009 15:43:18 GMT

Search for OSS notes using the error analysis. The desc you specified here will address to many reasons. I want you to go through the OSS notes first.

Re: DBIF_RSQL_SQL_ERROR

PedroGuarita — Mon, 05 Jan 2009 16:12:58 GMT

You can use a counter and after x records do the commit yourself, something like :


count = 0.
loop at int_tab.
  count = count + 1.
  update dbtab set field = 1.
  if count > 500.
    commit work.
    count = 0.
  endif.

endloop.

Re: DBIF_RSQL_SQL_ERROR

Former Member — Mon, 05 Jan 2009 16:34:34 GMT

Rajeev,

Can you please post more details like part of the dump, at what point it give this dump ? The other solution if it is related to select statement from tables etc , is go for the index, change select statement etc.