
IBM Db2 11.1 Certification Guide: Explore techniques to master database programming and administration tasks in IBM Db2
By Mohankumar Saraswatipura, Robert (Kent) Collins
ISBN:
1788626915
Publisher:
Packt Publishing
Year:
2018
Pages:
529
About This Book
Key FeaturesA comprehensive certification preparation guide for exam C2090-600Provides complete coverage of the IBM DB2 v11.1 including step by step DB2 implementation proceduresA practical, easily accessible guide with over 100 practice questions and answersBook DescriptionMuch 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 learnConfigure and manage DB2 servers, instances, and databasesDescribe the partitioning capabilities availableEnforce constraint checking with the SET INTEGRITY commandUse the DB2 Problem Determination tool (db2pd)Configure and manage HADRUnderstand how to encrypt data in transit and data at rest