UPDATE RATE field
The value of the UPDATE RATE field specifies the estimated average number of inserts, updates, and deletes that are expected per hour in your subsystem.
| Acceptable values: | 1–16,777,216 |
|---|---|
| Default: | 3600 |
| Update: | cannot change during update |
| DSNZPxxx: | none |
You can use K (as in 32K) for multiples of 1024 bytes and M (as in 16M) for multiples of 1,048,576 bytes.
The size calculations in the DSNTINST CLIST assume that about 400 bytes of data are logged for each insert, update, and delete. The amount of data that is logged for these changes might be different at your site. Therefore, consider changing the size of the log data sets after you gain some experience with Db2 and have a better idea of how many bytes of data are logged for each change. Generally, if you have a subsystem that is tuned for maximum efficiency, you can expect to log about 10 GB of data per hour while processing several millions of updates and inserts.
Together, the UPDATE RATE and the ARCHIVE LOG FREQ (field 3) determine the size of the active logs.