DB2 Universal Database for Os/390 Version 7.1 Certification Guide - Softcover

Yevich, Richard; Lawson, Susan

Softcover

ISBN 10: 0130650765 ISBN 13: 9780130650764

Publisher: Prentice Hall, 2001

Synopsis

This handbook outlines the techniques and rules related to the administration, connectivity, and development of DB2 UDB on OS/390. It presents an overview of the product family, with details concerning its tools, environments, security, structures, design, coding, application, and optimization. An accompanying CD-ROM contains a trial version of DB2 Universal Database V7.1 for Windows NT, Windows 2000, Windows 95, and Windows 98. The authors are database consultants. Annotation c. Book News, Inc., Portland, OR (booknews.com)

About this title

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.

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.

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.

Edition details

• Publisher: Prentice Hall
• Publication date: 2001
• Language: English
• ISBN 10: 0130650765
• ISBN 13: 9780130650764
• Binding: Paperback
• Number of pages: 672