topic Re: Commit work for clearing the buffer in Application Development and Automation Discussions

Commit work for clearing the buffer

former_member599326 — Thu, 03 Mar 2022 06:02:23 GMT

Hi,

I came across a program which uses commit work for clearing the buffer. Program is reading archived file because of which DB update buffer becoming too big resulting in system performance slowdown.

My understanding was that commit work is used to commit the database changes.

Is it the correct usage of "commit work" for clearing the buffer ?

Regards,

Re: Commit work for clearing the buffer

FredericGirod — Thu, 03 Mar 2022 06:34:24 GMT

What I already seen, is people using commit work to reset the timeout counter. But, I don't understand the link with buffer

Re: Commit work for clearing the buffer

former_member599326 — Thu, 03 Mar 2022 06:52:40 GMT

commit work is used for 2 purpose :-

1) FM "ARCHIVE_READ_OBJECT" posts a message (Job log) for every archived file read that DB update buffer can become too big resulting in system performance slowdown.

2) performance or memory issues

Re: Commit work for clearing the buffer

Sandra_Rossi — Thu, 03 Mar 2022 07:07:37 GMT

Which one of the buffers are you talking about? Difficult to discuss if you don't clarify 😉

Are you confusing BAPI_TRANSACTION_COMMIT and COMMIT WORK?

Re: Commit work for clearing the buffer

former_member599326 — Thu, 03 Mar 2022 07:08:27 GMT

DB Update Buffer

Re: Commit work for clearing the buffer

former_member599326 — Thu, 03 Mar 2022 07:09:47 GMT

my query is whether commit work is used to commit the database changes only or it is used to clear DB update Buffer also?

Re: Commit work for clearing the buffer

former_member599326 — Thu, 03 Mar 2022 07:10:33 GMT

is it possible that DB update buffer gets full while archiving the data e.g. accounting documents ?

Re: Commit work for clearing the buffer

Sandra_Rossi — Thu, 03 Mar 2022 07:20:05 GMT

Your question is too much general, I don't understand what you are talking about. Please describe the exact symptoms, stop "beating around the bush" (Google translation of French "tourner autour du pot").