DB2 for the z/OS Version 8 Certification View Larger Image | Susan Lawson
IBM Press, Hardcover, 2nd edition, Published October 2004, 660 pages, ISBN 0131491202 | List Price: $64.99
Our Price: $50.50
You Save: $14.49 (22% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
The purpose of this book is to serve as a self-study guide for the certification
test required to become an IBM Certified Database Administrator (DBA) for DB2
Universal Database (UDB) version 8. In order to become certified, you must pass
two exams:
1. 700-IBM DB2 UDB Version 8 Family Fundamentals
2. 702-IBM DB2 UDB Version 8 for z/OS Database Administration
In order to become an IBM Certified Database Administrator, you need to be
familiar with the fundamentals of all DB2 platforms. This book covers DB2 UDB
for z/OS, especially the topics on the 702 exam. If you are planning to become
certified or would like an additional reference for information about DB2 for
z/OS version 8, this book is for you. If you are interested in becoming an IBM
Certified Professional, you will want to review the sample questions inAppendix
C. For details on the other platforms, such as UNIX and Linux, and details needed
for the 700 exam, refer to the other certification guide: DB2 Universal Database
Version 8 for Linux, UNIX, and Windows Database Administration Certification
Guide, Fifth Edition, by George Baklarz and Bill Wong (Prentice Hall, 2003).
The book is divided into five implicit sections.
1. Chapters 1-3 discuss the family of DB2 products, the DB2 z/OS environment,
and access controls.
2. Chapters 4-6 cover the Structured Query Language (SQL), and its use, such
as database objects creation, manipulation, and retrieval, as well as all DB2
database objects.
3. Chapters 7-9 describe common administration tasks and recovery issues. Chapter
9 also covers the architecture and implementation of data sharing in a parallel
sysplex environment.
4. Chapters 10-12 provide an introduction to application development for DBAs
and some of the additional considerations for application development.
5. Chapters 13-18 cover such topics as locking; advanced functions, such as
stored procedures; and other object-relational extensions. Performance and optimization
are covered in detail in Chapters 17 and 18.
This book can be used as a self-study guide to help you prepare for the DB2
Universal Database V8 for z/OS DBA certification exam or simply as a guide to
DB2 Universal Database V8 for z/OS. For information about the DB2 UDB family
or other DB2 platforms, refer to the other certification books. For detailed
information about the exams, refer to Appendix C.
Table of Contents
Foreword.
Preface.
I. DB2 FAMILY AND DB2 FOR Z/OS ENVIRONMENT.
1. Product Overview.
DB2 and the On-Demand Business.
DB2 Universal Database.
DB2 Middleware and Connectivity.
DB2 Application Development.
DB2 Administration.
Data Management Tools.
Summary.
Additional Resources.
2. Environment.
z/OS.
Address Spaces.
Security.
Parallel Sysplex Support.
DFSMS.
Interfaces.
Installation and Migration.
System Parameters.
Commands.
Utilities.
Catalog and Directory.
Distributed Data.
Subsystem Pools.
Summary.
Additional Resources.
3. DB2 Access and Security.
Subsystem Access.
Data Set Protection.
Access to DB2 objects.
Multilevel Security.
Auditing.
Summary.
Additional Resources.
II. STRUCTURED QUERY LANGUAGE.
4. Database Objects.
Understanding Data Structures.
Managing Database Objects.
Creating Database Objects.
Database Design and Implementation.
Summary.
Additional Resources.
5. Retrieving and Manipulating Database Objects.
Data Retrieval.
Data Modification.
Summary.
Additional Resources.
6. Advanced SQL Coding.
Subqueries.
Unions.
Joins.
Nested and Common Table Expressions.
CASE Expressions.
Row Expressions.
OLAP and Star Joins.
Predicates and Filtering.
Summary.
Additional Resources.
III. DATABASE ADMINISTRATION.
7. Maintaining Data.
Data Movement.
Data Maintenance.
Gathering Statistics.
Real-Time Statistics.
Statistics Usage.
Resolving Restrictive and Advisory States.
Summary.
Additional Resources.
8. Recovery and Restart.
Database Recovery Concepts.
Logging.
Image Copies.
Data Recoveries.
Disaster Recoveries.
System-Level Backup and Recovery.
DB2 Restart.
Summary.
Additional Resources.
IV. DEVELOPING APPLICATIONS WITH DB2.
9. Data Sharing.
Data Sharing Components.
Maintaining Data Integrity.
Performance and Processing Costs.
Movement to Data Sharing.
Recovery Considerations.
Summary.
Additional Resources.
10. Using SQL in an Application Program.
Delimiting SQL in a Program.
Table and View Definitions.
Host Variables and Structures.
SQL Execution Validation.
Cursors.
Dynamic SQL.
Summary.
Additional Resources.
11. Binding an Application Program.
Precompiling.
Binding.
Plan or Package Ownership.
Summary.
Additional Resources.
12. Application Program Features.
Commit, Rollback, and Savepoint Operations.
Global Transactions.
Global Temporary Tables.
Fetch for Limited Rows.
Multirow Fetch and Multirow Insert.
Identity Columns.
Sequence Objects.
Summary.
Additional Resources.
V. ADVANCED FUNCTIONS AND PERFORMANCE.
13. Stored Procedures.
Benefits of Using Stored Procedures.
Writing Stored Procedures.
Defining Stored Procedures.
Execution Environments.
SQL Procedure Language.
Developing SQL Stored Procedures.
DB2 Development Center.
Summary.
Additional Resources.
14. Accessing Distributed Data.
Distributed Data.
Coding Methods for Distributed Data.
Programming Considerations.
Remote Query Performance.
Summary.
Additional Resources.
15. Object-Relational Functionality.
Triggers.
Object-Relational Extensions.
Large Objects.
Summary.
Additional Resources.
16. Locking and Concurrency.
Locking Data.
Avoiding Locks.
Claims and Drains.
Locking Issues and Problems.
Designing for Concurrency.
Summary.
Additional Resources.
17. SQL Optimization and Performance.
Access Paths and Optimization.
Designing Indexes and SQL for Performance.
Summary.
Additional Resources.
18. DB2 Monitoring and Tuning.
Overview of Performance and Tuning.
Database Monitoring.
Using Traces to Solve Problems in DB2.
Memory Tuning.
Summary.
Additional Resources.
Appendix A. DDL for the DB2CERT Database.
Appendix B. IBM Certified Database Administrator for DB2 UDB V8 for z/OS.
DB2 UDB V8 Family Fundamentals: 700 Exam.
DB2 UDB V8 for z/OS Database Administration: 702 Exam.
Appendix C. 702 Sample Exam.
Questions.
Answers and Chapter References.
Bibliography.
Index.
About the Author
Susan Lawson is an internationally recognized consultant and
lecturer with a strong background in system and database administration. She
currently works with several clients to help development, implement, and tune
some of the world's largest and most complex DB2 databases. She is an IBM Gold
Consultant for DB2 and S/390, and an IBM Certified DBA for DB2 UDB Version 7
for z/OS. She is coauthor of DB2 High Performance Design and Tuning (Prentice
Hall, 2001) and author of DB2 Universal Database for OS/390 v7.1 Application
Certification Guide (Prentice Hall, 2002).
|
