MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

April 11, 2012 | Volume 7 Issue 4


TOP STORY: DB2 Query Parallelism
FEATURED NEWS: Dell Acquisitions Signal Big Step into Global Application Modernization Business
NEWS HIGHLIGHT: INPRO International Releases V6.1.P of TimeZoNe/400
ON-DEMAND WEBCAST: Migrating from IBM Query/400?
EVENT: AIX File Transfers--Automation and Security Without Scripting
Manage Subscription | Contact Us

Feature Article - Database
DB2 Query Parallelism

Learn how DB2's query parallelism features help speed query run time.

Written by Susan Lawson and Daniel Luksetich

Editor's Note: This article is an excerpt from Chapter 17, "Performance Monitoring and Tuning," of DB2 10 for z/OS Database Administration: Certification Study Guide.


To reduce elapsed time for a query, DB2 can give queries parallel resources, such as several I/O paths or processors. By taking advantage of these resources, queries can run in a shorter period of time, enabling more work to be pushed through the system. Parallelism can help improve the performance of I/O- and CPU-bound read-only queries. It can help queries that are reading large amounts of data, regardless of the filtration.


Featured News
Dell Acquisitions Signal Big Step into Global Application Modernization Business

Dell has acquired Clerity Solutions of Chicago and announced it has signed a definitive agreement to acquire Make Technologies of Vancouver, B.C., both leading global providers of application modernization software and services that the company says reduce the cost, risk and time required to re-engineer applications. "The addition of Make Technologies and Clerity Solutions to Dell Services positions us to lead in the fast-growing applications modernization space," says Steve Schuckenbrock, president, Dell Services.


Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor