DB2 UDB v8 Handbook for Windows and UNIX/Linux
暫譯: DB2 UDB v8 Windows 與 UNIX/Linux 手冊

Philip K. Gunning

DB2 UDB v8 Handbook for Windows and UNIX/Linux
  • 出版商: 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最佳版本（版本8）的權威指南。該書經過IBM DB2團隊的徹底審核，匯集了數百種技術，以最大化可用性、可管理性、性能、可擴展性和整體投資回報率。它包含了DB2 V8的關鍵增強功能的權威介紹，包括新的向導、顧問、開發工具、性能增強、XML支持等。

目錄

前言。

序言。

1. 新特性。

產品變更。可管理性增強。性能增強。可用性增強。可維護性增強。應用開發增強。總結。

2. DB2 v8產品概述與架構。

企業伺服器版。DB2工作組伺服器版（WSE）。DB2個人版（PE）。DB2通用開發者版（UDE）。DB2個人開發者版（PDE）。DB2倉儲管理器。DB2智能挖掘產品。DB2空間擴展器。DB2網路搜尋擴展器。新客戶端。DB2架構。緩衝池。預取器（db2pfchr）。頁面清理器（db2pclnr）。日誌（db2loggr）。死鎖檢測器。連接集中器。總結。

3. 邏輯與物理設計。

商業模型。商業實體。商業規則。實體與關係。特殊實體關係。正規化。第一正規形。第二正規形。第三正規形（3NF）。Boyce-Codd正規形（BCNF）。域鍵/正規形（DK/NF）。統一建模語言（UML）。邏輯設計輸出。物理設計。反正規化。索引的創建。表空間和表的創建。緩衝池策略。總結。

4. 應用開發。

入門。DB2管理客戶端。DB2應用開發客戶端。DB2個人開發者版（PDE）。DB2通用開發者版。DB2開發中心。DB2視覺解釋。開發中心。Java線程安全例程。Java通用客戶端。SQL增強。SQL輔助。SQL增強。信息約束。通過聯合所有視圖插入。摘要表。當前刷新年齡特殊寄存器。物化查詢表（MQT）。用戶維護的MQT。可擴展標記語言。總結。

5. Type-2索引與多維聚類。

Type-2索引的好處。Type-2索引與下一鍵鎖定。Type-2索引的遷移考量。Type-2索引的建議遷移策略。多維聚類。MDC表考量。總結。

6. 高性能表空間設計與I/O策略。

表空間。存儲模型。預取。表與表空間考量。一個I/O請求的生命週期。冗餘獨立磁碟陣列（RAID）。表空間容器管理。DB2與IBM企業存儲系統（ESS SHARK）。保持數據庫的地圖。總結。

7. 工具與命令。

重組索引/表。REORGCHK工具。數據庫日誌。備份數據庫工具。恢復數據庫工具。向前滾動數據庫。查詢狀態。存檔日誌命令。列出歷史。列出表空間。設置表空間容器命令。DB2TBST-獲取表空間狀態命令。RUNSTATS工具。LOAD工具。LOAD QUERY命令。QUIESCE命令。UNQUIESCE命令。遷移數據庫工具。INSPECT工具。總結。

8. 調整緩衝池。

介紹。維護緩衝池。監控緩衝池性能。監控與調整表、緩衝池和表空間。總結。

9. 調整配置參數。

自動計算。線上配置參數。DB2內存區域。數據庫管理器共享內存。數據庫全局內存。應用全局內存（app_ctl_heap_sz）。代理私有內存。代理參數。MAXAGENTS。MAXCAGENTS。MAXAPPLS。代理監控。配置顧問。總結。

10. 監控。

啟用監控。通過新SQL函數的快照。事件監控。創建事件監控選項。表選項。事件監控範圍。事件監控目錄表。寫入表事件監控的一般考量。總結。

11. 問題判斷。

連接問題。性能與應用問題。DB2代碼（缺陷）問題。DB2問題判斷輔助工具。DB2DIAG.LOG文件。DB2DIAG.LOG SQLCA條目。DB2管理通知日誌。系統日誌。CLI跟蹤。DB2跟蹤。DRDA跟蹤。轉儲。陷阱。調用堆棧跟蹤。向DB2支持發送信息。總結。

12. 理解與調整DB2排序。

DB2排序內存區域。排序類型。SHEAPTHRES。調整排序內存區域大小。監控排序性能。消除排序。更改SQL。總結。

13. 企業伺服器版-數據庫分區功能。

何時應使用分區數據庫？DB2 v8.1 ESE改進。分區數據庫聯接策略。動態位圖索引與（DBIA）。DPF環境中的索引考量。DPF環境中的加載工具考量。加載工具操作。添加數據庫分區。總結。

附錄A：DB2目錄視圖。

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。

附錄B：DB2網路資訊。

DB2-L郵件列表。新聞組。電子報。電子雜誌。網站。用戶組。供應商網站。

附錄C：DB2限制。

標識符長度限制。數字限制。字符串限制。日期時間限制。數據庫管理器限制。數據庫管理器頁面大小特定限制。

附錄D：DB2註冊表與環境變數。

一般註冊表變數。系統環境變數。通訊變數。命令行變數。MPP配置變數.SQL編譯器變數。性能變數。其他變數。

參考文獻。

索引。

類似商品