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