After a long delay, I can finally announce that this long awaited book has published.
DB2 10 for z/OS Database Administration: Certification Study
by IBM Champions Susan Lawson and Daniel Luksetich
I can also tell you that the covers for the certification series of books by MC Press have been redesigned and will be launched on this title. I hope you like the new design.
What’s in the book?
- Read this book to prepare to pass Exam 612 – DB2 10 for z/OS Database Administration.
- All test objectives for this exam are covered in the same degree as they are covered on the exam.
- Susan and Dan were members of the exam development team, so are fully aware as to what questions are on the exam!
- Susan and Dan use DB2 every day and have 22 years experience.
DB2 10 for z/OS Database Administration: Certification Study Guide is
the definitive guide to preparing for IBM’s Certification Exam 612: DB2 10 for
z/OS Database Administration. This book provides a comprehensive review of all
the topics covered on the exam and introduces you to important new features
found in DB2 10 for z/OS.
Written by two industry experts who were members of the team that created the
612 exam, this book guides you through all the areas you need to know about to
pass the exam: Database Design and Implementation, Operation and Recovery,
Security and Auditing, Performance, and Installation and Migration/Upgrade.
At the end of each chapter, you’ll find practice questions with answers to help you review that chapter’s material. The book concludes with a comprehensive 85-question practice exam (plus detailed answers) that lets you verify what you’ve learned.
Beyond certification prep, the book covers new Version 10 features for both database and application development. It also includes a wealth of practical details about working with DB2 for z/OS, tips for best performance and best practices, and loads of examples illustrating usage of DB2. It will serve both as an essential tool for studying for exam 612 as well as a reference guide that all DB2 for z/OS DBAs will want on their desktops.
With DB2 10 for z/OS Database Administration: Certification Study Guide, you will:
- Learn how to effectively administer a DB2 10 for z/OS database
- Discover the changes to DB2 for z/OS in Version 10 that you’ll need to know about to be successful when taking exam 612, and the pre-requisite Exam 730
- Receive an explanation of every objective on the test. . .from people involved in the creation of the actual exam
- Find 85 practice questions based on the actual exam’s format and approach, with detailed answers to help you gain understanding
While the book does cover all topics on the test, it also covers much more than that. It covers the new features of DB2 10 for both database and application development.
What do you need to know to pass the exam?
This is an outline of the Exam Objectives that this book covers:
Section 1 - Database Design and Implementation (30.5%)
• Design tables and views
• Explain the different performance implications of
• Design indexes
• Create and alter objects
• Perform table space and index partitioning
• Normalize data and translate data model into physical model
• Implement user-defined integrity rules
• Use the appropriate method to create and alter DB2 objects
• Encoding schemes
Section 2 - Operation and Recovery (29%)
• Issue database-oriented commands for normal operational conditions
• Issue database-oriented commands and utility control statements for use in abnormal conditions
• Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically
• Load and unload data into and from the created tables
• Reorganize objects when necessary
• Monitor the object by collecting statistics
• Monitor threads
• Identify and respond to advisory/restrictive statuses on objects
• Establish timely checkpoints
• Identify and perform problem determination
• Perform health checks
• Develop backup scenarios
• Describe the special considerations for availability in a data sharing environment
Section 3 - Security and Auditing (7%)
• Protect DB2 objects
• Protect connection to DB2
Section 4 - Performance (29%)
• Plan for performance monitoring by setting up and running monitoring procedures
• Analyze performance
• Analyze and respond to RUNSTATS statistics analysis
• Determine when and how to run the REORG utility
• Understand and implement Real-Time Statistics & DSNACCOR(X)
• Analyze cache
• Evaluate and set appropriately the performance parameters for different utilities
• Describe the performance concerns for the distributed environment
• Describe DB2 interaction with WLM
• Interpret traces (statistics, accounting, performance) and explain the performance impact of different DB2 traces
• Identify and respond to critical performance thresholds
• Excessive I/O wait times
• Identifying lock-latch waits and CPU waits
• Identifying and resolving deadlocks and timeouts
• Review and tune SQL
• Dynamic SQL Performance
• Performance Features
Section 5 - Installation and Migration/Upgrade(4.5%)
• Run catalog health checks using queries and utilities
• Identify the critical DSNZPARMs
• Identify the migration/upgrade modes
• Identify and explain data sharing components and concepts
About the Authors:
Susan Lawson is an internationally recognized consultant and
lecturer with a background in system and database administration. She currently
works with several large clients to help develop, implement, and tune some of
the world’s largest and most complex DB2 databases and applications. Susan also
conducts performance and availability audits to help clients reduce costs
through proper performance tuning and ensure availability. She also writes
articles and white papers, presents at user group meetings, and teaches a
variety of DB2 courses. Susan is an IBM GOLD Consultant for DB2 and System z and
an IBM Champion.
Daniel Luksetich is a DB2 database professional with more than 26 years of experience in high-performance design and tuning of very large databases and highly available, high-volume database applications. He also teaches DB2 courses and has authored books, guides, whitepapers, and magazine articles. Working as a DB2 application architect, Dan has been involved in several very large DB2 application designs. An IBM Champion, Dan specializes in DB2 for z/OS but has worked with DB2 on a variety of platforms. His specialties include performance audits, SQL education, backup and recovery, stored procedures, UDFs, triggers, application design, high-availability design, and DB2 high performance.
PS, for all my z/OS friends, check out this new BLOG that focuses on technical information that will interest you: DB2 for z/OS Exchange Forum