DB2® for z/OS® Version 8 DBA Certification Guide [Hardcover]

Susan Lawson (Author)

Book Description

Publication Date: November 7, 2004 | ISBN-10: 0131491202 | ISBN-13: 978-0131491205 | Edition: 1

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

Editorial Reviews

From the Back Cover

• IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide!
• The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide
• Covers administration, security, SQL, application development, tuning, and much more
• Contains dozens of expert DB2 tips, techniques and guidelines
• CD-ROM contains complete DB2 for OS/390 sample exam

Written by IBM Gold Consultants for DB2 and S/390

• The total resource for every professional running DB2 UDB V7.1 in OS/390 and z/OS environments
• Database administration, security, monitoring, tuning, SQL, and application development
• Sample test questions help you prepare for IBM's new DB2 UDB V7.1 for OS/390 exams

The CD-ROM included with this book contains a complete IBM DB2 for OS/390 certification sample exam.

IBM's DB2 Universal Database Version 7.1 for OS/390 delivers unparalleled performance, scalability, and reliability in today's enterprise e-business environments! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for IBM's updated DB2 UDB V7.1 for OS/390 certification exam!

Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 and z/OS environments is also the only book with the in-depth knowledge professionals need in order to pass IBM's latest DB2 for OS/390DBA certification exam. Full of expert tips, techniques, and guidelines, it covers virtually every aspect of working with DB2 UDB in enterprise server: administration, connectivity, development, and much more.

IBM Gold Consultants Richard Yevich and Susan Lawson present start-to-finish coverage of DB2's latest and most powerful enhancements, tools, and utilities, showing how to make the most of DB2 running on both OS/390 and next-generation z/OS platforms. Coverage includes:

• An overview of the DB2 UDB product family
• DB2 in OS/390 and z/OS environments: address spaces, attachments, interfaces, commands, and utilities
• Comprehensive security coverage, including access controls and auditing techniques
• SQL in depth: DB2 data structures, database objects, basic database design, and advanced coding
• DB2 UDB administration: maintaining data, backup/recovery, and more
• Performance monitoring and optimization: access paths, indexes, parallelism, buffer pool tuning, and subsystem tuning
• Data sharing: architecture and implementation in a Parallel Sysplex environment
• Detailed application development coverage: database extenders, cursors, stored procedures, triggers, object-relational extensions, locking, and concurrency

Whether you're deploying DB2 UDB V7.1 in an OS/390 environment, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, DB2 Universal Database Version 7.1 for OS/390 Certification Guide will be your single most valuable resource.

--This text refers to an out of print or unavailable edition of this title.

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

See all Editorial Reviews

Product Details

• Hardcover: 688 pages
• Publisher: IBM Press; 1 edition (November 7, 2004)
• Language: English
• ISBN-10: 0131491202
• ISBN-13: 978-0131491205
• Product Dimensions: 9.5 x 7.2 x 1.4 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.4 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #1,128,365 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

3.0 out of 5 stars This is not enough to pass the exam......., December 6, 2001

By 

Sanjay Jha (Toronto) - See all my reviews
(REAL NAME)   

This review is from: DB2(R) Universal Database for OS/390 v7.1 Certification Guide (IBM (Prentice Hall)) (Paperback)

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.

3 of 3 people found the following review helpful:

4.0 out of 5 stars As the title says : It is just a guide !, March 13, 2002

By 

ndt98 "ndt98" (Europe) - See all my reviews

Amazon Verified Purchase

This review is from: DB2(R) Universal Database for OS/390 v7.1 Certification Guide (IBM (Prentice Hall)) (Paperback)

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.

3 of 3 people found the following review helpful:

3.0 out of 5 stars DB2 UDB V7.1 for OS/390 Certification Guide, December 9, 2001

By 

Claude Wright (Pasadena, Maryland United States) - See all my reviews

This review is from: DB2(R) Universal Database for OS/390 v7.1 Certification Guide (IBM (Prentice Hall)) (Paperback)

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.