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.

Preface

Who this book is for

What this book covers

To get the most out of this book

Free Chapter

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

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)

Practice questions

Physical Design

Physical Design

Database planning

Creating a Db2 database

Smart disk storage management

Creating a table

Online table move

Copy schema procedure

Range clustering and range partitioning tables

Db2 BLU Acceleration

Data compression

SQL compatibilities

Compatibility features for Netezza

Practice questions

Implementing Business Rules

Implementing Business Rules

The SET INTEGRITY statement

Views with CHECK OPTION

Creating and using triggers

The system catalog views

Practice questions

Monitoring Db2 Activity

Monitoring Db2 Activity

Monitoring infrastructure

Administrative views for monitoring

EXPLAIN facility tools

Db2 troubleshooting tools

Practice questions

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

Practice questions

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

Practice questions

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

Practice questions

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Compatibility features for Netezza

Db2 11.1 provides features that enable applications that were written for a Netezza Platform Software (NPS) database to use a Db2 database, without having to be rewritten. To activate fully fledged NPS compatibility features, including the optional features, set the SQL_COMPAT global variable to NPS:

    SET SQL_COMPAT='NPS'

The following table shows optional compatibility features for Netezza:

Feature	Format	NPS Interpretation
Double-dot notation	<NPS_DB>..<NPS_Object>	<Schema>.<Object>
Translate Scalar Function Syntax	translate('12345', '143', 'ax')	a2x5
Operators	^ and **	Exponential Operators
Grouping by `SELECT` clause columns	`SELECT c1 AS a, c2+c3 AS b, COUNT(*) AS c FROM t1 GROUP BY 1, 2;`	Can specify the ordinal position or exposed name...