IBM Db2 11.1 Certification Guide

Key Features

• A comprehensive certification preparation guide for exam C2090-600
• Provides complete coverage of the IBM DB2 v11.1 including step by step DB2 implementation procedures
• A practical, easily accessible guide with over 100 practice questions and answers

Book Description

Much more than a simple certification study aid, this comprehensive book is designed to help you master all aspects of IBM DB2 database administration and prepare you to take and pass IBM's Certification Exams C2090-600. Building on years of extensive hands-on experience, the authors step you through all the areas covered on the test. The book dives deep inside each certification topic: DB2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, security, and connectivity and networking. There is even a ""crash course"" chapter on DB2 v11.1 features. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book provides more than 400 practice questions and answers, more than 120 ""flash cards"" to help you study for the exam, and 50 step-by-step DB2 feature implementation procedures.

What you will learn

• Configure and manage DB2 servers, instances, and databases
• Describe the partitioning capabilities available
• Enforce constraint checking with the SET INTEGRITY command
• Use the DB2 Problem Determination tool (db2pd)
• Configure and manage HADR
• Understand how to encrypt data in transit and data at rest

Robert (Kent) Collins, founder of Shiloh Consulting, Inc., is currently a Database Solutions Architect with BNSF Railway. He is an IBM Champion (2010-2017) 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.

Mohankumar Saraswatipura Mohankumar 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 solutions. Mohan is an IBM Champion (2010-2017) and a DB2's Got Talent 2013 winner. He is also a frequent speaker at the DB2Night Show and IDUG conferences. He has written dozens of technical papers for IBM developerWorks and IBM Data Magazine and DB2 10.1/10.5 certification guide. 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).