IBM Db2 11.1 Certification Guide电子书

Title Page

Copyright and Credits

IBM Db2 11.1 Certification Guide

Packt Upsell

Why subscribe?

PacktPub.com

Foreword

Contributors

About the authors

About the reviewers

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the color images

Conventions used

Get in touch

Reviews

Introduction to the Db2 Certification Path

Db2 11.1 Certification track

Db2 10.5 Fundamentals for LUW–Exam C2090-615

Db2 11.1 Fundamentals for LUW–Exam C2090-616

Db2 11.1 DBA for LUW–Exam C2090-600

Preparing for the C2090-600 certification exam

Registering for the C2090-600 certification exam

Summary

Db2 Server Management

Working with Db2 instances

Creating an instance

Dropping an instance

Listing instances

Displaying the Db2 service level

Verifying the database's readiness for upgrading

Upgrading a database instance

Starting and stopping an instance

Attaching and detaching to an instance

Quiescing an instance

Configuring the Db2 system environment

Listing and modifying the global registry

Aggregate registry variables

Configuring Db2 instances and databases

The Db2 database manager configuration

The Db2 database configuration

DB2 autonomic computing features

Self-Tuning Memory Manager (STMM)

Automatic storage

Creating storage groups

Altering storage groups

Dropping storage groups

A word about Db2 workload manager (WLM)

The WLM objects

Workloads

Thresholds

Work action and work class sets

Histogram templates

A word about IBM Data Server Manager (DSM)

Summary

Practice questions

Solutions

Physical Design

Database planning

Creating a Db2 database

Enabling automatic storage

Buffer pools

Buffer pool planning

Creating a buffer pool

Altering a buffer pool

Storage groups

Storage group planning

Altering storage groups

Renaming a storage group

Dropping a storage group

Tablespaces

Containers

Tablespace planning

Creating tablespaces

Adding containers to automatic storage tablespaces

Tablespace rebalance operation

Reclaimable storage

Converting DMS tablespaces to use automatic storage

Smart disk storage management

Creating a table

Alter table

Expression-based indexes

Invalidation of database objects

Revalidation of database objects

Online table move

Tracking the execution of online table move

Online table move planning

Online table move-running changes

Copy schema procedure

Range clustering and range partitioning tables

Range clustered tables

Range clustered table planning

Range partitioned tables

Listing the data partitions

Detaching a data partition

Attaching a data partition

MDC

MQT

ITC

Db2 BLU Acceleration

Implementing BLU

BLU compression and statistics

BLU disk space management

BLU platform management

Anatomy of a columnar table

Db2 V11.1 BLU advances

db2convert

Db2 pureScale

Members

Cluster-caching facility (CF)

Shared disk storage

Cluster services and interconnect

Db2 v11.1 pureScale advances

Availability

Installation and upgrades

Management and performance

Features

Self-tuning database memory manager (STMM) in pureScale

Self-tuning CF memory in pureScale

Db2_DATABASE_CF_MEMORY (DB2 registry variable)

CF_DB_MEM_SZ (DB CFG in 4K pages)

CF_GBP_SZ, CF_LOCK_SZ, CF_SCA_SZ (DB CFG in 4K pages)

Data compression

Static row compression

Should the table be compressed?

Getting information about the compression dictionary

Building a row compression dictionary

Index compression

LOBs and XML compression

Temporary tables and replication support

Adaptive compression

SQL compatibilities

Compatibility features for Netezza

Summary

Practice questions

Solutions

Implementing Business Rules

Business rules

NOT NULL constraints

DEFAULT constraints

CHECK constraints

UNIQUE constraints

NOT ENFORCED informational constraints

Referential integrity constraints

The INSERT rule for referential constraints

The update rule for referential constraints

The delete rule for referential constraints

The SET INTEGRITY statement

Views with CHECK OPTION

Creating and using triggers

The system catalog views

Summary

Practice questions

Answers

Monitoring Db2 Activity

Monitoring infrastructure

Monitoring table functions

Monitoring system information

Monitoring activities

Monitoring data objects

Monitoring locks

Monitoring system memory

Monitoring the pureScale environment

Additional monitoring table functions

Monitoring table functions: a quick reference

Administrative views for monitoring

A word about the MONREPORT module

Event monitors

EXPLAIN facility tools

A word about the EXPLAIN operators

Db2 troubleshooting tools

The db2pd command

The dsmtop command

Summary

Practice questions

Solutions

Db2 Utilities

Data movement file formats

Data movement utilities

The Db2 Export utility

The Db2 Import utility

The Db2 Load Utility

Phases of a load operation

Data load best practices for BLU Column-Organized Tables

Monitoring a Load operation

The DB2 Ingest Utility

Monitoring an Ingest operation

DB2 utilities comparison – Import vs. Ingest vs. Load

A word about the CATALOG STORAGE ACCESS command

Other DB2 data movement options

The SYSPROC.ADMIN_MOVE_TABLE () procedure

The SYSPROC.ADMIN_COPY_SCHEMA () procedure

Object Copy using the db2move command

A word about the db2look tool command

Database maintenance utilities

The REORGCHK utility

The REORG Utility

The RUNSTATS Utility

The REBIND Utility

Flushing the Package Cache Utility

The ADMIN_CMD () procedure

Summary

Practice questions

Answers

High Availability

Transactions and logging parameters

Transaction logging strategies

Database recovery methods

Backup and recovery

The Db2 backup utility

Incremental and delta backups

A word about hardware accelerated backup

The Db2 restore utility

The Db2 roll-forward utility

The Db2 recover utility

A word about the db2relocatedb command

High availability and disaster recovery

HADR synchronization modes

HADR-specific parameters

Setting up an HADR multiple standby environment

A word about the Db2 HA instance configuration utility (db2haicu)

Activating the RoS feature

Db2 pureScale architecture

Geographically dispersed Db2 pureScale db2cluster (GDPC)

Db2 pureScale db2cluster service command options

Explicit Hierarchical Locking

Summary

Practice questions

Answers

Db2 Security

Authentication and authorization

Authorities and privileges

Authorities

The system administrative authority (SYSADM)

The system control authority (SYSCTRL)

The system maintenance authority (SYSMAINT)

The system monitor authority (SYSMON)

The database administrator authority (DBADM)

The security administrator authority (SECADM)

The SQL administrator (SQLADM) authority

The workload management administrator authority (WLMADM)

The Explain administrator authority (EXPLAIN)

The Access control administrator authority (ACCESSCTRL)

The data access administrator authority (DATAACCESS)

The data load (LOAD) authority

Privileges

LDAP-based authentication

Role-based access control

Trusted context and trusted connections

Row and column access control (RCAC)

Row permissions

Column masks

The Db2 audit facility

Audit policies

The db2audit tool command

Secure Socket Layer (SSL) implementation in Db2

Db2 native encryption

Summary

Practice questions

Answers

Other Books You May Enjoy

Leave a review - let other readers know what you think