Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying IBM Db2 11.1 Certification Guide
  • Table Of Contents Toc
IBM Db2 11.1 Certification Guide

IBM Db2 11.1 Certification Guide

By : Collins, Saraswatipura
2.8 (5)
Buy this Book
close
close
IBM Db2 11.1 Certification Guide

IBM Db2 11.1 Certification Guide

2.8 (5)
By: Collins, Saraswatipura
Buy this Book

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

Introduction to the Db2 Certification Path

This certification guide is designed for IT professionals who plan to take the IBM Certified Database Administrator–Db2 11.1 for Linux, Unix, and Windows exam C2090-600. Using this certification study guide, you will learn how to do the following:

  • Configure and manage Db2 v11.1 servers, instances, and databases
  • Implement Db2 BLU Acceleration databases
  • Create and implement database objects
  • Implement business rules using constraints
  • Implement high availability and disaster recovery solutions
  • Monitor and troubleshoot at instance and database levels
  • Implement security at instance, database, and objects levels

This certification study guide is designed to provide the Db2 professional with the information required to successfully obtain C2090-600 certification. Each chapter contains topics covered in the exam, plus valuable insights into each topic, along with sample exam questions and detailed answers.

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
IBM Db2 11.1 Certification Guide
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon