- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
DB2 (R) 9 builds on the world's number one enterprise database to simplify the delivery of information as a service, accelerate development, and dramatically improve operational efficiency, security, and resiliency.Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux (R), UNIX (R), and Windows (R) platforms, as well as authoritative preparation for the latest IBM DB2 certification exam.Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked, Internet-centered, and SOA-based applications; migration; and much more. You'll also find an unparalleled collection of expert tips for optimizing performance, availability, and value. Coverage includes:Important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role Breakthrough pureXML (TM) features that make it easier to succeed with service-oriented architecture Operational improvements that enhance DBA efficiency--including self-tuning memory allocation, automated storage management, and storage optimization Table-partitioning features that improve scalability and manageability Powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all dataWhatever your role in working with DB2 or preparing for certification, DB2 9 for Linux, UNIX, and Windows, Sixth Edition is the one book you can't afford to be without.Download Complete DB2 V9 Trial VersionVisit ibm.com/db2/9/download.html to download a complete trial version of DB2, which enables you to try out dozens of the most powerful features of DB2 for yourself: everything from pureXML support to automated administration and optimization.Straight from IBM, the ultimate guide to running DB2 9 and preparing for the latest IBM DB2 certification exam! Covers powerful DB2 9 enhancements ranging from automated management to improved compression Covers the full spectrum of DBA responsibilities, including server management, data placement, XML concepts, activity analysis, high availability, and security Presents expert tips and best practices from the DB2 customer support organization
Contents
Foreword xxiPreface xxiiiPart ONE: Introduction to DB2 1Chapter 1: Product Overview 3Information as a Service 4The DB2 for Linux, UNIX, and Windows Data Server 9DB2 Connectivity 28DB2 Administration 45Summary 60Chapter 2: Getting Started 63Product Installation 64The DB2 Environment 98Summary 115Chapter 3: Getting Connected 117DB2 Client Overview 118Roadmap to Distributed Communications 124Summary 164Chapter 4: Controlling Data Access 167Overview of Security 168Auditing 216Summary 221Part TWO: Using SQL 223Chapter 5: Database Objects 225Understanding Database Objects 227Managing Database Objects 235Tables 263Database Design and Implementation 316Summary 325Chapter 6: Manipulating Database Objects 327Data Retrieval 328Data Modification 365View Classification 383Summary 395Chapter 7: Advanced SQL 397Triggers 398Recursive SQL 405Outer Join 409OLAP Features 414Advanced CASE Expressions 432Structured Types and Typed Tables 434Summary Tables 456Sequences 469Advanced Functions 472Summary 487Chapter 8: pureXML Storage Engine 489pureXML Feature Pack 490The Difference: pureXML 495Creating an XML-enabled Database 500Creating Tables with pureXML 502Inserting Data into pureXML Columns 504Selecting Data from pureXML Columns 513Updating and Deleting pureXML Columns 520Indexing pureXML Columns 521XML Schema Repository (XSR) 533Summary 537Chapter 9: Development SQL 539User-Defined Functions 540Structured Data Types 549Schemas and Aliases 555COMMIT and ROLLBACK 558SQL Procedural Language 559Stored Procedures 578Summary 597Chapter 10: Concurrency 599Concurrency 600Isolation Levels 607Lockingv610Summary 621Part THREE: DB2 Administration 623Chapter 11: Data Storage Management 625Processor, Memory, and Disk Resources 626DB2 Storage Model 628Table Space Design 640Implementation Examples 652Automatic Storage 664Table Space Maintenance 666Table (Range) Partitioning 674Summary 699Chapter 12: Maintaining Data 701Moving Data 702Data Movement Utilities 705Data Maintenance 766Data Maintenance Process 786Summary 791Chapter 13: Database Recovery 793Database Recovery Concepts 794Types of Recovery 795Recovery Strategies 796Use of Log Files 797Version Recovery Using Backup and Restore 805Roll-Forward Recovery 827Managing Log Files 837Other Recovery Considerations 838High Availability 845High-Availability Disaster Recovery 850Summary 869Chapter 14: Monitoring and Tuning 871Elements of Performance 872DB2 Architecture Overview 876DB2 Sorting Methods 887Monitoring the DB2 System 887Database Monitoring 890SQL Monitoring 921Diagnostics and Problem Determination 947Self-Tuning Memory Manager 960Summary 973Part FOUR: Developing Applications 975Chapter 15: Application Development Overview 977DB2 Application Development Environment 978DB2 Programming Interfaces 982Summary 995Chapter 16: Development Considerations 997Embedded SQL Overview 998Support for CLI and ODBC Programming 1009Support for Java Programming 1018DB2 Developer Workbench 1021Summary 1022Part FIVE: Appendices 1023Appendix A: DB2 9 Certification Test Objectives 1025DB2 Certification Levels 1026DB2 9 Fundamentals (730) 1027DB2 for LUW Database Administration (731) 1029DB2 for LUW Advanced DBA (734) 1032IBM Certified DBA for DB2 9 for LUW, Upgrade (736) 1034Appendix B: DB2DEMO Installation 1037Installation Requirements 1038Using the DB2DEMO Program 1045Advanced Programming Information 1066Support 1095Index 1097
