Articles & Content
Topic: 2008 NA
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2008-05-21 (01:30 PM - 02:30 PM)
SPEAKERS: Tom Glaser (AT&T)
Ever had a need to join data sources and you had to do this across platforms? I bet you thought it would be difficult, so that's as far as the project got. We'll tackle the issue of joining data sources across DBMSs and flat files by using WebSphere Federated Server. That's right, we'll join DB2, Oracle, Teradata, SQL Server and flat files within the same query. I'll show you how easy it is to query a flat file on z/OS using Classic Federation. Come see how AT&T implemented this technology and how the application groups are benefiting. We'll look at the requirements of the application and the various obstacles that had to be overcome. From installation of the tools, to ongoing support.
EXP. LEVEL: Beginner
Overview of an existing application at AT&T, it's purpose and the current problems associated with this application.
Problems with having data spread out on DB2 z/OS, flat files on the mainframe, SQL Server, Teradata and Oracle.
We'll review WebSphere Federated Server and the WebSphere Classic Federation tools and how they can make like a little easier.
Learn about our installation and user experiences with both tools and how to set up the connections for the multiple data sources and environments.
Discuss our end result. Show the changes to the application utilizing Federated Server and the benefits gained for the upfront work. Before and after transactions rates and quickness in implemented new application designs.
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.