Start Here: DB2 Basics for Developers and Administrators

Session Number: 6297
Track: Educational Seminars
Session Type: Educational Seminar
Primary Presenter: Ember Crooks [Xtivia]
Co-Presenter 1: Michael Krafick [Sherwin-Williams]
Time: Jun 02, 2019 (09:00 AM - 05:00 PM)
Room: Governors ballroom 3

Speaker Bio: Ember is a Db2 Lead DBA and Delivery Manager at XTIVIA. She is responsible for the design, build, and management of a wide range of Db2 databases for multiple clients. Ember has 18+ years of experience with Db2 on Linux, Unix, and Windows platforms. She is the founder and principal author of the popular technical blog where she educates herself and others through example and case study. Ember is an IBM Gold Consultant and IBM Champion in Information Management.
Audience experience level: Beginner
Presentation Category: Data Management, Managing Availability, Managing Database Resources
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: New Users
Technical areas this presentation will apply to: Connectivity, Information Integration and Replication, Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), High Availability (DB2 for LUW), Security (DB2 for LUW)
Objective 1: Understand the basics of why to use Db2, how to install it and set it up, and an overview of the current state of licensing
Objective 2: Get an introduction to SQL and how Db2 handles concurrency and data integrity through locking and isolation levels
Objective 3: Take a deep dive into the Db2 documentation and how to navigate it and use it while going though an overview of troubleshooting
Objective 4: At a high level, understand the basics of recoverablitity and the high availability and disaster recovery options available in Db2
Objective 5: Take a whirlwind tour of the basics of objects in Db2, some of the security features and options available and, if we have time, the essentials of performance
Co-speaker Name: Michael Krafick
Co-speaker Bio: Michael Krafick is an IDUG Hall of Fame speaker, IBM Champion, and member of the Db2 Technical Advisory Board. He is also the host of the DISCOVER.DB2 YouTube Channel and frequent guest blogger for Mike has 18 years experience as a DBA in various database builds ranging from transaction processing, to data warehouse, and everything in-between.

Abstract:  You're at a Db2 conference so obviously you at least know how to spell Db2. Db2 education can be hard to come by. Once you have worked with Db2 for a few years, there is no better place for education than an IDUG Conference. However, IDUG conferences can be overwhelming for someone new to DB2. If you have just started working with DB2, this seminar is the place for you. This session is designed for any technicians who have been working with Db2 for less than 2 years. In addition to an introduction to Db2, this session serves to fill in the knowledge gaps that are inevitable in a self-taught world.