F10 - The Challenges and the Redesign of a BigData Mission Critical Application

Session Number: 190
Track: Big Data and Analytics
Session Type: Podium Presentation
Primary Presenter: Bryan Paulsen [John Deere]
Time: May 02, 2013 (01:00 PM - 02:00 PM)
Room: Bonaire 5&6

Speaker Bio: Bryan Paulsen is a technology architect for John Deere in Moline, IL. He specializes in DB2 for z/OS in the DB2 Classic/Legacy and DB2 SAP environments. His experiences include DB2 systems programming, project manager for the DB2 V8, 9 and 10 Early Support Programs, DB2 disaster recovery technical lead and project manager for migrating John Deere’s SAP implementations to SAP on DB2 for z/OS. He is a founding member of the Very Large Database (VLDB) Technical Exchange; an organization of companies running SAP on DB2 for z/OS.

Bryan has spoken at IDUG North America, IDUG Europe, IDUG Regional Forums, IBM’s Information On Demand, SHARE, Central Canada DB2 User Group and Colorado DB2 User Group. He received the Best User Speaker Award for IDUG North America 2004, 2007 and 2009 and IDUG Europe 2007. He is a member of the IDUG Speakers Hall of Fame. Bryan served on the IDUG North America Conference Planning Committee from 2007 until 2012 and was the Conference Chair for IDUG North America 2011. Bryan has been recognized as an IBM Information Champion in 2009, 2010, 2011 and 2012.

Audience experience level: Beginner
Presentation Category: Managing Availability, Big Data
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Data Architects, Database Administrators, Systems Programmers, New Users
Technical areas this presentation will apply to: High Availability (DB2 for z/OS), User Experiences
Objective 1: The application and the challenge of BigData in regards to availability and scalability.
Objective 2: Page Size, DSSIZE, Partitioning, Clustering, Indexing and other considerations.
Objective 3: Partition by Growth or Partition by Range?
Objective 4: To use or not to use Append?
Objective 5: Data Sharing and cascading failover.

Abstract:  We have a telematics application at John Deere that has recently experienced some challenges as it grows up into a BigData mission critical system. This past year we embarked on a redesign of the application and database in order to provide greater availability and scalability. This presentation will cover the challenges of the application and a variety of DB2 features that we used or chose not to use in enhancing the application and database. The presentation will cover a number of things including page sizes, partitioning, UTS and PBG or PBR and how we got ‘caught’ with append. I will also talk about our usage of DB2 data sharing in order to provide for a cascading failover implementation.