- Shopping Bag ( 0 items )
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:
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.
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.
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.
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.
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.
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.
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.GanapathyWas this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted September 26, 2003
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 NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted August 3, 2003