Appropriate for all courses in IBM DB2 Version 8 database administration, and all courses preparing students to pass IBM's new DB2 certification exams (Exam 512: Fundamentals and Exam 513: Administration).
In this book, two of IBM's leading DB2 consultants present the only complete, start-to-finish guide to DB2 Universal Database V8/8.1 administration and development for UNIX, Linux, and Windows platforms, and the first authoritative preparation guide for IBM's latest DB2 certification exams (512 and 513). This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V8 and V8.1, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB V8 from other databases or earlier versions of DB2; and much more. It also contains an unparalleled collection of IBM tips for maximizing database performance, availability, and efficiency. The accompanying CD-ROM contains a complete trial version of DB2 UDB V8 Personal Edition, as well as bonus study questions for IBM's latest DB2 certification exam.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 235 mm
Breite: 178 mm
Dicke: 32 mm
Gewicht
ISBN-13
978-0-13-046361-6 (9780130463616)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
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.
(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.
