The Official Introduction to DB2(R) for z/OS(R): Covers DB2(R) Universal Database for z/OS(R) Version 8 (2nd Edition) [Paperback]

Susan Graziano Sloan (Author)

Book Description

Publication Date: June 5, 2004 | ISBN-10: 0131477501 | ISBN-13: 978-0131477506 | Edition: 2

The Official Introduction to DB2 UDB for z/OS provides a comprehensive overview of Version 8 of the DB2 UDB for z/OS product. The book serves a dual purpose: it gives new and prospective users a solid introduction to key product features and it covers material contained in the DB2 Family Fundamental exam, the first exam in the DB2 certification series. The book explains basic relational database concepts, the basics of the structured query language (SQL), and gives a solid overview of the various user tasks that are associated with this product. It includes introductory information about designing databases, creating relational objects, managing DB2 on a day-to-day basis, and writing application programs that use DB2 data. It also introduces new users to some of the more complex capabilities of DB2, such as, DB2 in the Web environment, distributed data, and data sharing. Introductory book for the DB2 mainframe audience, parallels Baklarz audience (ISBN 0130463612). Well-written (The Society of Technical Communication recognized the first edition of this book with a Merit award in the Northern California Technical Communication Competition.) Most current coverage of Version 8 of DB2 UDB for z/OS, the single largest release of this product since its inception in 1983-- Includes 8.2

Editorial Reviews

From the Back Cover

• The complete IBM DB2 UDB for z/OS Version 8 tutorial
• The only book that covers the DB2 Fundamentals exam from a z/OS perspective
• From basic relational database concepts to advanced topics such as distributed data, Web applications, and data sharing
• For both database administrators and developers
• Written and reviewed by IBM experts at the laboratory where DB2 UDB for z/OS is developed

The definitive tutorial for new DB2 UDB for z/OS administrators and developers

This is your complete introduction to Version 8 of DB2 UDB for z/OS, the most powerful, scalable, and robust version of DB2 ever created. Here's all you need to get started with DB2 Version 8 database administration and development ... and to prepare for the new IBM DB2 Family Fundamentals exam, your first step toward DB2 certification. From basic relational database concepts to advanced topics such as data sharing, you'll find crystal-clear explanations and real-world insights, straight from the IBM lab where DB2 UDB for z/OS is developed. Coverage includes:

• DB2 UDB for z/OS and the DB2 family: overview and usage scenarios
• Data and system structures, business rules, transactions, packages, and more
• DB2 UDB for z/OS: architecture, facilities, and the z/OS Security Server
• Introduction to logical and physical database design
• Defining tables, table spaces, indexes, views, large objects, business rules, and more
• Working with SQL, the language of DB2
• Writing DB2 application programs
• Performance: caching, compression, locking/concurrency, and query optimization
• Day-to-day administration, including backup and recovery
• Web-based applications with DB2, WebSphere(R), and z/OS
• Distributing and sharing data for maximum flexibility, scalability, and availability
• Includes practice exam questions throughout the book

About the Author

SUSAN GRAZIANO SLOAN is an Advisory Software Engineer at IBM Silicon Valley Laboratory, San Jose, CA, where DB2 UDB for z/OS is developed. She has been team lead of the DB2 UDB for z/OS writing team since 2001, when she co-authored An Introduction to DB2 for OS/390, which earned a Merit Award in the Society for Technical Communication's Northern California competition.

Product Details

• Paperback: 528 pages
• Publisher: IBM Press; 2 edition (June 5, 2004)
• Language: English
• ISBN-10: 0131477501
• ISBN-13: 978-0131477506
• Product Dimensions: 9.3 x 7 x 1.5 inches
• Shipping Weight: 2.6 pounds
• Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,957,870 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

4.0 out of 5 stars The Official Introduction to DB2 for z/OS, August 14, 2006

By 

J. Wankowski "Quest Software" (Warrenville,Il) - See all my reviews
(REAL NAME)   

This review is from: The Official Introduction to DB2(R) for z/OS(R): Covers DB2(R) Universal Database for z/OS(R) Version 8 (2nd Edition) (Paperback)

This book is a good primer for anyone who is just beginning to work with DB2 for z/OS. It covers all the basic concepts well, however if you are looking for a detailed reference book, this is too basic.

5.0 out of 5 stars Superb, November 17, 2010

By 

Leon P. Stevens (Columbia MO USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: The Official Introduction to DB2(R) for z/OS(R): Covers DB2(R) Universal Database for z/OS(R) Version 8 (2nd Edition) (Paperback)

The book was in excellent condition, arrived in a very timely manner, and it was hard-bound, not soft-bound, a definite bounty.

2 of 7 people found the following review helpful:

5.0 out of 5 stars A great introduction..., June 16, 2004

By A Customer

This review is from: The Official Introduction to DB2(R) for z/OS(R): Covers DB2(R) Universal Database for z/OS(R) Version 8 (2nd Edition) (Paperback)

This book is a great introduction to a very complex product and subject. There is so much more to learn about DB2 on the z/OS platform, but this book does a fine job of getting you started.