DB2: Maximizing Performance of Online Production Systems

DB2: Maximizing Performance of Online Production Systems Updated to cover DB2 Release 2.4. Inmon’s classic shows you how to maximize performance and availability in OLTP applications through minimum I/Os. Database designers, system developers, programmers, managers — anyone who needs high performance and high availability in an online system — will learn how to 1) create DB2 structures: databases, table spaces, tables, indexes and views; 2) design and load DB2 tables and efficiently accomplish specified business needs, including extract data from other databases; 3) prepare, test, debug and run DB2 application programs; and 4) maximize performance and availability in online production applications. Contents: Establishing the Production Environment: The DB2 Environment, From Logical to Physical Design in DB2. DB2 Database Online Performance Design: DB2 Performance, DB2 Transaction Design for Performance, DB2 Application Design; Data Structures and Data Relationship, Referential Integrity, The DB2 Batch Environment, Testing DB2 Production Systems (The DB2 Test Environment, Testing Programs in DB2), Bills of Material Processing, Denormalization, High Availability, Extract Processing, DB2 Technician’s Tape: Detailed Design and Tuning. An Introduction to Data Locking in DB2, Archival Processing, Strategic Positioning of DB2 — High Performance System. Glossary. Bibliography. Annexes. Index.