IBM Systems Magazine, Mainframe digital edition - September/October 2009 - (Page 6) DB2utor Lessons on DB2 for z/OS Mainframe edition Each week on ibmsystemsmag.com MSP TechMedia 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) 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 Doris Conti System z Strategy Manager Paul DiMarzio STG System z Brand, Enterprise Integration Strategy Joe Doria Director, Global Marketing IBM System z Willie Favero Senior Certified Consulting IT Software Specialist Data Warehouse for System z Swat Team Juan Gastelu Manager, Data Center Optimization Marketing IBM Systems and Technology Group 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 configuration 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 configurations 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 SEPTEMBER/OCTOBER 2009 ibmsystemsmag.com/mainframe http://ibmsystemsmag.blogs.com/db2utor/ 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://ibmsystemsmag.blogs.com/db2utor/ http://www.ibmsystemsmag.com/mainframe Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe digital edition - August/September 2009 IBM Systems Magazine, Mainframe digital edition - August/September 2009 Editor's Desk: IBM Makes it Easy to be Green Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution Feature: Women in IT Team Up to Succeed Developer: Process XML Documents Within COBOL and DB2 SSDs Are Integral to Enterprise Storage Infrastructures Product News Advertiser Index Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig Reference Point 2010 Mainframe Buyer's Guide IBM Systems Magazine, Mainframe digital edition - August/September 2009 IBM Systems Magazine, Mainframe digital edition - August/September 2009 - (Page Intro) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page Cover1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page Cover2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 4) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 5) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 6) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 7) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Editor's Desk: IBM Makes it Easy to be Green (Page 8) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Editor's Desk: IBM Makes it Easy to be Green (Page 9) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 10) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 11) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 12) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 13) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 14) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 15) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 16) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 17) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 18) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 19) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 20) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 21) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 22) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 23) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 24) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 25) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 26) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 27) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 28) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 29) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 30) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 31) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 32) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 33) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 34) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 35) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 36) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 37) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 38) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 39) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 40) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 41) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 42) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 43) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 44) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 45) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 46) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 47) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 48) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 49) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 50) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 51) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 52) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 53) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Product News (Page 54) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Advertiser Index (Page 55) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page 56) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page 57) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page 58) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page Cover3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page Cover4) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Reference Point (Page RF1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Reference Point (Page RF2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG4) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG5) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG6) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG7) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG8) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG9) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG10) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG11) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG12) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG13) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG14) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG15) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG16) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG17) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG18) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG19) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG20) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG21) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG22) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG23) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG24) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG25) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG26) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG27) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG28) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG29) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG30) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG31) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG32) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG33) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG34) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG35) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG36) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG37) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG38) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG39) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG40) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover4) http://www.nxtbookMEDIA.com
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.