Featured Title:
DB2 for z/OS and OS/390 Development for Performance ( Volume 1 and Volume 2 )
by Gabrielle Wiorkowski

Publisher's summary:
DB2 for OS/390 and z/OS Development for Performance provides in-depth coverage of the design and development of application systems for performance using DB2. The book includes many examples of high performing SQL, including actual timings to indicate the order of magnitude improvements that the guidelines discussed enable. Wiorkowski, a DB2 consultant and former IBM Advisory Systems Engineer specializing in DB2, provides practical examples, hints, tips, and guidelines for the design and development of application systems.

Chapters include:

1. Concepts and Components
2. Creating STOGROUPs, Databases, and Buffer Pools
3. Creating Tablespaces
4. Creating Tables and Views
5. Index Usage for Performance
6. Index Design for Performance
7. The Basics of SQL Data Manipulation
8. Concurrency Control
9. Program Development
10. Batch Processing
11.Triggering Actions in DB2
12. Stored Procedures
13. User-Defined Function
14. Program Preparation and Execution
15. Join Performance
16. Subselects and Table Expressions
17. Parallel Processing
18. Programming for Performance
19. The Optimizer
20. Explaining the Access Path Chosen by the Optimizer
21. Load and Check Data Utilities
22. Runstats and Reorganization
23. Copy, Quiesce, Report, Rebuild, Recover, & Rebuild
[ More Info ]