DB2 universal database v8 handbook for Windows, Unix, and Linux

By: Gunning, Philip KMaterial type: TextTextPublication details: New Delhi : Prentice-Hall of India., ©2003Description: xxiv, 472 p. : illustrationsISBN: 0130661112 ; 9780130661111; 9788129702975 ; 8129702975Subject(s): IBM Database 2 | Electronic data processing personnel -- Certification | Database management -- Certification -- Study guides | Operating systems (Computers)DDC classification: 005.7565
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.
Summary: Straight from IBM, this guide offers start-to-finish coverage of DB2 Universal Database Version 8 administration. With Version 8 key topics such as Performance Enhancements and Manageability Enhancements are addressed.
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Date due Barcode Item holds
Reference Books Reference Books Main Library
Reference 		Reference 005.7565 GUN (Browse shelf(Opens below)) Available 008241
Total holds: 0

Included Index.

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.

Straight from IBM, this guide offers start-to-finish coverage of DB2 Universal Database Version 8 administration. With Version 8 key topics such as Performance Enhancements and Manageability Enhancements are addressed.

There are no comments on this title.

to post a comment.

© University of Vavuniya

---