DB2 Universal Database V8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, Fifth Edition / Edition 5

Paperback (Print)
Buy Used
Buy Used from BN.com
(Save 38%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (2) from $58.91   
  • Used (7) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2008

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.


Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2015

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


DB2 Universal Database v8 builds on the world's #1 enterprise database to simplify anytime/anywhere information integration, streamline management, automate resource tuning,enhance business intelligence, and maximize performance, scalability, and reliability.

Now, IBM offers complete, start-to-finish coverage of DB2 Universal Database v8 administration and development for UNIX, Linux, and Windows platforms... and authoritative preparation for IBM's newest DB2 certification exam.

This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database v8, including best practices for DB2 database design and development; day-to-day administration and backup; expert techniques for deploying networked, Internet-centered, and XML-based database applications; migrating to DB2 UDB v8; and much more.You'll also find an unparalleled collection of IBM tips and tricks for maximizing the performance, availability, and value of any database system. Coverage includes:

  • Manageability and serviceability enhancements, including new tools for storagemanagement and monitoring database health
  • Performance improvement withmultidimensional clustering, enhanced prefetching, threading of Java UDFs and storedprocedures, and materialized query tables
  • New Setup wizards, configuration assistants, GUItools, and DB2 Administration Server (DAS) improvements
  • Availability andscalability enhancements
  • New DB2 v8 Replication and Data Warehouse Centers
  • Major improvements for developers, including SQL, XML, JDBC, and CLIenhancements

Whether you're a DBA, a developer, a DB2 certification candidate, or all three, DB2Universal Database v8 for Linux, UNIX, and Windows Database AdministrationCertification Guide is the one book you can't afford to be without.

  • Straight from IBM, the ultimate guide to running DB2 v8 and preparing for IBM's latest DB2certification exam!
  • In-depth coverage of DB2 v8 database administration and development
  • Covers new DB2 v8 enhancements in manageability, serviceability, reliability, availability, and performance
  • Contains in-depth coverage of new DB2 v8 tools, including the Replication, Data Warehouse, and Development Centers
  • Presents expert tips and best practices from IBM's own DB2 customer support organization
About the CD

The CD-ROM included with this book contains a complete trial version of DB2 UDB V8Personal Edition, plus the DB2DEMO program to help explore the many features of DB2.

Read More Show Less

Product Details

  • ISBN-13: 9780130463616
  • Publisher: IBM Press
  • Publication date: 2/10/2003
  • Series: IBM DB2 Certification Guide Ser.
  • Edition description: Older Edition
  • Edition number: 5
  • Pages: 912
  • Product dimensions: 6.90 (w) x 9.30 (h) x 1.37 (d)

Meet the Author

GEORGE BAKLARZ, IBM Senior Manager for DB2 Technical Sales Support, works closely withcustomers to help them understand new DB2 technology, and to gain their feedback for improvingDB2 products. He has spent 20 years at IBM working on various aspects of database technology.He is also a lecturer at the University of Guelph, teaching relational database concepts tostudents. BILL WONG, IBM DB2 Program Director, is responsible for assisting customers tounderstand IBM's latest DB2 technology and future directions for Linux, Life Sciences, and GridComputing. His 18 years of database experience encompass DB2 system and databaseadministration, technical sales support, vendor enablement, and product planning.

Read More Show Less

Table of Contents

(NOTE: Each chapter ends with a Summary.)


1. Product Overview.

DB2 and e-business. DB2 and Linux. DB2 Universal Database. DE2 Connectivity. DB2 Application Development. DB2 Administration.

2. Getting Started.

Product Installation. The DB2 Environment. The DB2 Instance. Instance Administration.

3. Getting Connected.

DB2Client Overview. Roadmap to Distributed Communications. Configuring DB2 Clients. Manually cataloging the DB2 Directories. Binding Utilities.

4. Controlling Data Access.

Security. Auditing.


5. Database Objects.

Understanding Database Objects. Managing Database Objects. Database Design and Implementation.

6. Manipulating Database Objects.

Data Retrieval. Data Modification. View Classification.

7. Advanced SQL.

Triggers, Recursive SQL. Outer Join. OLAP Features. Advanced CASE Expressions. Structured Types and Typed Tables. Summary of Tables. Sequences. Advanced Functions.

8. Concurrency.

Concurrency. Isolation Levels. Locking.


9. Data Storage Management.

Processor, memory, and Disk Resources. DB2 Storage Model. Table Space Design. Implementation Examples. Table Space Maintenance.

10. Maintaining Data.

Moving Data. Data Movement Utilities. Data Maintenance. Data Maintenance Process.

11. Database Recovery.

Database Recovery Concepts. Types of Recovery. Recovery Strategies. Use of Log Files.

12. Monitoring and Tuning.

Elements of Performance. DB2 Architecture Overview. DB2 Sorting Methods. Monitoring the DB2 System. Database Monitoring. SQL Monitoring. Performance Tuning Scenario. Diagnostics and Problem Determination.


13. Application Development Overview.

DB2 Application Development Environment. DB2 Programming Interfaces.

14. Development Considerations.

Embedded SQL Overview. Supporting CLI and ODBC Programming. Support for Java Programming. DB2 Development center.

15. Development SQL.

User-Defined Functions. Structured Datatypes. Schemas and Aliases. COMMIT and ROLLBACK. SQL Procedural Language.


Test Objectives. Product CD and DB2DEMO Program.
Appendix A. DB2 UDB V. Certification Test Objectives.

DB2 UDB Certification. DB2 UDB V8.1 Family Fundamentals (700). DB2 for Linux, UNIX, and Windows Database Administration (701). DB2 for Linux, UNIX< and Windows Advanced DBA (704).

Appendix B. CD-ROM Installation.

DB2 Installation. Documentation. DB2DEMO.


Read More Show Less

Customer Reviews

Average Rating 4
( 3 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted June 17, 2004


    This is an excellent book to complete the certification. Fairly easy to follow. You can install DB2 PE using the CD supplied which makes it even more appealing since you can install this on your computer and try out the various commands. An excellent book for readers who want to get 700 and 701 certifications. Thanks, -PK.Ganapathy

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted September 26, 2003

    Needs more work for a certification guide.

    If you have worked with another RDBMS, this book is an excellent resource to acquiring expertise needed to successfully study for and take the 700 exam. For mere beginners, the book lacks some necessary illustration to help illuminate concepts. It is not a one stop shopping endeavor for exam passing. Issues that kept it from receiving 5 Stars. Suggested improvements follows: The exam will test you on defining, calling and controlling access to stored procedures. There is no exposure of this material in Chapters 1-8. Further, there are some editorial blunders on the DB2CERT DDL in Chapter 5 that conflict with example SQL in Chapter 6. The authors should have used the DB2SAMPL schema instead since it is bundled with the Linux and Windows release media for the product. Finally, better graphical illustration of how locks are acquired and held for each isolation level would help clarify this topic for readers without extensive database internals knowledge. If you are studying for the exam, I would advise carefully studying the IBM SQL Reference in the product documentation set as well.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 3, 2003

    Good Book

    This book covers all the objectives for the exam 700. This book should be used with IBM Manual for preparation of the certification. Jignesh

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)