DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide (3rd Edition) [Paperback]

Jonathan Cook (Author), Robert Harbus (Author), Tetsuya Shirai (Author)

Book Description

ISBN-10: 0130867551 | ISBN-13: 978-0130867551 | Publication Date: November 15, 1999 | Edition: 3rd

This is IBM's definitive guide to the newest version of DB2 Universal Database. It contains end-to-end coverage for every DB2 developer and administrator -- and for anyone who wants to achieve IBM DB2 certification. Start with a detailed overview of the DB2 family of products, key DB2 concepts, and terminology. Next, walk through installing DB2, setting up DB2 clients (including ODBC support); and controlling data access through authentication, assigned authorities, and user/group privileges. Understand DB2 SQL in depth, including database objects, the Data Definition Language (DDL), triggers, outer joins, OLAP SQL, table hierarchies, and concurrency. Master DB2 administration, including the optimal physical placement of data; populating DB2 tables with IBM's import and load utilities; monitoring, maintenance and tuning; logging; and database recovery. Finally, master the basics of DB2 application development. Review each programming method and interface provided by DB2; master embedded SQL; even learn the basics of CLI, ODBC, JDBC, and ADO.

Editorial Reviews

From the Back Cover

• The #1 guide and reference for IBM's powerhouse DB2 UDB V6.1 database
• New DB2 UDB V6.1 features for all platforms: UNIX, Windows, and OS/2!
• Complete coverage for database administrators and application developers!
• Sample test questions to assist in your preparation for IBM's new DB2 UDB V6.1 certification exams

IBM's DB2 Universal Database Version 6.1 for UNIX, Windows, and OS/2 delivers unprecedented power, scalability, e-business support, and much more! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V6.1 - and preparing for IBM's updated DB2 V6.1 certification exams!

This is IBM's definitive guide and reference for the newest, most powerful version of DB2 Universal Database ever: Version 6.1. DB2 Universal Database Version 6.1 for UNIX, Windows and OS/2 Certification Guide, Third Edition delivers end-to-end coverage for every DB2 developer and administrator, on every platform: Windows, UNIX, or OS/2 - including the most systematic IBM DB2 certification review you can find.

IBM DB2 experts present a detailed overview of the DB2 UDB family of products, key DB2 concepts, and terminology, plus in-depth coverage of installation, configuration, networking, security, application development, data integrity, optimization, and more. Coverage includes:

• DB2 administration: populating tables with import and load utilities, monitoring, logging, maintenance, and tuning
• Security: Controlling data access through authentication, assigned authorities, user/group privileges, and more
• Database backup and recovery, step-by-step
• DB2 SQL, in depth: database objects, Data Definition Language (DDL), Data Manipulation Language (DML), triggers, outer joins, OLAP SQL, table hierarchies, concurrency, and embedded SQL
• Database access techniques using ODBC, JDBC, and ADO

Whether you're deploying DB2 UDB V6.1, managing DB2 UDB V6.1, preparing for DB2 UDB V6.1 certification, or all three, DB2 Universal Database Version 6.1 for UNIX, Windows, and OS/2 Certification Guide, Third Edition will be your single most valuable resource.

About the Author

Jonathon Cook and Tetsuya Shirai are software professionals at IBM's International Technical Support Organization, Austin, TX.

Product Details

• Paperback: 1020 pages
• Publisher: Prentice Hall PTR; 3rd edition (November 15, 1999)
• Language: English
• ISBN-10: 0130867551
• ISBN-13: 978-0130867551
• Product Dimensions: 9.2 x 7 x 1.8 inches
• Shipping Weight: 3.1 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #4,466,450 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

35 of 37 people found the following review helpful:

5.0 out of 5 stars A worthy update., December 9, 1999

By A Customer

Amazon Verified Purchase

This review is from: DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide (3rd Edition) (Paperback)

This book is a significant enhancement to the previous edition that covered DB2 UDB Version 5. The book provides good overviews of post-V5 feature additions, including DB2 Satellite Edition, Data Links Manager, the Audit Facility and Query Patroller. Recent additions to DB2 SQL, like table functions, structured types, typed tables and summary tables, are also well covered. The coverage of structured types and typed tables, some of the newer DB2 object-relational features, is particularly good.

It is rare to find so much detailed, hard technical knowledge, well presented, between the pages of a single book. Almost all of the good detail of the previous edition is preserved and added to. This edition is over 200 pages longer than its predecessor.

This book is a good complement to Don Chamberlin's excellent "A Complete Guide to DB2". It is not as easy to read (it is a study guide after all), but does provide more detail on the database administration side.

If you are studying for your IBM DB2 certification exams, or if you are or wish to become a hard-core DB2 user, this book would be a welcome addition to your library.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Required Reading, March 12, 2000

By 

V. Grund (Amherst, NH) - See all my reviews
(REAL NAME)   

This review is from: DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide (3rd Edition) (Paperback)

This book should be your first stop if you're new to DB2, and it is a welcome addition an old pro's library. This is a worthy update from the V5 Certification Guide, both in terms of readability and additional content. DB2's product documentation has most everything you'll need day-to-day, but it is quite dense. This book helps clarify the main points and will act as a useful reference and supplement to the product documentation.

5.0 out of 5 stars Passed 512 no sweat with this book, April 10, 2004

By 

"aequality" (St Cloud.) - See all my reviews

This review is from: DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide (3rd Edition) (Paperback)

Make sure you read this book thorough enough. Supplement with DB2 for dummies you should be ok. I have read both version 6.1 and 7.1, i felt 6.1 has more important information than 7.1. Also, 7.1 has more incorrect sample questions and answers, so beware with the 7.1.

EQ