Name: IBM Db2 11.1 Certification Guide
Author: Mohankumar Saraswatipura Robert Collins
ISBN: 9781788627870

微信读书书城IBM Db2 11.1 Certification Guide

首页我的书架登录

翻译完成

切换

IBM Db2 11.1 Certification Guide

Mohankumar Saraswatipura Robert Collins

扉页
版权信息
+书签
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

简介

版权

IBM Db2 11.1 Certification Guide