Loudwater
Systems
Management


COLLECT buffer size in std job (1 MB) not adequate on SMF collects

Default buffer size causes frequent COMMITs, approx every 1000 recs. These increase elapsed time and resource use significantly.

(DEFAULT is 1 MB! 4 MB gets COMMITs down to 4/5 per COLLECT of 20K recs)
(20K records roughly equals 12 min elapsed and 4 CPU mins @ 6 MB buffer)

*** Later *** [Client] SMF collects are now asking for 60 MB buffers, and need it!

NB Time of day affects how much memory is available and therefore how much BUFFER you actually get, and therefore the number of COMMITS, and therefore run time for a Collect job. They go much faster out of office hours!