DB2 Version 8: The Official Guide
by Zikopoulos, Paul C.; Baklarz, George; deRoos, Dirk; Melnyk, Roman B.Edition: CD
Format: Paperback w/CD
Pub. Date: 2004-01-01
Publisher(s): IBM Press
Other versions by this Author
List Price: $59.99
Rent Textbook
Select for Price
New Textbook
We're Sorry
Sold Out
Used Textbook
We're Sorry
Sold Out
eTextbook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
DB2 Version 8 represents one of the most feature-packed and significant releases in DB2's history! This book is well organized into topics such as Performance Enhancements, Manageability Enhancements, SQL Enhancements, etc. Each section presents not only the new features in Version 8, but also gives technical details about the new features, gotchas, tips and tricks, and examples of how to use them - this kind of insider information is not currently available on the market today!
Table of Contents
| 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 | |
| Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.