DB2 Universal Database V8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, Fifth Edition / Edition 5
by George Baklarz, Bill WongStraight from IBM, DB2 Universal Database V8 for Linux, UNIX, and Windows DatabaseAdministration Certification Guide is the definitive guide to DB2 V8/8.1 administration anddevelopment - and the only authoritative self-study guide for IBM's new DB2 V8 certificationexams. IBM experts offer hundreds of tips, techniques, guidelines, and best practices… See more details below
Overview
Straight from IBM, DB2 Universal Database V8 for Linux, UNIX, and Windows DatabaseAdministration Certification Guide is the definitive guide to DB2 V8/8.1 administration anddevelopment - and the only authoritative self-study guide for IBM's new DB2 V8 certificationexams. IBM experts offer hundreds of tips, techniques, guidelines, and best practices formaking the most of DB2's enhanced manageability, serviceability, availability, scalability,performance, and developer resources. The CD-ROM included with this book contains a completetrial version of DB2 UDB V8 Personal Edition, plus the DB2DEMO program to help explore the manyfeatures of DB2.
Product Details
- ISBN-13:
- 9780130463616
- Publisher:
- IBM Press
- Publication date:
- 02/10/2003
- Series:
- IBM DB2 Certification Guide Ser.
- Edition description:
- Older Edition
- Pages:
- 912
- Product dimensions:
- 6.90(w) x 9.30(h) x 1.37(d)
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.
Customer Reviews
Average Review: