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

Step 1: Understanding Workload Management To understand how System z* resources are utilized for BI workloads, start with a high-level understanding of the role, business importance, current resource-management and data-monitoring schemes of the different applications, systems and middleware tasks that make up the BI workloads. Build a simple table capturing this key information. The table should have enough detail so others responsible for managing performance can understand it, but not so much detail it becomes unmanageable. Build the table with the idea it will be a living document. Prior to building the table, obtain a copy of the current WLM service definition, which will be required to input some of the fields in the table. The WLM “Service Definition Formatter” is a valuable no-charge workstation tool for easily viewing and analyzing the WLM service definition and can be found online (www.ibm.com/ servers/eserver/zseries/zos/wlm/tools/sdformatter.html). When building the table, first decide which applications, servers and processes running on z/OS should be considered. Once a list is created, use company terminology or industrystandard terminology to categorize these into different types of BI activity. Examples include daily reporting, online analytical processing (OLAP), operational BI, data mining, daily and/ or dynamic refresh (see Figure 1, below ). For more details on building the table, see “Classifying BI Workloads,” online (www. ibmsystemsmag.com/mainframe/novemberdecember09/ tipstechniques/26909p1.aspx). Before proceeding to Step 2, take some time to review the table. How well do the current WLM definitions appear to map to the business goals? There could potentially be some modifications to consider, even prior to analyzing performance data. workload. Most of these tools come with the OS, while others can be downloaded. Here are some of the tools, in addition to WLM Service Definition Formatter, we’ve found useful: s 4HE 2ESOURCE -ANAGEMENT &ACILITY È2-&É 3PREADSHEET 2EPORTERˆ4HIS IS AN EXTENSION OF THE 2-& 0OSTPROCESSOR AND runs on your Windows* workstation. It gives you the capability to EXTRACT REPORTS FROM THE 2-& 0OSTPROCESSOR OUTPUT AND CONVERT them into common spreadsheet formats. You can find it online. s /NLINE 2-& 2EPORTSˆ6ARIOUS 2-& ONLINE REPORTING functions support real-time snapshot monitoring and short-term performance analysis. s $" ACCOUNTINGˆ&OR A DATA WAREHOUSE SYSTEM WHERE most of the workload activity is done in DB2, the data from the accounting reports of the DB2 Performance Expert (or similar product) can be useful in understanding workload resource consumption. You must consider other workloads present in the system that aren’t included in the DB2 accounting report to get a complete view of the system CPU usage. To utilize these or similar tools, collect complementary z/OS workload activity and DB2 performance data covering the key processing periods of interest (i.e., peak query and refresh). The objective is to gain an appreciation for the relationship between the DB2 view of the world and WLM. Once this is better understood, the end goal is to solely utilize the WLM performance information as input for future WLM policy adjustments. Step 3: Evaluate Performance vs. Business Goals The following recommendations can assist in the design or modification of the service definitions. When contemplating WLM modifications, a good performance administrator considers the current temperament of end users and by making one modification at a time, monitors the impact of each change. s 'ENERAL SERVICE AND REPORTCLASS GUIDELINESˆ6ERIFY SERVICE classes are being utilized to manage work and report classes are being utilized for monitoring work. Defining too many services could lead to less efficient WLM management. Step 2: Data Collection After you’ve identif ied, categorized and prioritized the applications, systems and middleware that make up your BI workloads, you’re now ready to undergo a deeper analysis of each component. It’s time to understand characteristics, such as resource requirements, and how each behaves on the existing system service definition. IBM (and other companies) offers many products and tools designed to help customers monitor and analyze the system Figure 1 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