IBM Systems Magazine, Mainframe Edition - November/December 2009 - 38

Tips & Techniques Measure and plan goals for peak periods. For the work that doesn’t have a concrete goal to achieve, consider utilizing a pure discretionary service class; they only run when all of the service classes are meeting their goals and resources are available. s 1UERY WORKLOAD CONSIDERATIONSˆ#ONSIDER UTILIZING MULTIPLE policies to change the goals for service classes/workloads where their business importance varies with time or date, for example, data warehouse refresh. In general, consider a mix of response time, velocity and discretionary goals using multi-period service CLASSES FOR YOUR ") QUERY WORKLOADS #ONSIDER PERCENTILE RESPONSE time goals for early periods that have frequent completions OF TRIVIAL TO M E DIUM RESOURCECONSUMPTION QUERIES #ONSIDER velocity and discretionary goals for later periods containing queries that have less frequent completions and medium to large resource consumption. You can also utilize multiple service classes to manage various USER GROUPS ACCORDING TO TH E BUSINESS IMPORTANCE #ONSIDER IR utilizing multiple service classes to distinguish online query work from scheduled query work. Online refers to work associated with an end-user sitting at a terminal waiting for a response. Scheduled refers to work that’s scheduled to run at a certain time of the day or is dependent upon some other process. s #LASSIFICATION CONSIDERATIONSˆ$" HAS RECENTLY PROVIDED A solution that will utilize already available WLM filters. For more flexibility and granular differentiation, consider using the new $" 7,-?3%4?#,)%.4?).&/ STOREDPROCEDURE SUPPORT È04& 5+ "!! FOR $" 6% 04& 5+ "!! FOR $" 6$É 4HIS WILL PROVIDE THE CAPABILITY TO FURTHER QUALIFY REMOTE CALLER È$$&É THREADS BY client accounting data, end user, workstation and application NAME &OR #OGNOS $ 30 APPLICATIONS THEREÇS MORE FLEXIBILITY I NUTILI Z THE 7,-?3%4?#,)%.4?).&/ ./4%& 4HOUGH LABELED ING h7,-?3%4?#,)%.4?).&/v THIS STORED PROCEDURE ALSO PROVIDES MUCH BETTER GRA N ULARITY FOR $" ACCOUNTING REPORTING s 2ESOURCE GROUPSˆ.ORMALLY YOU SHOULD TRY TO AVOID USING resource groups, as they restrict the WLM capability to make changes to meet the goals you’ve defined. However, when traditional WLM goals aren’t accomplishing the desired behavior OR WHEN YOUR )4 SHOP MANDATES EXACT STRICT CONTROL OVER processing resources, then resource groups can be utilized. When utilizing resource groups be sure to consider System z )NTEGRATED )NFORMATION 0ROCESSOR AND 3YSTEM Z !PPLICATION !SSIST 0ROCESSOR PROCESSING CYCLES ARE EXCLUDED FROM THE RESOURCE GROUP minimum and maximum processing specification. For additional ANALYSIS AND RECOMMENDATIONS SEE h#OMPARING 0ERFORMANCE TO 7,- 'OALSv ONLINE ÈWWWIBMSYSTEMSMAGCOMMAINFRAME NOVEMBERDECEMBER%TIPSTECHNIQUES"%PASPXÉ Manage Workloads 0ROPERLY MANAGING DIVERSE ") WORK LOADS ISNÇT AN EASY task, but following this structured approach should ease management pains. It may take some effort to create the resource summary table, but once constructed it provides the BACKBONE FOR THE REMAINING STEPS $ATA COLLECTION SHOULD BE performed on a regular basis. Setting up the data-collection process via automation could significantly simplify this step. Once collected, the data should be examined for anything that appears unusual. Only through this effort will you observe changing workload trends. ! WELLMANAGED SYSTEM IMPROVES HOW COMPETITIVE YOUR business is. It allows for better business decisions along with the capability to make more timely responses to business QUESTIONS 4HIS HELPS IMPROVE USER SATISFACTION AND MINIMIZE cost. Hopefully, the techniques outlined in this article will prepare you for a more effective workload-management i mplementat ion a nd i mprove t he capacit y to ac h ie ve its benefits. Leticia Cruz is an accredited senior IT specialist and a certified DB2 solutions expert at the IBM Worldwide Mainframe Benchmark Center. She can be reached at lmcruz@us.ibm.com. Willie Favero is currently a senior certified consulting IT software specialist working with the Data Warehouse for System z Swat Team at IBM’s Silicon Valley Lab. He can be reached at wfavero@us.ibm.com Nin Lei is an executive IT specialist and can be reached at runski@us.ibm.com. Dino Tonelli is a senior software analyst working in the System z Performance organization, focusing on data warehousing and workload management. He can be reached at dtonelli@us.ibm.com References MVS Planning: Workload Management http://publibz.boulder.ibm.com/epubs/pdf/iea2w191.pdf IMB Redbooks publication: “50 TB Data Warehouse Benchmark on IBM System z” (SG247674) www.redbooks.ibm.com/redbooks/pdfs/sg247674.pdf IBM InfoCenter: “DB2 Version 9 for z/OS — Performance Monitoring and Tuning Guide” http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/ index.jsp?topic=/com.ibm.db29.doc.perf/db2z_monitor db2performance.htm NOV EMBER/DEC EMBER 20 09 ibmsystemsmag.com/mainframe

