With these challenges in mind, QuickSelect for Db2 performance was developed to provide immediate and risk-free Db2 application and batch job performance improvements and cost savings. It operates transparently, concentrating exclusively on HOW the data is used, rather than on what the application does. Best of all, it installs dynamically and requires zero changes to existing systems.

Excessive CPU and execution time are consumed by SQL retrieving the same result sets over and over from reference/code/lookup and other slow-to-change tables. When the result sets are stored in and served from high performance cache outside Db2, online and batch performance gains are dramatic and mainframe CPU resource is saved. In comparison, a round trip to Db2 is slow and expensive, even when the requested data is already in a Db2 buffer pool!

QuickSelect for Db2 is a plug-and-play ‘software appliance’ that benefits both Batch and Online environments (CICS and IMS/TM). It determines when a given static SQL statement is repetitively requesting the same result set, caches that result set in high-performance, above-the-bar main memory, and each time the statement executes, returns the same answer from Cache as would Db2, but much faster and at a much lower cost. As a result, online performance improves and batch jobs run faster. Db2, CICS and IMS/TM resource is freed up for other work. SQL requests serviced from QuickSelect Cache see performance gains of 3-5x when compared to the same data retrieved from Db2 buffer pools!

QuickSelect always returns the same answer and/or behaves exactly as DB2 would – it is transparent to the rest of the system. It can be switched on or off, is not embedded in your systems, is completely transparent to applications, and ensures complete data integrity of cached result sets with respect to the contents of the underlying Db2 tables.