DB2 Performance

This book describes programming techniques to design and implement better performing DB2 systems. Among the subjects covered are: coding and programming techniques; program design considerations; debugging hints; performance considerations, including tradeoffs, CICS/DB2 design, and referential integrity; SQL commands; and DB2 internals and architecture. The book also contains practical examples of SQL code and implementation techniques, illustrations of the more advanced features, tips on using implicitly or explicitly created tablespaces, and thorough treatment of DB2 in a CICS environment with its design and implementation techniques.