DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) (DB2 DBA Certification) - Softcover

Sanders, Roger E.

Softcover

ISBN 10: 158347482X ISBN 13: 9781583474822

Verlag: MC Press, LLC, 2016

Inhaltsangabe

Roger E. Sanders, a leading DB2 author and an active participant in the development of DB2 certification exams, covers everything a reader needs to know to take and pass the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 certification exam. This set of study notes takes the reader through each of the topics: DB2 server management; physical design; monitoring DB2 activity; high availability; and utilities. In addition, this book contains a complete practice exam with 60 questions, which closely models the actual 311 exam, along with a detailed answer key.

Über diesen Titel

Über die Autorin bzw. den Autor

Roger E. Sanders is a DB2 for LUW Offering Manager at IBM. He has been working with DB2 for Linux, UNIX, and Windows (DB2 for LUW) since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition) and is the author of 24 books on relational database technology.

Auszug. © Genehmigter Nachdruck. Alle Rechte vorbehalten.

DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Certification Study Notes (Exam 311)

By Roger E. Sanders

MC Press

Copyright © 2016 Roger E. Sanders
All rights reserved.

ISBN: 978-1-58347-482-2

Contents

About the Author, 
Introduction, 
Part 1: DB2 10.5 Overview, 
Part 2: DB2 Server Management, 
Part 3: Physical Design, 
Part 4: Monitoring DB2 Activity, 
Part 5: High Availability, 
Part 6: Utilities, 
Appendix A: DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam (Exam 311) Objectives, 
Appendix B: Practice Questions, 
Appendix C: Answers to Practice Questions, 

CHAPTER 1

DB2 10.5 Overview

A brief overview of some of the new features and functionality introduced with DB2 10.5 for Linux, UNIX, and Windows.

DB2 10.5 With BLU Acceleration Design Principles

DB2 10.5 with BLU Acceleration was designed around the following seven "big ideas":

1. Simple to implement and use

• "It's just DB2 and standard SQL"

• Load data and start getting the performance gains of DB2 with BLU Acceleration immediately

2. Compute-friendly encoding and compression

• "Always on" compression with approximate Huffman encoding

• Encoded values do not need to be decompressed during evaluation

3. Multiply the power of the CPU

• Takes advantage of special hardware instructions to work on multiple data elements with a single instruction (SIMD)

4. Column data store

• Minimal I/O

· I/O is only performed on the columns and values that match query predicates

· As queries progress through a pipeline, the working set of pages is reduced

• Work performed directly on columns

· Predicates, joins, scans, etc. all work on individual columns

· Rows are not materialized until absolutely necessary to build a result data set

• Improved memory density

· Columnar data is kept compressed in memory

• Extreme compression

· More data values can be packed into a very small amount of memory or disk space

• Cache efficiency

· Data is packed into cache-friendly structures

5. Core-friendly parallelism

• Designed to take advantage of the cores available and to always drive multi-core parallelism when processing queries

· Maximizes CPU cache

6. Scan-friendly memory caching

· New algorithms cache data in RAM more effectively

· Higher percentage of interesting data fits in memory

· Enhanced caching strategy improves buffer pool utilization

7. Data skipping

· Automatic detection and avoidance of large sections of data that is not needed to resolve a query

· Order of magnitude savings in I/O, RAM, and CPU

· No user action required to define or use – truly invisible

What Else Is New In DB2 10.5?

In addition to BLU Acceleration, DB2 10.5 offers the following new features and functionality:

* Simplified product packaging
* Simplified Fix Pack installs
* Enhanced tooling
* Extended row size support
* Expression-based indexes
* Ability to exclude NULL index keys
* NOT ENFORCED primary keys and unique constraints
* DB2 Advanced Copy Services (ACS) scripting for snapshot backup and restore operations
* Online topology changes to DB2 pureScale clusters
* Explicit hierarchical locking in DB2 pureScale environments
* Workload balancing on subsets of DB2 pureScale members (multi-tenancy)
* In-place table REORGs in DB2 pureScale environments
* Member-specific self-tuning memory manager (STMM) in DB2 pureScale environments
* Mobility of backup images between DB2 10.5 Enterprise Server Edition and DB2 pureScale
* Support for HADR in DB2 pureScale environments

CHAPTER 2

DB2 Server Management

Seventeen percent (17%) of the DB2 10.5 Database Administration for LUW Upgrade Exam (Exam 311) is designed to test your knowledge of basic DB2 10.5 server management.

Servers, Instances, and Databases

DB2 for Linux, UNIX, and Windows (otherwise known as DB2 for LUW) sees the world as a hierarchy of objects. Servers occupy the highest level of this hierarchy, instances occupy the second level, and databases make up the third.

DB2 Servers, Instances, and Databases – Illustrated

Configuring The DB2 Server Environment

The behavior of a DB2 server is controlled, in part, by a collection of environment variables, whose values are stored in the following profile registries:

* The DB2 Global Level Profile Registry
* The DB2 Instance Level Profile Registry
* The DB2 Instance Node Level Profile Registry

The contents of each of these profile registries can be examined using the db2set command; this command is also used to assign values to profile registry variables.

Configuring DB2 Instances

The behavior of a DB2 instance is controlled, in part, by a special configuration file. This file consists of several different parameters; the values assigned to each parameter can be viewed or altered using the following commands:

* GET DATABASE MANAGER CONFIGURATION
* UPDATE DATABASE MANAGER CONFIGURATION
* RESET DATABASE MANAGER CONFIGURATION

Configuring DB2 Databases

As with DB2 instances, the behavior of a DB2 database is controlled, in part, by a special configuration file. This file consists of more than 100 different parameters and the value assigned to each parameter can be viewed or modified using the following commands:

* GET DATABASE CONFIGURATION
* UPDATE DATABASE CONFIGURATION
* RESET DATABASE CONFIGURATION

Configuring a DB2 10.5 Database Environment For BLU Acceleration

The easiest way to configure a DB2 10.5 database environment for BLU Acceleration is by assigning the value ANALYTICS to the DB2_WORKLOAD registry variable before any databases are created. For example:

db2set DB2_WORKLOAD=ANALYTICS

Assigns appropriate values to a set of configuration parameters to enable DB2 10.5 BLU Acceleration

Behavior When DB2_WORKLOAD Is Set To ANALYTICS

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS:

* The dft_table_org (default table organization for user tables) database configuration parameter is set to COLUMN.

* The dft_degree (default degree of intrapartition parallelism) database configuration parameter is set to ANY.

* The pagesize (default database page size) database configuration parameter is set to 32 KB.

* The dft_extent_sz (default extent size) database configuration parameter is set to 4.

* The intra_parallel (use intrapartition query parallelism) database manager configuration parameter is set to YES.(Intrapartition parallelism is turned on at the instance level; however, this behavior does not take effect until the instance is stopped and restarted.)

* The values of the sortheap (sort heap) and sheapthres_shr(sort heap...

Details zur Ausgabe

• Verlag: MC Press, LLC
• Erscheinungsdatum: 2016
• Sprache: Englisch
• ISBN 10: 158347482X
• ISBN 13: 9781583474822
• Einband: Taschenbuch
• Anzahl der Seiten: 144
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar