About this product

Product Identifiers

PublisherPrentice Hall PTR

ISBN-100132037955

ISBN-139780132037952

eBay Product ID (ePID)1718106

Product Key Features

Number of Pages736 Pages

Publication NameDb2 High Performance Design and Tuning

LanguageEnglish

Publication Year2000

SubjectDesktop Applications / Databases, Databases / General

TypeTextbook

Subject AreaComputers

AuthorSusan Lawson, Richard A. Yevich

FormatHardcover

Dimensions

Item Height2 in

Item Weight55.7 Oz

Item Length9.6 in

Item Width7.3 in

Additional Product Features

Edition Number2

Intended AudienceScholarly & Professional

LCCN00-055810

Dewey Edition21

IllustratedYes

Dewey Decimal005.75/65

Table Of ContentSetting the Stage. The Legacy. Performance Does Not Come Easy. The Realization. Why the Myths Arose. Top 20 Myths. Section 1. Environment and Tuning. 1. I/O and Storage Management. Data Facility Storage Management Subsystem (DFSMS). Data Classes. Storage Classes. Management Classes. Storage Groups. Reclaiming Space. Disk Storage. Tape versus Disk. Data-Set Allocation and Placement. I/O Subsystem. Understanding I/O. I/O Scheduling Priority. Cache Considerations. SEQCACH. Enterprise Storage Server (ESS). Features Benefiting DB2. Tuning I/O and Caching. I/O and Caching Summary. Compression. DB2 Compression Methods. What Is and Is Not Compressed. Performance Issues. Logging. Log Reads. Log Writes. Active Logs. Archive Logs. 2. CPU. CPU and SQL Design Issues. Number of SQL Statements. Number of Rows Retrieved. Number of Columns Retrieved. Unnecessary Repetitive Processes. Referential Integrity. Sorting. Physical Design Issues. Application Design Issues. I/O Layers. Benefits of SQL Tuning for CPU. Life of xPROCs. Address Space Priority. Mixed Workloads and WLM. Test and Production Mix. WLM. OLTP and Warehouses. IRLM. Thread Reuse. CICS. IMS. Traces. 3. Memory. Virtual Storage. Address Spaces. Below the 16MB Line. Buffer Pools. Overview. Pages. Virtual Buffer Pools and Hiperpools. Buffer Pool Queue Management. I/O Requests and Paging. Page Externalization. Buffer Pool Parameters. Internal Thresholds. Buffer Pool 0 (BP0). Virtual-Pool Design Strategies. DSNDB07: A Different Kind of Buffer Pool. Code, Decode, Reference, and Lookup Tables. The Hit Ratio. Tuning with the DISPLAY BUFFERPOOL Command. RID Pool. Size. Statistics to Monitor. Effects on Optimization. SORT Pool. DB2 and Sorting. Size. DSNDB07 Work Files. Application Impacts. EDM Pool. Size. EDM Pool Efficiency. EDM Pool Issues. Section 2. Database Design and Tuning. 4. Catalog and Directory. Overview. Catalog. Storage and Maintenance. Directory. SPT01 Skeleton Package Table (SKPT) and SCT02 Skeleton Cursor Table (SKCT). DBD01 DBDs. SYSLGRNX and SYSUTILX. Shadow Catalog. ODBC Catalog. Reducing Catalog Contention. Manually Updating Catalog Statistics. Key Correlation Statistics. Catalog Queries. Queries to Use with EXPLAIN Output. Finding Extraneous Authorizations. Identifying Partitioning Keys. Determining When to REORG an Index. Determining Foreign Keys without Indexes. Showing Foreign Keys Fully Supported by Indexes. Identifying Index Columns. Primary Key Information. Tables to Index to Keys to Columns. Determining RI Relationships. Synonyms Not Used. Displaying Multicolumn Cardinalities. Validating Manually Updated Multicolumn Cardinalities. Re-engineering DDL from the Catalog. 5. Physical Database Objects. Guidelines for Optimal Design. Table Spaces. Table Spaces per Database. Segmented Table Spaces. SEGSIZE. Tables per Table Space. Partitioning. Table Space Compression. Free Space. Data-Set Closure. LOCKSIZE. Lock Escalation. Selective Partition Locking. Reorganizing Table Spaces. Tables. Normalization. Denormalization. Splitting Tables Based on Usage. Auditing. Columns. Ordering. VARCHAR Columns. Determining the Row Length. COMMENT ON Clause. NULL Usage. Distinct Data Types. Identity Columns. Nonattribute Columns. Referential Integrity. Mapping Logical Relationships to Physical RI Relationships. When to Use Declarative RI. Table Check Constraints. RI or Table Check Constraints. Indexes. Clustering Index. Primary-Key Indexes. Surrogate-Key Indexes. Indexes on Foreign Keys. Nonpartitioning Indexes. Reorganizing Indexes. Views. Base Table Views. Views versus Direct Table Access. Schemas. 6. VLDBs, VLTBs, and Warehouses. Very Large Databases (VLDBs). Very Large Tables (VLTBs). Nonpartitioning Indexes.

SynopsisThis is the first comprehensive core book on the DB2 database, its characteristics and how to tune it for maximum performance. The authors are the leading and most visible expertsin DB2 in the world, having written over 1000 articles on the subject. The foreword is by: Roger Miller, DB2 Lead Architect, IBM Corporation. Covers Version 7 of DB2., A core book on DB2, including coverage of the Version 7 of DB2, its key characteristics, and how to tune it for maximum performance. This book delivers the real-world optimization information for both developers and administrators.

LC Classification NumberQA76.9.D3Y48 2001