shopping cart
Save up to 30% on our Staff Picks
Call us:  800-878-7323 HELP
McAfee SECURE helps keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams.
Interviews | November 3, 2009

Sheila A.: IMG On Storytelling: The Powells.com Interview with Donald Miller



donaldmillerDonald Miller is a Christian writer, but the question that Miller asks with his latest memoir, A Million Miles in a Thousand Years, is applicable to... Continue »
  1. $13.99 Sale Hardcover add to wish list

This item may be
out of stock.

Click on the button below to search for this title in other formats.
Check for Availability
Add to Wishlist

Db2 Universal Database Volume 7.1 4TH Edition

by George Baklarz

Synopses & Reviews

Publisher Comments:

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.

Book News Annotation:

A guide and reference to the newest version of IBM's DB2 Universal Database. Suitable for those deploying or managing the new version, or preparing for certification, this 2.25-inch thick guide presents a detailed overview of the whole family of products, concepts, and terminology, as well as coverage of installation, configuration, networking, security, data integrity, optimization, and other topics. CD-ROM contains a trial version of DB2 UDB v7.1for Windows versions NT, 2000, 98, and 95, as well as a demo program DB2DEMO.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

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

Table of Contents

(NOTE: Each chapter ends with a Summary.)

I. INTRODUCTION TO DB2 UDB.

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.

II. USING SQL.

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.

III. DB2 UDB ADMINISTRATION.

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.

IV DEVELOPING APPLICATIONS.

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.

V. APPENDICES.

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

Product Details

ISBN:
9780130913661
Subtitle:
R Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide
Author:
Baklarz, George
Author:
Wong, Bill
Author:
Cook, Jonathan
Publisher:
IBM Press
Location:
Upper Saddle River, NJ
Subject:
Database Management - General
Subject:
Database management
Subject:
Relational databases
Subject:
Certification
Subject:
Electronic data processing personnel
Subject:
IBM Database
Subject:
Certification - General
Subject:
Certification Guides - General
Copyright:
Edition Number:
4
Series:
IBM DB2 certification guide series
Series Volume:
no. 44
Publication Date:
20030210
Binding:
Mixed media, eg book and CD-ROM, book and toy etc
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
912
Dimensions:
24 cm. +

Other books you might like

  1. $5.95 Used Trade Paper add to wish list
  2. $3.25 Used Mass Market add to wish list

    The Burning Hills

    Louis Lamour
  3. $2.95 Used Mass Market add to wish list

    Son of a Wanted Man

    Louis Lamour
  4. $2.95 Used Mass Market add to wish list

    Killoe

    Louis Lamour
  • back to top

Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and eBooks — here at Powells.com.