Book Image

IBM Db2 11.1 Certification Guide

By : Robert (Kent) Collins, Mohankumar Saraswatipura
Book Image

IBM Db2 11.1 Certification Guide

By: Robert (Kent) Collins, Mohankumar Saraswatipura

Overview of this book

IBM Db2 is a relational database management system (RDBMS) that helps you store, analyze, and retrieve data efficiently. 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 experience, the authors take you through all areas covered by the test. The book delves deep into each certification topic: Db2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, and security. IBM Db2 11.1 Certification Guide provides you with more than 150 practice questions and answers, simulating real certification examination questions. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book will not just prepare you for the C2090-600 exam but also help you troubleshoot day-to-day database administration challenges.
Table of Contents (10 chapters)

Db2 Server Management

This chapter covers the steps to configure and manage Db2 servers, instances, and databases. You will learn how to create and efficiently manage the database storage groups. You will also learn how to use many of the Db2 autonomic computing features to improve database availability and performance. You will learn how to use the Db2 workload manager (WLM) and its functionalities to efficiently meet the service-level agreements in the environment. By the end of the chapter, you will also be able to use the data server manager (DSM) to administer, monitor, and manage the Db2 database server. After the completion of this chapter, you will be able to demonstrate the ability to:

  • Create and manage Db2 instances and databases
  • View and modify the Db2 registry variables
  • View and modify the Db2 database manager configuration parameters
  • View and modify the Db2 database...