万本电子书0元读

万本电子书0元读

顶部广告

IBM Db2 11.1 Certification Guide电子书

售       价:¥

103人正在读 | 0人评论 6.2

作       者:Mohankumar Saraswatipura,Robert (Kent) Collins

出  版  社:Packt Publishing

出版时间:2018-06-28

字       数:58.0万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:此类商品不支持退换货,不支持下载打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
Mastering material for dealing with DBA certification exams About This Book ? Prepare yourself for the IBM C2090-600 certification exam ? Cover over 50 Db2 procedures including database design, performance, and security ? Work through over 150 Q&As to gain confidence on each topic Who This Book Is For The IBM Db2 11.1 Certification Guide is an excellent choice for database administrators, architects, and application developers who are keen to obtain certification in Db2. Basic understanding of Db2 is expected in order to get the most out of this guide. What You Will Learn ? Configure and manage Db2 servers, instances, and databases ? Implement Db2 BLU Acceleration and a DB2 pureScale environment ? Create, manage, and alter Db2 database objects ? Use the partitioning capabilities available within Db2 ? Enforce constraint checking with the SET INTEGRITY command ? Utilize the Db2 problem determination (db2pd) and dsmtop tools ? Configure and manage HADR ? Understand how to encrypt data in transit and at rest In Detail 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. Style and approach A comprehensive certification preparation guide for the C2090-600 exam, covering all the topics in greater detail and with sample questions and answers at the end of each chapter.
目录展开

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

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部