DB2 For The z/OS Version 8 DBA Certification Guide - Hardcover

Lawson, Susan

Hardcover

ISBN 10: 0131491202 ISBN 13: 9780131491205

Publisher: IBM Pr, 2004

Synopsis

• 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 this title

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

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

Edition details

• Publisher: IBM Pr
• Publication date: 2004
• ISBN 10: 0131491202
• ISBN 13: 9780131491205
• Binding: Hardcover
• Language: English
• Edition number: 2
• Number of pages: 660