Product Description

*A practical guide to DB2 z/OS database administration that is 100 percent focused on running DB2 in z/OS environments*The only comprehensive preparation guide for the IBM Certified Database Administrator for DB2 Universal Database V8 z/OS certification*Covers database planning, design, implementation, operation, recovery, security, performance, installation, migration, and more*Sample test questions help you prepare for both IBM DB2 DBA Tests 700 and 702 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.I BM 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 *Understanding the DB2 product family, architecture, attachments, and the DB2 z/OS environment*Securing enterprise-class DB2 installations and applications*Using SQL to create and manage database objects, and manipulate and retrieve information*Mastering key DBA tasks, including loading, reorganizing, quiescing, repairing, and recovering data; recovering and rebuilding indexes; and gathering statistics*Implementing data sharing in Parallel Sysplex environments*Learning the fundamentals of DB2 application development from the DBA's perspective*Leveraging advanced DB2 functions, including stored procedures and other object-relational extensions*Optimizing DB2 applications and the DB2 engine for maximum performance 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.

Product Details

• Amazon Sales Rank: #859701 in Books
• Published on: 2004-11-07
• Original language: English
• Number of items: 1
• Binding: Hardcover
• 688 pages

From the Back Cover

• A practical guide to DB2 z/OS database administration that is 100 percent focused on running DB2 in z/OS environments

• The only comprehensive preparation guide for the IBM Certified Database Administrator for DB2 Universal Database V8 z/OS certification

• Covers database planning, design, implementation, operation, recovery, security, performance, installation, migration, and more

• Sample test questions help you prepare for both IBM DB2 DBA Tests 700 and 702

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

• Understanding the DB2 product family, architecture, attachments, and the DB2 z/OS environment

• Securing enterprise-class DB2 installations and applications

• Using SQL to create and manage database objects, and manipulate and retrieve information

• Mastering key DBA tasks, including loading, reorganizing, quiescing, repairing, and recovering data; recovering and rebuilding indexes; and gathering statistics

• Implementing data sharing in Parallel Sysplex environments

• Learning the fundamentals of DB2 application development from the DBA's perspective

• Leveraging advanced DB2 functions, including stored procedures and other object-relational extensions

• Optimizing DB2 applications and the DB2 engine for maximum performance

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.

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).

Excerpt. © Reprinted by permission. All rights reserved.
PREFACE

This book is a complete guide to IBM's relational database server, known as DB2 Universal Database Version 7.1 for OS/390 and z/OS. In order to understand the DB2 family and all of the options you have for implementation, you need to be familiar with the fundamentals of all platforms. This book covers DB2 UDB for OS/390 and z/OS; for details on the other platforms, you will need to refer to the other certification guides. Perhaps you are planning to become certified, or you would simply like to understand the powerful new DB2 UDB database servers from IBM and the capabilities of DB2 for OS/390 and z/OS. 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 four parts: Part 1—Introduction to DB2 UDB for OS/390 and z/OS (Chapters 1-3). The family of DB2 products, the DB2 environment, and access controls are covered in Chapters 1, 2, and 3. Part 2—Using SQL (Chapters 4-6). The Structured Query Language (SQL) and database objects are -discussed in Chapters 4, 5, and 6. Part 3—DB2 UDB Database Administration for OS/390 and z/OS (Chapters 7-10). DB2 UDB for OS/390 and z/OS common administration tasks and recovery issues are discussed in Chapters 7 and 8. Chapter 9 covers the architecture and implementation of data sharing in a parallel sysplex environment. Database monitoring and performance considerations are discussed in Chapter 10.Part 4—Developing Applications with DB2 (Chapters 11-14). An introduction to application development for DBAs is given in Chapter 11. Chapter 12 deals with some of the additional considerations for application development. Many of the advanced functions and object relational extensions are covered in Chapter 13. Chapter 14 covers issues surrounding locking and concurrency.

This book can be used as a self-study guide to help you prepare for the DB2 Universal Database V7.1 for OS/390 and z/OS certification exam or simply as a guide to DB2 Universal Database V7.1 for OS/390 and z/OS. For information about the DB2 UDB Family, refer to the other certification books.

Customer Reviews

This is not enough to pass the exam.......
I have taken this exam 516 twice and each time I failed to clear the exam by 1-2 marks. First time I scored 59% and next time 61%, the pass mark is 63%. I must say that I was so close by reading this book alone, but I strongly feel that it is not very comprehensive for clearing the exam.

However, I am preparing again , and this time I am reading most from the on-line IBM manuals, which are very good.The book does not cover some of the topics such as application development, DSN commands, Security etc, in depth , which make quite a substantial portion of exam.

Unfortunatley neither the questions in the book nor in the sample exams at IBM's site give you a real feel, what they are going to ask! Further, I feel that the book as a "Certification Guide" is nowhere near to the actual exam. It does not give a feel as what % of questions will be expected from each chapter or some kind of distribution. Sample questions should be after each chapter for better preparation.

In spite of all these shortcomings, I must confess that this book was very good to cover most of the topics but one has to read the manuals in order to really pass the exam.

As the title says : It is just a guide !
It gives you a whole vision of DB2 V7 for OS/390 and Z/OS but it doesn't go into details (Of course none books can do it ) Use it at a reference book , and when needing more details take the IBM manuals (Just to add that text of this book often come from the IBM manuals parts) !
If you passed the 69 tests questions provided in the book for 516 the exam, you can then enroll for the test , because it is quite the same level. The sample tests give you the idea of the questions.

DB2 UDB V7.1 for OS/390 Certification Guide
I would not classify this text as a true "Certification Guide" for DB2 for OS/390, but it has much more than some other books that I have read. I was expecting a bit more depth from the authors, who have a high reputation in the DB2 world. It gives a great overview of the subject, but failed to delve into some of the areas that a "Certification Guide" should have. I would hope the authors would write a true "Guide" to provide a complete background for DB2 DBAs and those who wish to train to become one.