UR LOG WRITE CHECK field (URLGWTH subsystem parameter)
Unless this option is disabled, DB2® issues a warning message to the console after log records are written by an uncommitted unit of recovery (UR). The URLGWTH subsystem parameter specifies the number of log records that are to be written before DB2 issues a warning message.
Acceptable values: | 0 to 1000K |
Default: | 10K |
Update: | option 28 on panel DSNTIPB |
DSNZPxxx: | DSN6SYSP URLGWTH |
The purpose of this option is to provide notification of a long-running UR. Long-running URs might result in a lengthy DB2 restart or a lengthy recovery situation for critical tables. Specify the value in 1 K (1000 log records) increments. A value of 0 indicates that no write check is to be performed.