EDS1 - DB2 11.1 for Linux, UNIX, and Windows Database Administration Certification Exam (C2090-600) Crammer Course

Session Number: 4362
Track: EDSEM
Session Type: Educational Seminar
Primary Presenter: Mohankumar Saraswatipura [Kronsys Inc]
Co-Presenter 1: Robert Collins, Jr [BNSF Railway Inc]
Time: Apr 30, 2017 (09:00 AM - 05:00 PM)
Room: North Exhibit Hall Room D

Speaker Bio: Mohan works as a Database Solutions Architect at Kronsys, Inc., focusing on IBM DB2, Linux, UNIX, and Windows solutions. Prior to his current position, he worked as a Database Solutions Architect at Reckitt Benckiser Group, plc (UK) focusing on IBM Smart Analytics System 5600, Siebel, SQL Server, and SAP HANA solutions. He is an IBM Champion (2010–2016) and a DB2's Got Talent 2013 winner. Mohan has written dozens of technical papers for IBM developerWorks and IBM Data Magazine. He is an IBM Certified DB2 Advanced Database Administrator, DB2 Application Developer, and DB2 Problem Determination Master. Mohan holds a Master's of Technology (M Tech) degree in computer science and an Executive MBA (IT).
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Data Management, Data Warehousing and Business Intelligence, Disaster Recovery, Implementing New DB2 Releases and Features, Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users
Technical areas this presentation will apply to: Connectivity, Information Integration and Replication, Data Warehousing and Business Intelligence, Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), High Availability (DB2 for LUW), New Release (DB2 for LUW), pureScale, Security (DB2 for LUW), SQL and XML Features, SQL and XML Performance, Triggers, Stored Procedures, UDFs
Objective 1: • DB2 Server Management
I. Creating and configuring DB2 servers, instances and databases
II. Understanding Self tuning memory manager and storage groups
III. Understanding the capabilities of WLM and Data Server Manager


Objective 2: • Business Rule Implementation
I. Understanding the business use of constraints
II. Creating and modifying the constraints
III. Understanding the usage aspects of SET INTEGRITY command
IV. Creating and using triggers

&
Objective 3: • DB2 Utilities
I. Understanding the DB2 data movement utilities
II. Demonstrate the use of RUNSTATS, REORG with RECLAIM EXTENTS, REORGCHK, REBIND, FLUSH PACKAGE CACHE and ADMIN_CMD
III. Demonstrate the use of utility throttling and U
Objective 4: • DB2 High Availability
I. Database, table space level backup and restore procedures
II. Backup types and its usage perspective
III. Configure and manage HADR
IV. Configure automated HADR failover using TSA
V. Understanding
Objective 5: • DB2 Security

I. Demonstrate the authorization levels used by DB2
II. Demonstrate the privileges used by DB2
Co-speaker Name: Robert (Kent) Collins
Co-speaker Bio: Kent, founder of Shiloh Consulting, Inc., is currently a Data Solutions Architect with BNSF Railway. He is an IBM Champion (2010–2016) and a frequent speaker at the DB2Night Show and IDUG and IOD (IBM Insight) conferences. Kent has worked continually with DB2 from its introduction to the market in 1984, amassing a wealth of knowledge and experience. He graduated from the University of Texas at Dallas with majors in mathematics and computer science. He is an IBM Certified Solutions Expert and also holds certifications in DB2, AIX, Linux, .NET, Oracle, SQL Server, Windows, and z/OS. Kent is proficient in many programming languages and, as a Java Architect, specializes in Enterprise HA/Performance systems. He lives in Dallas with his wife, Vicki; together, they have three children and one grandchild.

Abstract:  This course is intended to describe the major technical features and enhancements provided by the DB2 v11.1 for Linux, UNIX and Windows. Also this is designed to introduce the students to the DB2 11.1 for Linux, UNIX, and Windows Database Administration certification exam (C2090-600). The course material is aligned with the exam objectives and was created by individuals who helped develop this exam.