DB2 UDB v8 Handbook for Windows and UNIX/Linux

Philip K. Gunning

  • 出版商: Prentice Hall
  • 出版日期: 2003-08-04
  • 售價: $2,100
  • 貴賓價: 9.5$1,995
  • 語言: 英文
  • 頁數: 496
  • 裝訂: Paperback
  • ISBN: 0130661112
  • ISBN-13: 9780130661111
  • 相關分類: Linux
  • 立即出貨(限量) (庫存=1)

買這商品的人也買了...

商品描述

Summary

DB2 Universal Database V8 Handbook for Windows, UNIX, and Linux is the definitive guide to making the most of the best version of DB2 ever: Version 8. Thoroughly reviewed by the IBM DB2 team, it brings together hundreds of techniques for maximizing availability, manageability, performance, scalability, and overall ROI. It contains authoritative coverage of DB2 V8's key enhancements, including new Wizards, Advisors, development tools, performance enhancements, XML support, and much more.

Table of Contents

Foreword.


Preface.



1. What's New.

Product Changes. Manageability Enhancements. Performance Enhancements. Availability Enhancements. Serviceability Enhancements. Application Development Enhancements. Summary.



2. DB2 v8 Product Overview and Architecture.

Enterprise Server Edition. DB2 Workgroup Server Edition (WSE). DB2 Personal Edition (PE). DB2 Universal Developers Edition (UDE). DB2 Personal Developers Edition (PDE). DB2 Warehouse Manager. DB2 Intelligent Miner Products. DB2 Spatial Extender. DB2 Net Search Extender. New Client. DB2 Architecture. Bufferpools. Prefetchers (db2pfchr). Page Cleaners (db2pclnr). Logs (db2loggr). Deadlock Detector. Connection Concentrator. Summary.



3. Logical and Physical Design.

Business Model. Business Entities. Business Rules. Entities and Relationships. Special Entity Relationships. Normalization. First Normal Form. Second Normal Form. Third Normal Form (3NF). Boyce-Codd Normal Form (BCNF). Domain Key/Normal Form (DK/NF). Unified Modeling Language (UML). Logical Design Outputs. Physical Design. Denormalization. Creation of Indexes. Creation of Tablespaces and Tables. Bufferpool Strategy. Summary.



4. Application Development.

Getting Started. DB2 Administration Client. DB2 Application Development Client. DB2 Personal Developers' Edition (PDE). DB2 Universal Developers' Edition. DB2 Development Center. DB2 Visual Explain. Development Center. Java Thread-Safe Routines. Java Common Client. SQL Enhancements. SQL Assist. SQL Enhancements. Informational Constraints. Insert Through Union All Views. Summary Tables. Current Refresh Age Special Register. Materialized Query Table (MQT). User-Maintained MQTs. eXtensible Markup Language. Summary.



5. Type-2 Indexes and Multidimensional Clustering.

Benefits of Type-2 Indexes. Type-2 Indexes and Next-Key Locking. Migration Considerations for Type-2 Indexes. Suggested Migration Strategy for Type-2 Indexes. Multidimensional Clustering. MDC Table Considerations. Summary.



6. High Performance Tablespace Design and I/O Strategies.

Tablespaces. Storage Models. Prefetching. Tables and Tablespace Considerations. The Life of an I/O Request. Redundant Array of Independent Disks (RAID). Tablespace Container Management. DB2 and IBM Enterprise Storage System (ESS SHARK). Keeping a Map of Your Database. Summary.



7. Utilities and Commands.

Reorganizing Indexes/Tables. REORGCHK Utility. Database Logging. Backup Database Utility. Restore Database Utility. Roll-forward Database. Query Status. Archive Log Command. List History. List Tablespaces. Set Tablespace Containers Command. DB2TBST-Get Tablespace State Command. RUNSTATS Utility. LOAD Utility. LOAD QUERY Command. QUIESCE Command. UNQUIESCE Command. Migrate Database Utility. INSPECT Utility. Summary.



8. Tuning Bufferpools.

Introduction. Maintaining Bufferpools. Monitoring Bufferpool Performance. Monitoring and Tuning Tables, Bufferpools, and Tablespaces. Summary.



9. Tuning Configuration Parameters.

Autonomic Computing. Online Configuration Parameters. DB2 Memory Areas. Database Manager Shared Memory. Database Global Memory. Application Global Memory (app_ctl_heap_sz). Agent Private memory. Agent Parameters. MAXAGENTS. MAXCAGENTS. MAXAPPLS. Agent Monitoring. Configuration Advisor. Summary.



10. Monitoring.

Enabling Monitoring. Snapshots through New SQL Functions. Event Monitoring. Create Event Monitor Options. Table Options. Event Monitor Scope. Event Monitor Catalog Tables. General Consideration for Write-to-Table Event Monitors. Summary.



11. Problem Determination.

Connectivity Problems. Performance and Application Problems. DB2 Code (Defect) Problems. DB2 Problem Determination Aids. DB2DIAG.LOG File. DB2DIAG.LOG SQLCA Entries. DB2 Administration Notification Log. System Logs. CLI Trace. DB2 Trace. DRDA Trace. Dumps. Traps. Call Stack Traces. Sending Information to DB2 Support. Summary.



12. Understanding and Tuning DB2 Sort.

