- Shopping Bag ( 0 items )
IBM DB2 Universal Database Version 8 for z/OS offers enterprises unprecedented opportunities to integrate information, deliver it on demand, and manage it simply and cost-effectively. Now, one of the world's leading DB2 consultants presents the definitive guide to administering DB2 UDB V8 databases in z/OS environments. DB2 for z/OS Version 8 DBA Certification Guide also serves as a key tool for anyone preparing for IBM Certified Database Administrator for DB2 Universal Database V8 for z/OS certification.
IBM Gold Consultant Susan Lawson presents hundreds of practical techniques, expert guidelines, and useful tips for every facet of DB2 UDB database administration, including database implementation, operation, recovery, security, auditing, performance, installation, migration, SQL, and more. Coverage includes
Whether you are administering DB2 UDB V8 in z/OS environments, planning to do so, or preparing for DB2 UDB V8 DBA certification, DB2 for z/OS Version 8 DBA Certification Guide will be your single most valuable resource.
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.
Data Management Tools.
Parallel Sysplex Support.
Installation and Migration.
Catalog and Directory.
3. DB2 Access and Security.
Data Set Protection.
Access to DB2 objects.
II. STRUCTURED QUERY LANGUAGE.
4. Database Objects.
Understanding Data Structures.
Managing Database Objects.
Creating Database Objects.
Database Design and Implementation.
5. Retrieving and Manipulating Database Objects.
6. Advanced SQL Coding.
Nested and Common Table Expressions.
OLAP and Star Joins.
Predicates and Filtering.
III. DATABASE ADMINISTRATION.
7. Maintaining Data.
Resolving Restrictive and Advisory States.
8. Recovery and Restart.
Database Recovery Concepts.
System-Level Backup and Recovery.
IV. DEVELOPING APPLICATIONS WITH DB2.
9. Data Sharing.
Data Sharing Components.
Maintaining Data Integrity.
Performance and Processing Costs.
Movement to Data Sharing.
10. Using SQL in an Application Program.
Delimiting SQL in a Program.
Table and View Definitions.
Host Variables and Structures.
SQL Execution Validation.
11. Binding an Application Program.
Plan or Package Ownership.
12. Application Program Features.
Commit, Rollback, and Savepoint Operations.
Global Temporary Tables.
Fetch for Limited Rows.
Multirow Fetch and Multirow Insert.
V. ADVANCED FUNCTIONS AND PERFORMANCE.
13. Stored Procedures.
Benefits of Using Stored Procedures.
Writing Stored Procedures.
Defining Stored Procedures.
SQL Procedure Language.
Developing SQL Stored Procedures.
DB2 Development Center.
14. Accessing Distributed Data.
Coding Methods for Distributed Data.
Remote Query Performance.
15. Object-Relational Functionality.
16. Locking and Concurrency.
Claims and Drains.
Locking Issues and Problems.
Designing for Concurrency.
17. SQL Optimization and Performance.
Access Paths and Optimization.
Designing Indexes and SQL for Performance.
18. DB2 Monitoring and Tuning.
Overview of Performance and Tuning.
Using Traces to Solve Problems in DB2.
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.
Answers and Chapter References.
The purpose of this book is to be used as a self-study guide for the certification test required to become an IBM Certified Database Administrator (DBA) for DB2 UDB Version 8.1. In order to become certified you must pass two exams:
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 and the topics on the 702 exam. For details on the other platforms, such as UNIX and Linux, and details needed for the 700 exam, you will need to refer to DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide by George Baklarz and Bill Wong (Prentice Hall 2003).
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. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of this book.
The book is divided into five sections:
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 detailed information about the exams, please refer to Appendix D.
Posted December 23, 2004
This is an excellent book that gives an overall picture of what to expect for the z/OS 702 Examination. The certification portions have all been covered well. Except for a few typos in a few places, this book is an excellent material and is a handy book for a DBA. I certainly recommend it to anyone wishing to pursue DB2 702 certification. -PK.GanapathyWas this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.