DB2 v11.1 DBA Certification Study Guide

Designing efficient database systems to deal with large amounts of dataAbout This Book* 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 answersWho This Book Is ForThis guide is intended for Linux, UNIX or Windows Database administrators, architects or application developers looking to obtain a certification in DB2. Some understanding of the basics of DB2 is required to get the most out of this gudie.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 restIn DetailMuch 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.