What is the difference between environmental variable $APT_RDBMS_COMMIT_ROWS and in DB2 enterprise stage ROW_COMMIT_INTERVAL parameter??
What I observed that only specifying ARRAY_SIZE in DB2 enterprise stage is enough when you want updates to commit at particular intervals.
Can anyone explain how these parameters work??
Commit
Moderators: chulett, rschirm, roy
The commit interval is time based as opposed to number-of-rows based.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
@ArndW: I don't think so. We specify no. of rows as the value for ROW_COMMIT_INTERVAL parameter. Another parameter TIME_COMMIT_INTERVAL is time based to which we assign value in seconds.
My doubt is:
ROW_COMMIT_INTERVAL takes value in multiples of ARRAY_SIZE, which is another parameter. But the commit instead of happening at value of ROW_COMMIT_INTERVAL happens at value of ARRAY_SIZE only. What's the point then in keeping the ROW_COMMIT_INTERVAL parameter.
@chulett: I was in hurry and had no idea where else to put it, so...
My doubt is:
ROW_COMMIT_INTERVAL takes value in multiples of ARRAY_SIZE, which is another parameter. But the commit instead of happening at value of ROW_COMMIT_INTERVAL happens at value of ARRAY_SIZE only. What's the point then in keeping the ROW_COMMIT_INTERVAL parameter.
@chulett: I was in hurry and had no idea where else to put it, so...