DWAINE R. SNOW has twelve years of experience implementing and tuning DB2 to support workloads from Web-based transactions up to multiterabyte data warehouses. Snow is the product manager for DB2 partitioned databases and is co-author of The DB2 Cluster Certification Guide.
THOMAS X. PHAN is an IBM Certified I/T Specialist in the IBM Data Management Consulting practice with over thirteen years of data processing experience. He specializes in relational database-related services including application design, logical and physical database design, and performance and tuning on numerous DB2 UDB platforms.
Foreword | |
Preface | |
Data Storage | |
Some Terminology Used in DB | |
The Default Database | |
Table Spaces | |
Containers | |
Extents | |
Creating Table Spaces | |
The Table Space Types | |
SMS Table Spaces | |
DMS Table Spaces | |
Should the Temporary Table Space Be SMS or DMS? Additional Table Space Options/Parameters | |
Listing Table Spaces | |
SYSCAT | |
TABLESPACES View | |
SYSCAT | |
TABLES View | |
When Is a Table Space Full? Table Space Maps and Table Space Extent Maps | |
Altering a Table Space | |
The Table Space's Partition Group | |
Database Partition Groups | |
Disk Layout | |
Summary | |
Data Manipulation | |
The Buffer Pools | |
Buffer Pool Usage | |
How Many Buffer Pools Should a Database Have? | |
When to Consider Multiple Buffer Pools | |
Buffer Pool Overhead | |
32- and 64-bit Considerations | |
Hidden Buffer Pools | |
Altering Buffer Pools | |
Block-Based Buffer Pools Can Improve Sequential Prefetching | |
System Catalog Views Relating to Buffer Pools | |
What Is Prefetching? What Is Page Cleaning? Monitoring Buffer Pool Activity | |
Buffer Pool Tuning | |
Parallelism | |
Intra-Partition Parallelism | |
Inter-Partition Parallelism | |
Combined Intra-Partition Parallelism and Inter-Partition Parallelism | |
Why Partition a Database on a Large SMP Server? Considerations with Multiple Database Partitions | |
Types of Database Objects | |
Tables | |
Partition Maps | |
The Relationship between Partition Groups, Table Spaces, and Tables | |
Partitioning Keys | |
Summary | |
Database Availability | |
Ability to Manage Logs | |
Primary Logs (LOGPRIMARY) | |
Secondary Logs (LOGSECOND) | |
Log File Size (LOGFILSIZ) | |
Log Buffer Size (LOGBUFSZ) | |
Number of Commits to Group (MINCOMMIT) | |
New Log Path (NEWLOGPATH) | |
Overflow Log Path (OVERFLOWLOGPATH) | |
Log Mirroring | |
Reducing Logging with the NOT LOGGED INITIALLY Parameter Option | |
Reducing Logging with Declared Global Temporary Tables (DGTTs) | |
Managing Log Files | |
Archiving Log Files with a User Exit Program | |
How Truncated Logs Are Handled | |
Log File Allocation and Removal | |
Blocking Transactions When the Log Directory File Is Full | |
On Demand Log Archive | |
Using Raw Logs | |
How to Prevent Losing Log Files | |
Review Session | |
Observation | |
Developing a Backup and Recovery Strategy | |
The Recovery History File | |
Deciding How Often to Back Up | |
Storage Considerations | |
Keeping Related Data Together | |
Using Different Operating Systems | |
Crash Recovery | |
Disaster Recovery | |
Version Recovery | |
Rollforward Recovery | |
Incremental Backup and Recovery | |
Backup Overview | |
Displaying Backup Information | |
Authorities Required to Use Backup | |
Using Backup | |
Backing Up to Tape | |
Backing Up to Named Pipes | |
Backup Database: Examples | |
Optimizing Backup Performance | |
Offline versus Online Backup | |
Backup Considerations | |
Restore Overview | |
Authorities Required to Use Restore | |
Using Restore | |
Using Incremental Restore in a Test and Production Environment | |
Redefining Table Space Containers During a Restore Operation (Redirected Restore) | |
Restoring to an Existing Database | |
Restoring to a New Database | |
Restore Database: Examples | |
Optimizing Restore Performance | |
Restore Considerations | |
Restore to a Damaged Partition | |
Rollforward Overview | |
Authorities Required to Use Rollforward | |
Using Rollforward | |
Rollforward Database: Examples | |
High Availability Clustering | |
Split Mirror | |
Suspend I/O Feature | |
The db2inidb Tool | |
High Availability through Log Shipping | |
High Availability through Online Split Mirror and Suspended I/O Support | |
Split Mirror to Clone a Database | |
Split Mirror as a Standby Database | |
Split Mirror as a Backup Image | |
High Availability on AIX | |
Hot Standby with a Cascading Resource Group | |
Mutual Takeover with a Cascading Resource Group | |
High Availability on the Windows Operating System | |
Clustered Servers for High Availability | |
High Availability on Sun Solaris | |
High Availability with VERITAS Cluster Server | |
Considerations for Hig | |
Table of Contents provided by Publisher. All Rights Reserved. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.