View Printable Version

C17 - Migrating an On-Premises Db2 Database to the Cloud

Session Number: 5262
Track: Db2 for LUW I
Session Type: Podium Presentation
Primary Presenter: Roger Sanders [IBM]
Time: Oct 05, 2017 (09:40 AM - 10:40 AM)

Speaker Bio: Roger E. Sanders is a Db2 Offering Manager at IBM. He has been working with DB2 for Linux, UNIX, and Windows (DB2 for LUW) since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition) and is the author of 25 books on relational database technology (24 are on DB2 and one is on ODBC). For 10 years, Roger authored the “Distributed DBA” column in IBM Data Magazine (formerly DB2 Magazine), and for three years, he served as President of the Triangle DB2 User’s Group (TriDUG), a regional Db2 user’s group that meets in Research Triangle Park, North Carolina. Roger has also written articles for publications like Certification Magazine and IDUG Solutions Journal (the official magazine of the International DB2 User's Group), authored Db2-related tutorials and articles for IBM's developerWorks website, presented at a variety of International DB2 User’s Group (IDUG) conferences and regional Db2 User’s Group meetings, taught numerous courses on Db2 Fundamentals and Db2 Database Administration, and participated in the development of 25 Db2 certification exams.

From 2008 to 2015, Roger was recognized as an IBM Champion for his contributions to the IBM Data Management community; in 2012 he was recognized as an IBM developerWorks Master Author, Level 2 (for his contributions to the IBM developerWorks community).
Audience experience level: Beginner, Intermediate
Presentation Platform: DB2 for Linux, UNIX, Windows
Presentation Category: Emerging Technology (cloud, mobile, ...)
If Tools and Utilities was selected which products: db2look, Export, Import, Load
Audiences this presentation will apply to: Data Architects, Database Administrators
Objective 1: Why you should be thinking about the cloud
Objective 2: Things to consider before doing a ground to cloud migration
Objective 3: Moving an on-premises database to the cloud
Objective 4: Protecting sensitive data during the migration process

Abstract:  There is a bias among many DBAs that the public cloud is not secure, and that keeping data stored in the cloud is not an option they are willing to explore. It feels better to know that database servers sit inside a company’s walls and that they have complete control over their database environments. But, after a few years of operating other workloads in the cloud, organizations are confirming that the benefits - availability, cost reduction, and flexible scalability top the list - match the original promise of cloud computing. Consequently, the use of cloud applications is increasing and it is apparent that the move toward cloud computing is inevitable. This presentation will introduce participants to Db2 on Cloud and Db2 Warehouse on Cloud and walk them through a simple process that can be used to "test the cloud waters" by migrating on-premises Db2 development and test databases to one (or both) of these cloud offerings.

For questions or concerns about your event registration, please contact