SAS solutions are renowned for their capabilities to access, transform and analyze data. IBM's DB2 database software is the worldwide market share leader in the database industry. When using SAS with DB2 in the complex business environments the goal is to leverage the capabilities of both products to achieve the best result. This paper explores the impacts of different SAS and DB2 configurations by outlining different methods of accessing the DB2 data with a focus on performance. The performance trade-offs of choosing different access methods, SAS System 9 application parameters and DB2 8.1 configuration options. This paper also highlights new features in SAS System 9 and DB2 version 8.1.
Did you find this white paper useful?
13 out of 22 users found this white paper useful
Related white papers
Delivering Affordable Information Management Functionality: Oracle Database Standard Edition One
Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This document considers the question of what...
Choosing a Reliable and Powerful IT Infrastructure at a Price You Can Afford
This whitepaper provides an overview of the challenges midsize organizations face, and how Oracle products can help them overcome those hurdles. Read this whitepaper to learn how midsize organizations like...
Database Consolidation Makes New IT Initiatives Possible
The Issue: The proliferation of databases is Preventing money and staff from being devoted to new IT initiatives.Read this recent AMR Research survey which found that companies are reducing the...
Database Consolidation: Reducing Cost and Complexity
The Bottom Line: Database consolidation projects offer companies the hope of lower costs, greater ease of database administration, and the chance to improve the quality of their database technology by...
Oracle Database: 11g Standard Edition ONE
Oracle Database 11g Standard Edition One is a full-featured data management solution ideally suited to the needs of fast-growing businesses. It is easy to install on Windows and Linux operating...
Oracle Database: 11g Standard Edition
Oracle Database 11g Standard Edition is a full-featured data management solution ideally suited to the needs of midsized businesses. It is easy to install on Windows and Linux operating systems, easy...
Making the Case for Oracle Database on Windows
Read this Ovum Summit paper to see why one of the best-kept secrets in the IT industry is the depth of support Oracle offers to customers deploying its databases on...
