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

Now, instead of uploading and System z server and, as Baumann puts downloading customer data in a it, “some code on end-user boxes.” batch-like env ironment, whenInternal users are responsible for ever they could establish a hard most of t he work load, around 95 — Thomas Baumann, con nec t ion to Sma r t PVS, t he percent, and partner companies that Swiss Mobiliar data-management salespeople can gain real-time sell insurance products not only for team leader access to customer infor mation Mobiliar, but also for other companies t han k s to wireless connections such as travel agencies, use the remaining to the company’s back-end system. “Policy 5 percent, Baumann notes. information goes into the central system within Before t he applicat ion lau nch, wh ich now a few seconds, and in a few minutes, the policy is allows real-time access to customer data, salespeople employed batch uploading and downloading. Employees used completely booked,” Baumann says. a local application running on laptops without any immediate back-end connectivity. When they wanted to tap into the Not Too Technical core application, they’d have to return to an agency office The road to this point wasn’t necessarily smooth. In fact, or another fixed-network station to upload and download when the new application—which runs on Windows* OS-based customer data. application servers that directly access and manipulate z/OS* This, of course, created delays in insurance-policy processing, DB2 data, based on ODBC and JDBC protocols—was launched with complete processing sometimes taking three or four days. in July 2005, it suffered from serious performance problems “If an insurance policy had changed, the salespeople would have and was largely unusable. to take their laptops to an agency, upload the data through our “There were some design errors,” Baumann admits. “At central system, wait for the policy booking and then download first, the system was collecting all of the data connected to that data back onto their laptops,” Baumann notes. “It took customers, including all claims, address-change histories and several days for this cycle to complete.” more. Pretty much everything. As a result, it would take up to This was the primary reason Swiss Mobiliar created a more two or three minutes to get data about customers, even if you robust and mobile client application that would tap into the wanted to look at the information only very briefly.” central application and database running on the hosted mainSwiss Mobiliar had been using BMC’s A PP T U N E for frame. Although not completely Web based and still reliant years, prior to the rollout of this new application, but mainly on some client software, the new application is a huge leap for production problem aler ts. If an issue with a quer y forward for the company’s sales staff. occurred, the company’s IT team would be notified of the “From a developer’s point of view, APPTUNE isn’t too technical to be hard to understand.” UP CLOSE CUSTOMER: Swiss Mobiliar HEADQUARTERS: Bern, Switzerland BUSINESS: Insurance provider HARDWARE: An IBM System z server hosted by T-Systems Enterprise Services SOFTWARE: Homegrown core and ancillary applications; APPTUNE from BMC Software CHALLENGE: Improving query and application response times SOLUTION: Using APPTUNE during application development and testing and in production 24 J U LY/A U G U S T 2009 ibmsystemsmag.com/mainframe

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