Cargando…
IBM Db2 11. 1 Certification Guide : Explore Techniques to Master Database Programming and Administration Tasks in IBM Db2.
This guide will help you understand Db2 v11.1 DBA certification topics. It covers more than 50 step-by-step procedures for DBAs, all of Db2 v11.1's new features, and its benefits in the real world. This book can also be used to enhance the Db2 skill set.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing Ltd,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Title Page; Copyright and Credits; Packt Upsell; Foreword; Contributors; Table of Contents; Preface; Chapter 1: 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; Chapter 2: 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 upgradingUpgrading 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; Chapter 3: 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 tablespacesTablespace 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 partitionsDetaching 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.