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

Sponsor - T.L. Ashford & Associates
Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at


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.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor



MC Industry Events Calendar

AIX File Transfers--Automation and Security Without Scripting

Thursday, April 12, 2012 12:00 PM - 1:00 PM CST

Writing AIX shell scripts to transfer files can be error-prone and time consuming for your IT department.

How do you know when the script fails?

Are the files and passwords secured/encrypted?

Where are the audit trails?

Are you in compliance?

Many AIX shops are now looking at Managed File Transfer (MFT) solutions to help them move beyond the many problems of scripting. During this free webinar, you will find out how to:

  • Use intuitive wizards to quickly set up file transfers.
  • Secure file transfers with SFTP, FTPS, AS2 and Open PGP standards.
  • Guarantee delivery with auto-resume and integrity checks.
  • Automate file transfers through the built-in scheduler or from your applications.
  • Provide a web portal for your trading partners for ad-hoc file transfers.
  • Keep centralized audit logs to comply with PCI DSS, HIPAA and other privacy laws.
  • Receive alerts so you immediately know if/when transfers fail.

We hope you'll join us! Register Here