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.
Table of ContentsPart I: Introduction to DB2.
Part II: Data Manipulation Language.
Part III: Query Management Facility.
Part IV: Application Programming.
Part V: Design and Implementation of a Database.
Part VI: Miscellaneous Topics.
Appendices: A: Glossary B: DB2's System/CATALOG Tables.
D: Predicate Types and Processing.