UR CHECK FREQ field (URCHKTH subsystem parameter)
Unless the option is disabled, Db2 issues a warning message to the console for an uncommitted unit of recovery (UR) after a certain number of checkpoint cycles. The URCHKTH subsystem parameter specifies the number of checkpoint cycles that are to complete before Db2 issues the warning message.
| Acceptable values: | 0–255 |
|---|---|
| Default: | 5 |
| Update: | option 42 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP URCHKTH |
This option does not affect performance. If you use this option, specify a value that is based on how often a checkpoint occurs in your system and how much time you can allow for a restart or shutdown. For example, if your site's checkpoint interval is 5 minutes and the standard limit for issuing commits with units of recovery is 20 minutes, divide 20 by 5 to determine the best value for your system.