IBM Systems Magazine, Mainframe Edition - November/December 2009

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe Edition - November/December 2009

Table of Contents
Editor's Desk:  Modus Operandi on a Budget
Trends:  DB2 X Leads the Industry to Minimize Complexity and Maximize Productivity
IT Today: New System z Solution Editions Provide a Cost-Effective Way to Meet Business Demands
Focus on Storage:  DFSMS Delivers Enhancements and Improvements With the New Release of z/OS
Cover Story:  IBM Smart Analytics Optimizer Reinvents the Data Warehouse.
Feature: IBM Offers Security Improvements In DB2 Version 9 and Beyond.
Administrator:  Configuring AEM to Monitor Power Usage
Tips & Techniques:  Managing BI With IBM Workload Manager
Advertiser's Index
Product News
Stop Run:  A New Web Site Celebrates the Mainframe’s Comeback
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Cover1
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Cover2
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 1
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Table of Contents
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 3
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 4
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 5
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 6
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 7
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Editor's Desk:  Modus Operandi on a Budget
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 9
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Trends:  DB2 X Leads the Industry to Minimize Complexity and Maximize Productivity
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 11
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 12
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 13
IBM Systems Magazine, Mainframe Edition - November/December 2009 - IT Today: New System z Solution Editions Provide a Cost-Effective Way to Meet Business Demands
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 15
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 16
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 17
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Focus on Storage:  DFSMS Delivers Enhancements and Improvements With the New Release of z/OS
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 19
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 20
IBM Systems Magazine, Mainframe Edition - November/December 2009 - IBM-1
IBM Systems Magazine, Mainframe Edition - November/December 2009 - IBM-2
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 21
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Cover Story:  IBM Smart Analytics Optimizer Reinvents the Data Warehouse.
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 23
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 24
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 25
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Feature: IBM Offers Security Improvements In DB2 Version 9 and Beyond.
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 27
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 28
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 29
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 30
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 31
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Administrator:  Configuring AEM to Monitor Power Usage
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 33
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 34
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 35
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Tips & Techniques:  Managing BI With IBM Workload Manager
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 37
IBM Systems Magazine, Mainframe Edition - November/December 2009 - 38
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Product News
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Stop Run:  A New Web Site Celebrates the Mainframe’s Comeback
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Cover3
IBM Systems Magazine, Mainframe Edition - November/December 2009 - Cover4
IBM Systems Magazine, Mainframe Edition - November/December 2009 - RF1
IBM Systems Magazine, Mainframe Edition - November/December 2009 - RF2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20191112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/relevantz_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2019mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20181112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2018mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20171112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_sesupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_linuxsupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20161112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/MainframeSecurity
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20151112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910_se
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910
http://www.ibmsystemsmagmainframedigital.com/MFSkills
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506_supp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20141112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_gt_201405
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/BigData
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20131112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20121112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/buyersguide2013
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/ibmsystems_mainframe_2012bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20111112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20101112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910_bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20091112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090506
http://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
http://www.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
http://www.nxtbookMEDIA.com