Question & Answer
Question
A batch program with very frequent updates and commits in a local table is accessing a table in a remote DB2 by using inactive threads. This process generates a large number of accounting records in the remote DB2 (about 1 accounting record per commit). What can I do to reduce the accounting records?
Answer
You can use the DDF/RRSAF ACCUM field (ACCUMACC) and AGGREGATION FIELDS field (ACCUMUID) subsystem parameters, to roll up the accounting records that match a certain workstation, client, user, and application name. You choose which items you want to match. You can tell DB2 to create an accounting record only when X number of occurrences match the criteria that you specify.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21181504