IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 40

utilities. Nearly 24 control-flow operators can be used for invoking these kinds of tasks, including data flows, job control language (JCL) jobs, DB2 utilities, setting variables and running DataStage jobs. Each operator has ports that determine the execution sequence depending on whether or not the operation completes successfully. In addition, the iterator ope r ator a nd va r iable - compa r i son operator can change the flow path. Using the parallel container, you can execute multiple tasks in parallel. Control f lows are packaged into a warehouse application for deployment to a production environment. The runtime environment administrator uses the Administration Console to install the warehouse application into the runtime environment. The administrator can also use the Administration Console to execute deployed f lows on demand or via a schedule, and to view execution status, history and statistics. a MOLAP engine, without copying the data. The data isn’t persisted outside of the data warehouse, so the same data is used for traditional SQL reporting and multidimensional reporting–providing data consistency across tooling. Cubing Services acts as a multidimensional hot cache and a multidimensional expressions (MDX)-SQL bridge. When BI tools such as Cognos request data from Cubing Services using MDX, the cube server will first check the cube cache. If the information is in the cache, the user experiences MOLAP response times. If the information isn’t in the cache, the cube server formulates SQL queries to retrieve the data from DB2 to extend the in-memory cube (see Figure 4, below). FIGURE 3 A CONTROL FLOW OLAP Server The real data-warehouse business value comes from providing access to the information. DB2, of course, supports the traditional relational reporting but more users want OLAP capabilities, or the capability to slice and dice the data at high aggregation levels and drill into more details. This is difficult to do with straight relational engines and has traditionally been accomplished using multidimensional online analy tical processing (MOL A P) engines. These databases provide access to aggregated data with fast query performance, but with a cost of data redundancy, lengthy processing to load and calculate the aggregations, and limited scalability. I n foSphe r e Wa r e hou s e pr ov ide s Cubing Services as an OLAP solution. The goal of Cubing Services is to provide a higher degree of scalability and highspeed access to aggregated data as in 40 J U LY/A UGUS T 20 09 FIGURE 4 CUBING SERVICES ARCHITECTURE ibms ystemsmag .com/mai nframe

IBM Systems Magazine, Mainframe digital edition - July/August 2009

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe digital edition - July/August 2009

IBM Systems Magazine, Mainframe digital edition - May/June 2009
Table of Contents
Editor’s Desk: Cooking Up a Data Solution
Trends: IBM’s Scorpion Team Provides an Updated Method for Analyzing and Optimizing IT Infrastructures
Focus on Storage: Tivoli Storage Manager 6 Accommodates Surging Data
Case Study: Insurance Company Swiss Mobiliar Uses BMC Software’s APPTUNE to Ensure its Applications Perform Well
Cover Story: An Integrated Data-Management Approach Supports Data Throughout its Lifecycle
Feature: InfoSphere Warehouse Expands Data-Warehouse Tooling to the System z for Operational BI Functionality
Technical Corner: Planning for a z/OS V1.9 Migration
Product News
Advertiser’s Index
Stop Run: IBM Jams Tap Into the Power of the Crowd
Reference Point
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - IBM Systems Magazine, Mainframe digital edition - May/June 2009
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover2
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 1
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Table of Contents
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 3
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 4
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 5
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 6
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 7
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Editor’s Desk: Cooking Up a Data Solution
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 9
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Trends: IBM’s Scorpion Team Provides an Updated Method for Analyzing and Optimizing IT Infrastructures
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 11
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 12
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 13
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 14
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 15
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 16
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 17
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Focus on Storage: Tivoli Storage Manager 6 Accommodates Surging Data
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 19
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20a
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20b
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20c
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20d
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 21
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Case Study: Insurance Company Swiss Mobiliar Uses BMC Software’s APPTUNE to Ensure its Applications Perform Well
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 23
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 24
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 25
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 26
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 27
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover Story: An Integrated Data-Management Approach Supports Data Throughout its Lifecycle
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 29
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 30
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 31
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 32
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 33
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 34
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 35
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Feature: InfoSphere Warehouse Expands Data-Warehouse Tooling to the System z for Operational BI Functionality
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 37
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 38
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 39
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 40
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 41
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Technical Corner: Planning for a z/OS V1.9 Migration
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 43
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 44
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 45
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Product News
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Advertiser’s Index
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Stop Run: IBM Jams Tap Into the Power of the Crowd
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover3
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover4
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Reference Point
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - RF2
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