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.

Related Content you might be interested in

Current Title:

Small book image
IBM Db2 11.1 Certification Guide
Robert (Kent) Collins | Mohankumar Saraswatipura
Jun, 2018 | 478 pages
No titles found
Table of Contents (10 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
Free Chapter
1
Introduction to the Db2 Certification Path
Introduction to the Db2 Certification Path
Db2 11.1 Certification track
Preparing for the C2090-600 certification exam
Registering for the C2090-600 certification exam
Summary
2
Db2 Server Management
Db2 Server Management
Working with Db2 instances
Configuring the Db2 system environment
DB2 autonomic computing features
A word about Db2 workload manager (WLM)
A word about IBM Data Server Manager (DSM)
Summary
Practice questions
Solutions
3
Physical Design
Physical Design
Database planning
Creating a Db2 database
Buffer pools
Storage groups
Tablespaces
Smart disk storage management
Creating a table
Online table move
Copy schema procedure
Range clustering and range partitioning tables
Db2 BLU Acceleration
Db2 pureScale
Data compression
SQL compatibilities
Compatibility features for Netezza
Summary
Practice questions
Solutions
4
Implementing Business Rules
Implementing Business Rules
Business rules
The SET INTEGRITY statement
Views with CHECK OPTION
Creating and using triggers
The system catalog views
Summary
Practice questions
Answers
5
Monitoring Db2 Activity
Monitoring Db2 Activity
Monitoring infrastructure
Administrative views for monitoring
EXPLAIN facility tools
Db2 troubleshooting tools
Summary
Practice questions
Solutions
6
Db2 Utilities
Db2 Utilities
Data movement file formats
Data movement utilities
DB2 utilities comparison – Import vs. Ingest vs. Load
A word about the CATALOG STORAGE ACCESS command
Other DB2 data movement options
A word about the db2look tool command
Database maintenance utilities
The ADMIN_CMD () procedure
Summary
Practice questions
Answers
7
High Availability
High Availability
Transactions and logging parameters
Transaction logging strategies
Database recovery methods
Backup and recovery
A word about the db2relocatedb command
High availability and disaster recovery
Db2 pureScale architecture
Geographically dispersed Db2 pureScale db2cluster (GDPC)
Db2 pureScale db2cluster service command options
Explicit Hierarchical Locking
Summary
Practice questions
Answers
8
Db2 Security
Db2 Security
Authentication and authorization
Authorities and privileges
LDAP-based authentication
Role-based access control
Trusted context and trusted connections
Row and column access control (RCAC)
The Db2 audit facility
Secure Socket Layer (SSL) implementation in Db2
Db2 native encryption
Summary
Practice questions
Answers
9
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

Practice questions

  • Question 1: Which command can be used to display only the instance level registry settings for an instance db2inst1?
    1. db2set -all db2inst1
    2. db2set -i db2inst1
    3. db2set -lr
    4. db2val
  • Question 2: Which of the following commands can be used to retrieve CURRENT and PENDING values of database manager configuration parameters for the instance db2inst1? (Choose two.)
    1. db2look -dbmcfg
    2. db2 "ATTACH TO db2inst1"; db2 "GET DBM CFG SHOW DETAIL"
    3. db2 "GET DBM CFG SHOW DETAIL"
    4. db2pd -dbmcfg
    5. db2greg
  • Question 3: Which of the following table functions displays the registry setting?
    1. MON_GET_DATABASE ()
    2. MON_GET_INSTANCE ()
    3. ENV_GET_REG_VARIABLES ()
    4. MON_GET_UTILITY()
  • Question 4: Which of the following parameters contributes to DATABASE_MEMORY usage? (Choose two.)
    1. dbheap
    2. stmtheap
    3. applheapsz
    4. appl_memory
    5. util_heap_sz
  • Question 5: What is the order...
Previous Section
End of Section 8
Next Section