IBM zHyperLink: database synchronous read I/O exploitation
TimHogan 060000JKXP Comment (1) Visits (7906)
Db2 system administrators often spend time and effort tuning to maintain acceptable I/O latency for applications. However, hardware limitations sometimes cause unacceptable performance despite the Db2 system administrator's best efforts.
Even in a well-tuned environment, database I/O delays can cause application response times that exceed the requirements of service-level agreements, especially when the application requires random access to large databases.
In Db2 12 for z/OS we introduce support for performance improvements derived from IBM zHyperLink read support. The zHyperLink technology is the result of a collaboration between Db2 for z/OS, the z/OS operating system, IBM Z processors, and IBM DS8880 hybrid storage. This collaboration can deliver extremely low latency I/O access for read-intensive Db2 for z/OS transaction processing.
You can control the level of Db2's exploitation of zHyperLink technology using the new ZHYPERLINK subsystem parameter. In addition, you can use new trace records to track Db2's use of the zHyperLink technology, as well as the results of zHyperLink requests.
Exploitation of zHyperLink support works best for objects that are in resp