This book offers complete, start-to-finish coverage of DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8 including database design. In addition, how to use appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; and migrating to DB2 UDB from other databases or earlier versions of DB2 is discussed.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 233 mm
Breite: 177 mm
Dicke: 17 mm
Gewicht
ISBN-13
978-0-13-066111-1 (9780130661111)
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
PHILIP K. GUNNING, Vice President of the Professional Services Division at DGI (Database-GUYS, Inc.), is responsible for the firm's DB2 UDB product training and consulting practices. A recognized expert on IBM DB2 database platform, he has earned IBM recognition as both a IBM Certified Advanced Technical Expert in DB2 database administration and as a DRDA IBM Certified Solutions provider.
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.
