STATISTICS SYNC field (SYNCVAL subsystem parameter)
The SYNCVAL subsystem parameter specifies whether to synchronize recording of the Db2 statistics trace records that the STATIME subsystem parameter controls with a specific part of the hour, such as 15 minutes past the hour.
| Acceptable values: | NO, 0–59 |
|---|---|
| Default: | NO |
| Update: | option 23 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP SYNCVAL |
- NO
- Specifies that statistics recording is not synchronized. NO is the default.
- 0–59
- Db2 statistics recording interval is synchronized with the beginning of the hour (0 minutes past the hour) or with any number of minutes past the hour up to 59, for the following IFCIDs:
- 105 (Db2 performance trace)
- 106 (system parameters)
- 199 (data set statistics)
- 402 (monitor profile warnings or exceptions)
Example
You want the Db2 statistics recording interval to have a length of 15 minutes and to be synchronized with 15 minutes past the hour. Thus, Db2 statistics are recorded at 15, 30, 45, and 60 minutes past the hour. To establish this interval, you would specify the following:
STATIME=15
SYNCVAL=15