| |
| |
| Foreword | |
| |
| |
| Dedications and Acknowledgments | |
| |
| |
| |
| Packaging and Licensing | |
| |
| |
| |
| Changes to DB2 Universal Database and DB2 Connect Packaging and Licensing | |
| |
| |
| DB2 Universal Database and DB2 Connect Supported Operating Systems | |
| |
| |
| Changes to DB2 Universal Database Licensing and Packaging | |
| |
| |
| DB2 UDB Personal Edition | |
| |
| |
| DB2 UDB Express | |
| |
| |
| DB2 UDB Workgroup Server and Workgroup Server Unlimited Editions | |
| |
| |
| DB2 UDB Enterprise Server Edition and the Database Partitioning Feature | |
| |
| |
| DB2 UDB Data Warehouse Edition | |
| |
| |
| Changes to DB2 Connect Licensing and Packaging | |
| |
| |
| DB2 Connect Application Server Edition | |
| |
| |
| Integrated DB2 Connect Component in DB2 Universal Database Enterprise Edition | |
| |
| |
| Miscellaneous Changes | |
| |
| |
| Changes to Related DB2 Universal Database Products | |
| |
| |
| |
| Performance | |
| |
| |
| |
| Multidimensional Clustering Tables | |
| |
| |
| MDC 101: A Simple Contrast between Traditional and Multidimensional Tables | |
| |
| |
| Terminology Required to Understand MDC Tables | |
| |
| |
| MDC Table | |
| |
| |
| Dimension | |
| |
| |
| Slice | |
| |
| |
| Cell | |
| |
| |
| Block | |
| |
| |
| Block Size or Blocking Factor | |
| |
| |
| Block Index | |
| |
| |
| Block ID | |
| |
| |
| Generated Column | |
| |
| |
| Monotonicity | |
| |
| |
| How MDC Tables Work | |
| |
| |
| Creating an MDC Table | |
| |
| |
| Indexes and MDC Tables | |
| |
| |
| MDC and Query SELECT, INSERT, UPDATE, and DELETE Operations | |
| |
| |
| Picking a Dimension for an MDC Table | |
| |
| |
| Summary | |
| |
| |
| |
| Declared Global Temporary Tables | |
| |
| |
| Index Support for DGTTs | |
| |
| |
| Index Restrictions on a DGTT | |
| |
| |
| Creating an Index on a DGTT | |
| |
| |
| Minimal Undo Logging to Support the Rollback of Data Changes to DGTTs | |
| |
| |
| Statistics Support on DGTTs | |
| |
| |
| |
| System Default Value and NULL Compression | |
| |
| |
| How Data Compression Works in DB2 UDB | |
| |
| |
| The New Row Record Format | |
| |
| |
| Compression Example | |
| |
| |
| Supported Data Types for Compression | |
| |
| |
| How Do I Know if Compression Is Turned On? | |
| |
| |
| Estimating Compression Savings | |
| |
| |
| |
| Informational Constraints | |
| |
| |
| Why Informational Constraints? | |
| |
| |
| Using Informational Constraints | |
| |
| |
| Informational Constraints Example | |
| |
| |
| Usage Considerations. 6. Connection Concentrator | |
| |
| |
| Connection Management Improvements | |
| |
| |
| Activating the Connection Concentrator | |
| |
| |
| Connection Concentrator Operation | |
| |
| |
| |
| User-Maintained Materialized Query Tables | |
| |
| |
| Restrictions | |
| |
| |
| Creating Materialized Query Tables | |
| |
| |
| Populating Materialized Query Tables | |
| |
| |
| Leveraging Materialized Query Tables for Improved Query Performance | |
| |
| |
| |
| Database System Monitoring Enhancements | |
| |
| |
| Preventing the Collection of Timestamps | |
| |
| |
| Enhanced Deadlock Monitoring | |
| |
| |
| SQL Access to Event Monitor Data | |
| |
| |
| SQL Access to Snapshot Monitor Data | |
| |
| |
| SNAPSHOT_FILEW Snapshot Request Types | |
| |
| |
| Capturing a Snapshot to a File with SNAPSHOT_FILEW | |
| |
| |
| Capturing a Snapshot From a File | |
| |
| |
| DB2_SNAPSHOT_NOAUTH Registry Variable | |
| |
| |
| Performance Monitor Control Center Tool Has Been Deprecated | |
| |
| |
| |
| Miscellaneous Performance Enhancements | |
| |
| |
| Distributed Catalog Cache | |
| |
| |
| Prefetching Enhancements with Block-Based Buffer Pools | |
| |
| |
| Page Cleaner I/O Improvements | |
| |
| |
| Multithreading of Java-Based Routines | |
| |
| |
| 64-Bit Support | |
| |
| |
| Automatic Relationship and Association Management (ARAM) | |
| |
| |
| New Join Variations | |
| |
| |
| Increased Opportunity for Selection of Bit-Filters | |
| |
| |
| |
| Manageability | |
| |
| |
| |
| Logging | |
| |
| |
| Transactional Logging Improvements | |
| |
| |
| Increased Log Space | |
| |
| |
| Infinite Active Log Space | |
| |
| |
| Controlling the Consumption of Log Space | |
| |
| |
| Transactional Logging Performance Improvements | |
| |
| |
| Log Mirroring | |
| |
| |
| Blocking Transactions When the Logs Are Full | |
| |
| |
| Diagnostic Logging Improvements | |
| |
| |
| |
| Load Enhancements | |
| |
| |
| Online Load | |
| |
| |
| Locking Behavior | |
| |
| |
| New Table States | |
| |
| |
| Loading Data into Partitioned Databases | |
| |
| |
| Loading Data from a Cursor | |
| |
| |
| Load Wizard | |
| |
| |
| |
| DB2 Tools | |
| |
| |
| Configuration Assistant | |
| |
| |
| Health Center | |
| |
| |
| Memory Visualizer | |
| |
| |
| Memory Tracker | |
| |
| |
| Storage Management | |
| |
| |
| Storage Management View Columns | |
| |
| |
| Indoubt Transaction Manager | |
| |
| |
| Fault Monitor | |
| |
| |
| |
| Container Operations | |
| |
| |
| Table | |