InfoSphere Optim pureQuery Runtime for Linux, UNIX and Windows

InfoSphere Optim pureQuery Runtime for Linux, UNIX and Windows provides a high-performance data access platform focused on optimizing, securing and simplifying applications.

InfoSphere Optim pureQuery Runtime provides a runtime environment and an application programming interface (API) that not only enhances the performance of existing in-house database client applications written using Java or C, but also helps in rapid development and deployment of new applications.

• Increases database system throughput and reduces costs.
• Facilitates developer and DBA collaboration to improve the security, performance, and manageability of your Java or .NET applications.
• Simplifies the use of best practices for SQL and JDBC, improving application performance.
• Provides Nested Query Beans, a feature that eases development of application code which executes and handles results from an SQL statement with joins.
• In house testing shows pureQuery Static APIs doubled the throughput of the DB2 for Linux, UNIX and Windows database server in comparison to JDBC. In addition, compared to JDBC, pureQuery Client Optimization Static and pureQuery API Static (Method Style) increased the throughput of the DB2 for Linux, UNIX and Windows database server by 60 and 66% respectively.

Family overview

Products

View all additional offerings

• DB2 Advanced Recovery Solutions for Linux, UNIX and Windows Brochure
• Solution Roadmap for DBAs (103KB)
• Optim Solutions for Managing Performance Roadmap (127KB)
• Getting Started with pureQuery book
• InfoSphere Optim pureQuery Runtime Information Roadmap
• Information Roadmap to Optim Query Tuner for DB2 for Linux, UNIX and Windows

• Integrated Data Management: Managing data across its lifecycle
• dW article: Migration and change management