IBM Systems Magazine, Mainframe - March/April 2009 - 6

DB2utor Lessons on DB2 for z/OS Mainframe edition Each week on ibmsystemsmag.com 220 S. 6th St., Suite 500, Minneapolis, MN 55402 (612) 339-7571 To apply for or cancel your IBM Systems Magazine subscription, visit www.ibmsystemsmag.com. EDITORIAL EXECUTIVE PUBLISHER Diane Rowell (drowell@us.ibm.com) PUBLISHER Doug Rock (drock@msptechmedia.com) EXECUTIVE EDITOR Evelyn Hoover (ehoover@msptechmedia.com) MANAGING EDITOR Natalie Boike (nboike@msptechmedia.com) COPY EDITOR Caroline Vitse SENIOR WRITER Jim Utsler (jutsler@msptechmedia.com) TECHNICAL EDITORS Jim Schesvold (jschesvold@mainframehelp.com) Ted MacNeil (tedmacneil@alumni.uwaterloo.ca) Mike Cairns (mike.cairns@au1.ibm.com) PRODUCTION ART DIRECTOR Jill Adler PRODUCTION MANAGER Jonathan Benson PROJECT MANAGER Kelly Daugherty ASSOCIATE TECHNICAL PRODUCER David Waters CIRCULATION CIRCULATION DIRECTOR Jane Breckinridge CIRCULATION MANAGER Linda Holm CIRCULATION COORDINATOR Carin Russell FULFILLMENT COORDINATOR Rebecca Bogema ADVERTISING/SALES ASSOCIATE PUBLISHER Mari Adamson-Bray (612) 336-9241 (mbray@msptechmedia.com) SENIOR ACCOUNT MANAGER, NORTHEAST, NORTHWEST & CANADA Kathy Ingulsrud (612) 313-1785 (kingulsrud@msptechmedia.com) ACCOUNT EXECUTIVE, MIDWEST & EUROPE Darryl Rowell (612) 313-1781 (drowell@msptechmedia.com) ACCOUNT EXECUTIVE, SOUTHEAST, SOUTHWEST & AUSTRALIA Lisa Kilwein (574) 988-0011 (lkilwein@msptechmedia.com) SALES AND MARKETING DEVELOPMENT MANAGER Katie Swanson IBM EDITORIAL BOARD Eric Baxley Director, System z Software Marketing Marianne Carter Software Product Manager DB2 for z/OS Program Offerings Paul DiMarzio STG System z Brand, Enterprise Integration Strategy Joe Doria Director, Global Marketing IBM System z Willie Favero Senior Certiﬁed Consulting IT Software Specialist Data Warehouse for System z Swat Team Simon Hares System z Marketing Manager IBM Sales and Distribution Bob Hoey General Manager, Major Markets IBM Systems & Technology Group Juergen Holtz Design and Development, Tivoli System Automation Technologies Kurt Johnson System z Market Management and Marketing Strategy Allen Marin IBM System Storage Enterprise Disk Marketing Caryn Meyers Business Intelligence Marketing, System z Mary Moore STG Business Resilience Offerings Doug Pearson Manager, System z Platform Marketing Jim Porell IBM Distinguished Engineer System z Business Development Denny Refsnider z/VM Marketing/Announcements IBM Systems and Technology Group Jacqui (Jax) Shawley WorldWide Market Manager LMI Program Marketing – System z Software Jack Yuan IMS TM and Connect Development Lead IBM Software Group/ Database Management Troy Coleman Troy Coleman, sales engineer with SoftBase Systems, Inc., knows DB2 for z/OS forwards and backwards. As the ibmsystemsmag.com Mainframe blogger he , imparts some of that knowledge and wisdom each week in DB2utor. Check it out. Contribute to the conversation. Impart some of your own wisdom. DB2utor with Troy Coleman © Copyright 2009 by International Business Machines (IBM) Corporation. This magazine could contain technical inaccuracies or typographical errors. Also, illustrations contained herein may show prototype equipment. Your system conﬁguration may differ slightly. This magazine contains small programs that are furnished by IBM as simple examples to provide an illustration. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. All programs contained herein are provided to you “AS IS.” IMPLIED WARRANTIES OF MERCHANTABILITY, NON-INFRINGEMENT AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. All rights reserved. All customer examples cited represent the results achieved by some customers who used IBM products. Actual environmental costs and performance characterics will vary depending on individual customer conﬁgurations and conditions. Information concering non-IBM products was obtained from the products’ suppliers. Questions on their capabilites should be addressed with the suppliers. All statements regarding IBM’s future direction and intent are subject to change or withdrawal without notice and represent goals and objectives only. The articles in this magazine represent the views of the authors and are not necessarily those of IBM. The following are trademarks (marked with an *) of the International Business Machines Corporation in the United States and/or other countries. A complete list of IBM Trademarks is available online (www.ibm.com/legal/copytrade.shtml). AIX DB2 ESCON FICON IBM IBM logo MVS OS/390 POWER S/390 System i System p System Storage System z System z9 System z10 Tivoli TotalStorage VM/ESA VSE/ESA WebSphere System x z/OS z/VM Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc., in the United States and other countries. Microsoft, Windows and Windows NT are trademarks of Microsoft Corp., in the United States and other countries. Intel, MMX and Pentium are trademarks of Intel Corp. in the United States and other countries. UNIX is a registered trademark of The Open Group in the United States and other countries. SET is a trademark owned by SET Secure Electronic Transaction LLC. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Linear Tape-Open, LTO, the LTO logo, Ultrium, and the Ultrium logo are trademarks of Certance, HP and IBM in the U.S. and other countries. Other company, product and service names may be trademarks or service marks of others. Articles appearing in IBM Systems Magazine, Mainframe edition may have been published in previous IBM Systems Magazine editions. Reprints: To order reprints, contact Kelly Carver (612) 336-9280. ibmsystemsmag.com IBM Systems Magazine, Mainframe edition (ISSN# 1544-8819) is published bimonthly by MSP TechMedia, 220 South Sixth St., Suite 500, Minneapolis, MN 55402. Publications Agreement No. 40063731, Canadian Return Address, Pitney Bowes, Station A, PO Box 54, Windsor, Ontario Canada N9A 6J5 Printed in the U.S.A. 6 M A R C H/A PRIL 2009 ibmsystemsmag.com/mainframe

http://ibmsystemsmag.blogs.com/db2utor/ http://www.ibmsystemsmag.com http://ibmsystemsmag.blogs.com/db2utor/ http://www.ibm.com/legal/copytrade.shtml http://ibmsystemsmag.blogs.com/db2utor/ http://www.ibmsystemsmag.com/mainframe

IBM Systems Magazine, Mainframe - March/April 2009

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - March/April 2009