DB2 Sort Memory Areas. Types of Sorts. SHEAPTHRES. Sizing Sort Memory Areas. Monitoring Sort Performance. Eliminating Sorts. Changing SQL. Summary.



13. Enterprise Server Edition-Database Partitioning Feature.

When Should You Use Partitioned Databases? DB2 v8.1 ESE Improvements. Partitioned Database Join Strategies. Dynamic Bitmap Index Anding (DBIA). Index Considerations in a DPF Environment. Load Utility Considerations in a DPF Environment. Load Utility Operations. Adding a Database Partition. Summary.



APPENDIX A: DB2 Catalog Views.

SYSCAT.ATTRIBUTES. SYSCAT.BUFFERPOOLDBPARTITIONS. SYSCAT.BUFFERPOOLS. SYSCAT.CASTFUNCTIONS. SYSCAT.CHECKS. SYSCAT.COLAUTH. SYSCAT.COLCHECKS. SYSCAT.COLDIST. SYSCAT.COLGROUPDIST. SYSCAT.COLGROUPDISTCOUNTS. SYSCAT.COLGROUPS. SYSCAT.COLOPTIONS. SYSCAT.COLUMNS. SYSCAT.COLUSE. SYSCAT.CONSTDEP. SYSCAT.DATATYPES. SYSCAT.DBAUTH. SYSCAT.DBPARTITIONGROUPDEF. SYSCAT.DBPARTITIONGROUPS. SYSCAT.EVENTMONITORS. SYSCAT.EVENTS. SYSCAT.EVENTTABLES. SYSCAT.FULLHIERARCHIES. SYSCAT.FUNCMAPOPTIONS. SYSCAT.FUNCMAPPARMOPTIONS. SYSCAT.FUNCMAPPINGS. SYSCAT.HIERARCHIES. SYSCAT.INDEXAUTH. SYSCAT.INDEXCOLUSE. SYSCAT.INDEXDEP. SYSCAT.INDEXES. SYSCAT.INDEXEXPLOITRULES. SYSCAT.INDEXEXTENSIONDEP. SYSCAT.INDEXEXTENSIONMETHODS. SYSCAT.INDEXEXTENSIONPARMS. SYSCAT.INDEXEXTENSIONS. SYSCAT.INDEXOPTIONS. SYSCAT.KEYCOLUSE. SYSCAT.NAMEMAPPINGS. SYSCAT.PACKAGEAUTH. SYSCAT.PACKAGEDEP. SYSCAT.PACKAGES. SYSCAT.PARTITIONMAPS. SYSCAT.PASSTHRUAUTH. SYSCAT.PREDICATESPECS. SYSCAT.PROCOPTIONS. SYSCAT.PROCPARMOPTIONS. SYSCAT.REFERENCES. SYSCAT.REVTYPEMAPPINGS. SYSCAT.ROUTINEAUTH. SYSCAT.ROUTINEDEP. SYSCAT.ROUTINEPARMS. SYSCAT.ROUTINES. SYSCAT.SCHEMAAUTH. SYSCAT.SCHEMATA. SYSCAT.SEQUENCEAUTH. SYSCAT.SEQUENCES. SYSCAT.SERVEROPTIONS. SYSCAT.SERVERS. SYSCAT.STATEMENTS. SYSCAT.TABAUTH. SYSCAT.TABCONST. SYSCAT.TABDEP. SYSCAT.TABLES. SYSCAT.TABLESPACES. SYSCAT.TABOPTIONS. SYSCAT.TBSPACEAUTH. SYSCAT.TRANSFORMS. SYSCAT.TRIGDEP. SYSCAT.TRIGGERS. SYSCAT.TYPEMAPPINGS. SYSCAT.USEROPTIONS. SYSCAT.VIEWS. SYSCAT.WRAPOPTIONS. SYSCAT.WRAPPERS. SYSSTAT.COLDIST. SYSSTAT.COLUMNS. SYSSTAT.INDEXES. SYSSTAT.ROUTINES. SYSSTAT.TABLES.



APPENDIX B: DB2 Information on the Web.

DB2-L Listserver. Newsgroup. Newsletters. e-zines. Web Sites. User Group. Vendor Web Sites.



APPENDIX C: DB2 Limits.

Identifier Length Limits. Numeric Limits. String Limits. Datetime Limits. Database Manager Limits. Database Manager Page Size-Specific Limits.



APPENDIX D: DB2 Registry and Environmental Variables.

General Registry Variables. System Environment Variables. Communications Variables. Command-Line Variables. MPP Configuration Variables. SQL Compiler Variables. Performance Variables. Miscellaneous Variables.



Bibliography.


Index.

商品描述(中文翻譯)

《DB2 Universal Database V8 Handbook for Windows, UNIX, and Linux》是使用DB2 V8版本的最佳指南。這本書由IBM DB2團隊仔細審查,匯集了數百種技巧,以最大化可用性、可管理性、性能、可擴展性和整體投資回報率。它包含了對DB2 V8的關鍵增強功能的權威介紹,包括新的向導、建議工具、開發工具、性能增強、XML支持等等。

目錄:
前言
前言
1. 新功能
2. DB2 v8產品概述和架構
3. 邏輯和物理設計
4. 應用開發
5. 類型2索引和多維聚集
6. 高性能表空間設計和I/O策略
7. 工具和命令