DB2 10.5 Fundamentals for LUW: Certification Study Guide (Exam 615)
520
DB2 10.5 Fundamentals for LUW: Certification Study Guide (Exam 615)
520Paperback(None)
-
PICK UP IN STORECheck Availability at Nearby Stores
Available within 2 business hours
Related collections and offers
Overview
Product Details
| ISBN-13: | 9781583474570 |
|---|---|
| Publisher: | MC Press, LLC |
| Publication date: | 04/11/2016 |
| Series: | DB2 DBA Certification |
| Edition description: | None |
| Pages: | 520 |
| Product dimensions: | 7.00(w) x 9.00(h) x 1.10(d) |
About the Author
Read an Excerpt
DB2 10.5 Fundamentals for LUW
Certification Study Guide (Exam 615)
By Roger E. Sanders
MC Press
Copyright © 2016 Roger E. SandersAll rights reserved.
ISBN: 978-1-58347-457-0
CHAPTER 1
IBM DB2 for Linux, UNIX, and Windows Certification
Certification has long been a popular trend in the Information Technology (IT) industry. Consequently, many hardware and software vendors — including IBM — have certification programs in place that are designed to evaluate and validate an individual's proficiency with their product offerings.
Recognized throughout the world, the IBM Professional Certification Program offers a wide variety of certification options for IT professionals who want to demonstrate their knowledge and expertise with a particular IBM product. And if you regularly use IBM hardware, software, or both, chances are you have heard of this program and have thought about becoming IBM certified. But, are you aware that IBM has more than 275 different certification roles to choose from? More important, do you know which certification role is right for you? And, do you know how to prepare for and take the certification exams that are required for the certification role you wish to pursue?
This chapter is designed to provide you with answers to these and other questions. It begins by introducing you to the certification roles that have been defined for individuals who use IBM's DB2 for Linux, UNIX, and Windows (DB2 for LUW) Information Management software. Then, it shows you how to prepare for the DB2 certification tests, and it concludes with a discussion on how to navigate the testing software that IBM uses to administer most of its exams.
DB2 10.1 and 10.5 for LUW Certification Roles
The IBM Professional Certification Program consists of several distinct certification roles that are designed to guide you in your professional development. To obtain a particular certification, you simply select the role you wish to pursue (based on your knowledge and experience working with a particular IBM product), familiarize yourself with the requirements that have been defined for that role, and then take the necessary certification exam(s) for the role you have chosen. This book focuses on the IBM Certified Database Associate — DB2 10.5 Fundamentals for LUW role (as well as the exam you must take and pass to obtain this certification); however, two DB2 Version 10.5 and three DB2 Version 10.1 for LUW certification roles are currently available. They are:
• IBM Certified Database Associate — DB2 10.1 Fundamentals
• IBM Certified Database Associate — DB2 10.5 Fundamentals for LUW
• IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX, and Windows
• IBM Certified Database Administrator — DB2 10.5 for LUW Upgrade from DB2 10.1
• IBM Certified Advanced Database Administrator — DB2 10.1 for Linux, UNIX, and Windows
IBM Certified Database Associate — DB2 10.1 Fundamentals
The IBM Certified Database Associate — DB2 10.1 Fundamentals certification is intended for entry-level DB2 users who are knowledgeable about the basic concepts of DB2 10.1 for Linux, UNIX, and Windows and DB2 10 for z/OS. In addition to having some hands-on experience or training (either formal or informal) on DB2 10 for z/OS or DB2 10.1 for LUW, individuals seeking this certification should:
* Know which DB2 10 and 10.1 products are available, as well as the function of each product (at a high level)
* Know which DB2 10 and 10.1 product to use for a given type of database workload (online transaction processing [OLTP], decision support system [DSS], or data warehouse)
* Know how to store and manipulate nonrelational data, such as large objects (LOBs) and Extensible Markup Language (XML) documents
* Possess an in-depth knowledge about the authorities and privileges that can be used to protect databases and data against unauthorized access and modification
* Know how to grant and revoke authorities and privileges
* Possess a basic understanding of Row and Column Access Control (RCAC)
* Possess a basic understanding of roles and trusted contexts
* Know how to create and connect to DB2 servers and databases
* Know how to create, access, and manipulate basic DB2 objects, such as tables, indexes, and views
* Know how and when to create system-period, application-period, and bitemporal temporal (time-travel) tables
* Possess an in-depth knowledge of Structured Query Language (SQL), as well as an understanding of the Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) statements that are available with DB2
* Know how to sort and group data
* Possess a strong understanding of transactions and know what constitutes a transaction boundary
* Know how to create and invoke SQL procedures and SQL user-defined functions (UDFs), as well as how to pass parameters to and retrieve results from SQL procedures and SQL UDFs
* Possess a basic knowledge of XQuery
* Know how to query temporal (time-travel) tables
* Know how to use the various data types — including the Oracle® compatibility data types — that are available with DB2
* Know how and when to create temporary tables
* Know how and when to use the different types of constraints (NOT NULL, default, CHECK, UNIQUE, referential integrity, and informational) that are available with DB2
* Know how and when to create triggers
* Know how to use schemas
* Possess a basic understanding of the mechanisms (transactions, isolation levels, and locks) that are used to isolate the effects of transactions from one another in a multiuser environment
* Know which factors influence locking
* Know how and when to use the LOCK TABLE statement
* Be able to identify the characteristics of common DB2 locks that are used on both the Linux, UNIX, and Windows and the z/OS platform
* Be able to identify the appropriate isolation level to use for a given situation
* Know how and when to use Currently Committed semantics with the Cursor Stability isolation level
To obtain IBM Certified Database Associate — DB2 10.1 Fundamentals certification, candidates must take and pass the DB2 10.1 Fundamentals exam (Exam 610). Figure 1.1 illustrates the road map for acquiring this certification.
IBM Certified Database Associate — DB2 10.5 Fundamentals for LUW
The IBM Certified Database Associate — DB2 10.5 Fundamentals for LUW certification is intended for entry-level DB2 users who are knowledgeable about the basic concepts of DB2 10.5 for Linux, UNIX, and Windows. In addition to having some hands-on experience or training (either formal or informal) on DB2 10.5 for Linux, UNIX, and Windows, individuals seeking this certification should:
* Know which DB2 10.5 for LUW products are available, as well as the function of each product (at a high level)
* Know which DB2 10.5 for LUW product to use for a given type of database workload (online transaction processing [OLTP], decision support system [DSS], or data warehouse)
* Possess an in-depth knowledge about DB2 10.5 BLU Acceleration and when it should be used
* Know how to configure a DB2 10.5 for LUW database for analytics
* Possess a basic understanding of the Oracle compatibility features that are available with DB2 10.5 for LUW
* Possess an in-depth knowledge about the authorities and privileges that can be used to protect databases and data against unauthorized access and modification
* Know how to grant and revoke authorities and privileges
* Possess a basic understanding of Row and Column Access Control (RCAC)
* Possess a basic understanding of Label-Based Access Control (LBAC)
* Possess a basic understanding of roles and trusted contexts
* Know how to create and connect to DB2 servers and databases
* Know how to create, access, and manipulate basic DB2 objects, such as tables, indexes, and views
* Possess an in-depth knowledge of Structured Query Language (SQL), as well as an understanding of the Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) statements that are available with DB2 10.5 for LUW
* Possess an in-depth knowledge about the different types of tables that are available with DB2 10.5 for LUW
* Know how to retrieve data from a table or view
* Know how to sort and group data
* Possess a strong understanding of transactions and be able to manage transactions using COMMIT, ROLLBACK, and SAVEPOINT statements
* Know how to create and invoke SQL procedures and SQL user-defined functions (UDFs), as well as how to pass parameters to and retrieve results from SQL procedures and SQL UDFs
* Possess a basic understanding of the SQL compatibility enhancements that were added in DB2 10.5 for LUW
* Possess a basic knowledge of XML and XQuery
* Know how and when to use the various data types — including the Oracle compatibility data types — that are available with DB2 10.5 for LUW
* Be able to identify the characteristics of an existing table, view, or index
* Know how and when to create and use temporary tables
* Know how and when to create and use triggers
* Possess a basic understanding of the mechanisms (isolation levels and locks) that are used to isolate the effects of transactions from one another in a multiuser environment
* Know which factors influence locking
* Know how and when to use the LOCK TABLE statement
* Be able to identify the characteristics of DB2 locks
* Be able to identify the appropriate isolation level to use for a given situation
* Know how and when to use Currently Committed semantics with the Cursor Stability isolation level
To obtain IBM Certified Database Associate — DB2 10.5 Fundamentals for LUW certification, candidates must take and pass the DB2 10.5 Fundamentals for LUW exam (Exam 615). Figure 1.2 illustrates the road map for acquiring this certification.
IBM Certified Database Administrator — DB2 10.1 DBA for Linux, UNIX, and Windows
The IBM Certified Database Administrator — DB2 10.1 DBA for Linux, UNIX, and Windows certification is designed for experienced DB2 users who possess the knowledge and intermediate-to-advanced skills needed to perform the day-to-day administration of DB2 10.1 for Linux, UNIX, and Windows instances and databases. Along with being knowledgeable about DB2 fundamentals and having significant hands-on experience as a DB2 10.1 Database Administrator (DBA), individuals seeking this certification should:
* Know how to configure and manage DB2 servers, instances, and databases
* Know how to use the autonomic features that are available with DB2 10.1 for Linux, UNIX, and Windows
* Know how to perform administrative tasks using Data Studio
* Know how to create a new DB2 10.1 for Linux, UNIX, and Windows database
* Know how to create, access, modify, and manage DB2 database (data) objects
* Be able to convert an existing DB2 for Linux, UNIX, and Windows database to an automatic storage database
* Know how to use the ADMIN_MOVE_TABLE() procedure
* Possess a basic knowledge of DB2's partitioning capabilities
* Know how to store and manage XML data
* Be able to describe how classic and adaptive row compression works, as well as know how to enable a table or index for either type of compression
* Possess a basic knowledge of the new table features that were introduced in DB2 10.1
* Know how and when to use the multi-temperature data feature
* Know how and when to create NOT NULL, default, CHECK, UNIQUE, referential integrity, and informational constraints
* Know how and when to use the WITH CHECK OPTION clause of the CREATE VIEW statement
* Know how and when to create and use triggers
* Know how and when to use the SET INTEGRITY command
* Know how to use administrative views and SQL functions to monitor a DB2 10.1 database environment
* Possess a basic knowledge of the monitoring features available with Workload Manager
* Be able to use the auto-monitoring tools that are available with DB2 10.1
* Know how to use the DB2 Problem Determination Tool (db2pd)
* Know how to capture and analyze Explain information
* Know how to use the DB2 data movement utilities (EXPORT, IMPORT, LOAD, and db2move)
* Know how and when to use the Ingest utility
* Know how and when to use the REORGCHK, REORG, REBIND, RUNSTATS, and FLUSH PACKAGE CACHE commands
* Know how and when to use the DB2 Design Advisor
* Possess an in-depth knowledge of crash recovery, version recovery, and roll forward recovery
* Know how to perform database-level and table space-level backup and recovery operations
* Be able to configure and manage a High Availability Disaster Recovery (HADR) environment, as well as enable a standby server for read-only operations
* Possess a basic knowledge of the high availability (HA) features DB2 pureScale® provides
* Possess an in-depth knowledge of the authorities and privileges that can be used to protect databases and data against unauthorized access and modification
* Know which operations someone with Security Administrator (SECADM) authority can perform
* Possess a basic understanding of the Audit facility
* Possess a basic understanding of trusted contexts
* Possess an in-depth knowledge of RCAC
* Possess an in-depth knowledge of LBAC
* Be able to configure database connectivity
* Know how to perform a DB2 Discovery request, as well as how to prevent DB2 Discovery requests from seeing servers, instances, and/or databases
* Know how to configure a DB2 server for Lightweight Directory Access Protocol (LDAP) connectivity
Candidates who have taken and passed either the DB2 9 Family Fundamentals exam (Exam 730), the DB2 10.1 Fundamentals exam (Exam 610), or the DB2 10.5 Fundamentals for LUW exam (Exam 615) can obtain IBM Certified Database Administrator — DB2 10.1 DBA for Linux, UNIX, and Windows certification by taking (and passing) the DB2 10.1 DBA for Linux, UNIX, and Windows exam (Exam 611). All other candidates must take and pass either the DB2 10.1 Fundamentals exam (Exam 610) or the DB2 10.5 Fundamentals for LUW exam (Exam 615) and the DB2 10.1 DBA for Linux, UNIX, and Windows exam (Exam 611). Figure 1.3 illustrates the road map for acquiring IBM Certified Database Administrator–DB2 10.1 DBA for Linux, UNIX, and Windows certification.
IBM Certified Database Administrator — DB2 10.5 DBA for LUW Upgrade from DB2 10.1
The IBM Certified Database Administrator — DB2 10.5 DBA for LUW Upgrade from DB2 10.1 certification is designed for experienced DB2 for LUW users who already possess IBM Certified Database Administrator — DB2 10.1 DBA for Linux, UNIX, and Windows certification, are knowledgeable about the new features and functions that were introduced with DB2 Version 10.5, and are capable of performing the tasks required to administer DB2 10.5 for LUW instances and databases. Individuals seeking this certification should:
* Know how to configure a DB2 10.5 for LUW environment for an analytics workload
* Know which registry variables and configuration parameters are affected when BLU Acceleration is enabled
* Know how to use the autonomic features that are available with BLU Acceleration
* Know how automatic space reclamation works with BLU Acceleration
* Know how to perform administrative tasks using Data Studio 4.1
* Be able to use automated workload management when a DB2 10.5 for LUW environment has been configured for an analytics workload
* Possess a basic understanding of the seven big ideas behind DB2 10.5 BLU Acceleration
* Know how and when to create and use column-organized tables
* Possess a basic understanding of how synopsis tables are used to facilitate "data skipping"
* Know how and when to use static compression, adaptive compression, actionable (Huffman encoding) compression, value compression, and backup compression
* Know how and when to use expression-based indexes, as well as how to collect statistics on those indexes
* Possess a basic understanding of the Oracle migration and compatibility features that are available with DB2 10.5 for LUW
* Know how and when to use unique and primary key informational constraints
* Possess a basic understanding of extended row size support
* Know how and when to exclude NULL keys from indexes
* Be able to monitor dynamic prefetch requests for data in a column-organized table
* Be able to measure column data size using appropriate monitoring elements
* Be able to measure the time spent in the Columnar Data Engine (CDE) using appropriate monitoring elements
* Be able to identify a Column Table Queue (CTQ) operator in Explain output, as well as be able to describe its purpose
* Possess a basic understanding of the MON_GET_ROUTINE() monitoring table function
* Possess a basic understanding of the HADR monitoring
* Possess a basic understanding of roles and trusted contexts
* Know how to create and connect to DB2 servers and databases
* Know how to create, access, and manipulate basic DB2 objects, such as tables, indexes, and views
* Know how and when to create system-period, application-period, and bitemporal temporal (time-travel) tables
* Possess an in-depth knowledge of Structured Query Language (SQL), as well as an understanding of the Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) statements that are available with DB2
* Know how to sort and group data
* Possess a strong understanding of transactions and know what constitutes a transaction boundary
* Know how to create and invoke SQL procedures and SQL user-defined functions (UDFs), as well as how to pass parameters to and retrieve results from SQL procedures and SQL UDFs
* Possess a basic knowledge of XQuery
* Know how to query temporal (time-travel) tables
* Know how to use the various data types — including the Oracle® compatibility data types — that are available with DB2
* Know how and when to create temporary tables
* Know how and when to use the different types of constraints (NOT NULL, default, CHECK, UNIQUE, referential integrity, and informational) that are available with DB2
* Know how and when to create triggers
* Know how to use schemas
(Continues...)
Excerpted from DB2 10.5 Fundamentals for LUW by Roger E. Sanders. Copyright © 2016 Roger E. Sanders. Excerpted by permission of MC Press.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.
Table of Contents
Contents
About the Author,Acknowledgments,
Introduction,
1: IBM DB2 for Linux, UNIX, and Windows Certification,
2: Planning,
3: Security,
4: Working with Databases and Database Objects,
5: Working with DB2 Data Using SQL and XQuery,
6: Working with DB2 Tables, Views, and Indexes,
7: Data Concurrency,
Appendix A: DB2 10.5 Fundamentals for LUW Exam (Exam 615) Objectives,
Appendix B: Practice Questions,
Appendix C: Answers to Practice Questions,