Db2 11.1 DBA for Linux, UNIX and Windows Certification (C2090-600) Crammer Course

Session Number: 6398
Track: Educational Seminars
Session Type: Educational Seminar
Primary Presenter: Mohankumar Saraswatipura [Kronsys Inc]
Co-Presenter 1: Robert Collins, Jr. [BNSF Railway Inc]
Time: Jun 02, 2019 (09:00 AM - 05:00 PM)
Room: Carolina E

Speaker Bio: Mohankumar (Mohan) Saraswatipura works as a Database Solutions Architect at Kronsys, Inc., focusing on IBM DB2, Linux, UNIX, and Windows and SAP HANA 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. He is an IBM Gold Consultant and IBM Champion (2010–2018) and a DB2's Got Talent 2013 winner. Mohan has written dozens of technical papers for IBM developerWorks and IBM Data Magazine and also authored 3 Db2 books (Db2 10.1/10.5 Certification Guide, Db2 11.1 Certification Guide and Db2 9.7 Application developer). 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: Select a Value
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Database Administrators
Technical areas this presentation will apply to: Connectivity, Information Integration and Replication, Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), New Release (DB2 for LUW)
Objective 1: Configure and manage DB2 servers, instances, and databases
Create and manage database storage paths
Exploit autonomic features
Explain the functionality of WLM
Describe the capabilities of Data Server Manager
Objective 2: Implement BLU Acceleration
Describe DB2 pureScale enhancements
Create, manage, and alter DB2 objects
Demonstrate the proper use of compression
Describe the SQL compatibility available
Describe the partitioning capabilities availab
Objective 3: Create and modify table constraints
Enforce constraint checking with the SET INTEGRITY command
Create and use triggers
Objective 4: Demonstrate the proper use of monitoring tools
Use the DB2 Problem Determination tool (db2pd)
Describe the capabilities of dsmtop
Capture and analyze EXPLAIN information

Objective 5: Demonstrate the proper use of REORG, REORGCHK, REBIND, RUNSTATS, FLUSH PACKAGE CACHE, and ADMIN_CMD
Perform an INPLACE table REORG
Demonstrate the proper use of db2look and db2move
Perform database-level and table space level backup
Co-speaker Name: Robert Collins, Jr.
Co-speaker Bio: Robert (Kent) Collins, founder of Shiloh Consulting, Inc., is currently a Data Solutions Architect with BNSF Railway. He is an IBM Champion (2010–2018) 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. Kent has authored 2 Db2 books (Db2 10.1/10.5 Certification Guide and Db2 11.1 Certification Guide). He lives in Dallas with his wife, Vicki; together, they have three children and one grandchild.

Abstract:  This certification crammer course is designed for IT professionals who plan to take the IBM Certified Database Administrator–Db2 11.1 for Linux, Unix, and Windows exam C2090-600. In this course, you will learn how to do the following:
1. Configure and manage Db2 v11.1 servers, instances, and databases
2. Implement Db2 BLU Acceleration databases
3. Create and implement database objects
4. Implement business rules using constraints
5. Implement high availability and disaster recovery solutions
6. Monitor and troubleshoot at instance and database levels
7. Implement security at instance, database, and objects levels
This certification study course is designed to provide the Db2 professional with the information required to successfully obtain C2090-600 certification. Each chapter contains topics covered in the exam, plus valuable insights into each topic, along with sample exam questions and detailed answers.