DB2: Concepts, Programming and Design

Overview

DB2,announced in 1983,has quickly replaced IMS as IBM's premier database product. This book covers key DB2 concepts from the perspective of DB2 Version 2,the most recent release of DB2,and provides a sample database that can be created on DB2 systems. Covered here are new topics such as: DB2 and IBM's Systems Applications Architecture; OS/2 EE and CSD; DDBMS (Distributed Data Management); IBM's implementation of DDBMS in OS/2 and DB2. Other key DB2 topics that are discussed here include: relational data model (including referential integrity); SQL and DB2 utilities; query processing and QMF; catalog and directory; application processing and CICS transaction management; security and authorization; flow of SQL,explain and performance; connection protocols and threads; data integrity,locking and concurrency; and logical database design.