Ways to tune the castout thresholds

Several facilities can help you more efficiently monitor group buffer pool castout thresholds.

Use the following facilities to help you monitor the castout thresholds:
  • The DISPLAY GROUPBUFFERPOOL command with the MDETAIL option.
  • The Db2 statistics trace.
  • Begin program-specific programming interface information.IFCID 0262, which gives summary statistics for each time that the GBPOOLT threshold is reached. You can use this record to monitor how efficiently the GBPOOLT threshold is handling the castout work.
  • IFCID 0263, which gives summary statistics for the castouts done by the page set and partition castout owners. All castout work for a given page set or partition is done by the castout owner. You can use this record to monitor the efficiency with which the page set or partition castout owners are doing their work.End program-specific programming interface information.