DSXchange

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??

The commit interval is time based as opposed to number-of-rows based.

Not really a 'general' question...

@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...