com.rocketsoft.nm.qm.reorg.MaxCollectionWindowLength
Use the com.rocketsoft.nm.qm.reorg.MaxCollectionWindowLength parameter in cqm.server.properties to control the smarter reorganization recommendation behavior of the CAE server.
- Description
-
When running reorganization recommendation, the MaxCollectionWindowLength parameter defines the maximum time period (in milliseconds) for which Db2 Query Monitor keeps data in a performance window. If MaxCollectionWindowLength is less than the INTERVAL length, Db2 Query Monitor will snap extra intervals to align with MaxCollectionWindowLength.
The purpose of the MaxCollectionWindowLength parameter is to ensure that the performance data you collect during reorganization recommendation does not consume too much space, especially if the performance window is larger than the Db2 Query Monitor INTERVAL parameter. By default, the maximum collection window length is 3600000 milliseconds (1 hour).
If you are not running reorganization recommendation, the MaxCollectionWindowLength parameter has no effect on Db2 Query Monitor intervals.
- Best practices for using MaxCollectionWindowLength
- We recommend that you set the MaxCollectionWindowLength parameter to be a whole integer multiple of the Db2 Query Monitor interval length (the interval length is defined in CQMPARMS using the INTERVAL parameter). For example, if your INTERVAL parameter is 2 hours, we recommend a MaxCollectionWindowLength setting of 7200000 (2 hours) or 14400000 (4 hours).
- Syntax
- com.rocketsoft.nm.qm.reorg.MaxCollectionWindowLength=time
- time
- The time in milliseconds. The default value, 3600000, corresponds to 1 hour.
- Default
- 3600000 milliseconds
- Example
- com.rocketsoft.nm.qm.reorg.MaxCollectionWindowLength=7200000