DB2(R) Universal Database for OS/390 v7.1 Certification Guide (IBM (Prentice Hall)) [Paperback]

Richard Yevich (Author), Susan Lawson (Author)

Book Description

Series: IBM (Prentice Hall) | Publication Date: August 13, 2001

Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 environments is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging DB2 for OS/390 certification exam. Full of useful tips, practical techniques, and expert guidelines, it covers virtually every aspect of working with DB2 UDB in OS/390 and z/OS environments: administration, connectivity, middleware, development, and much more. Richard Yevich and Susan Lawson begin with a detailed introduction to the DB2 UDB product family, the DB2 environment, and essential DB2 access controls, including subsystem access, access to DB2 objects, and auditing. In Part II, the authors introduce SQL, reviewing data structures, database objects, basic database design, and advanced SQL techniques for OLAP and other applications. Yevich and Lawson present in-depth coverage of DB2 UDB administration: maintaining and sharing data; database monitoring, tuning, and recovery; and more.

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.

About the Author

RICHARD YEVICH and SUSAN LAWSON are internationally recognized database consultants and principals of YL&A, Inc., an international firm specializing in consulting, performance audits and development of some of the world's largest and most complex databases. They are IBM Gold Consultants for DB2 and S/390. They are co-authors of DB2 Answers! and DB2 High Performance Design and Tuning. Both are award-winning speakers and are active authors in many trade journals.

See all Editorial Reviews

Product Details

• Paperback: 672 pages
• Publisher: Prentice Hall PTR (August 13, 2001)
• Language: English
• ISBN-10: 0130650765
• ISBN-13: 978-0130650764
• Product Dimensions: 9.3 x 7 x 1 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 3.4 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #3,110,168 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.