Now available for pre-orders: Expert Preparation for Exam 732: DB2 9 for z/OS Database Administration Certification Study Guide by Susan Lawson and Daniel Luksetich.
The book is expected to publish BEFORE the IOD conference in October despite the website saying the book publishes in November.
Book Description:DB2 9 for z/OS Database Administration Certification Study Guide is the definitive guide to preparing for the IBM Certification 732 Version 9 DBA Certification Exam. The book covers all topics on the exam and also provides a wealth of information about DB2 z/OS Version 9. It also includes a lot of practical information and tips for best performance and usage of DB2. The book is written by two industry experts who were both members of the team that created the 732 exam.
This book covers all of the topics that are on the exam: Database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. There are practice questions with detailed answers at the end of each chapter as well as an 80+ question practice exam. But beyond certification prep, it also covers the new features of version 9 for both database and application development. It will serve as an essential tool for studying for exam 732 as well as a reference that all DB2 DBAs will want on their desktops.
732 Exam Objectives Covered in the Book: * Section 1 - Database Design and Implementation* Section 2 - Operation and Recovery* Section 3 - Security and Auditing* Section 4 – Performance* Section 5 - Installation and Migration/Upgrade
Table of Contents: Preface 1. DB2 Product Fundamentals 2. Environment 3. Access and Security 4. Database Objects 5. Retrieving & Manipulating Objects 6. Advanced SQL Coding 7. Maintaining Data 8. Recovery and Restart 9. Data Sharing 10. Using SQL in an Application Program 11. Binding an Application 12. Application Program Features 13. Stored Procedures 14. Accessing Distributed Data 15. Advanced Functionality 16. Locking and Concurrency 17. Performance, Monitoring, and Tuning Appendix A: DB2 Sample Database Appendix B: Practice Exam Questions Appendix C: Practice Exam Answers